+353 1 279 0020 and +353 86 2471404sales@olas.ie Olas: Professional, Direct, Clever & Helpful
Home / General / 12 Tips of Christmas – Excel

12 Tips of Christmas – Excel

Category: General
Avoid missing content when you double click the fill handle to copy formulae down a column

Double clicking your mouse to fill a formula down a column can lead to problems if there is a gap in the data.

To overcome this issue simply double click your mouse on the bottom line of a cell to swiftly move to the fist/last entry in the column. This will quickly show you if there are any gaps in your entries.

You can use this tip to move to the first or last entry in any row also by double clicking on any of the external line of the cell.

Contact Us

Drop us a line, include your contact details and we will get back to you as soon as possible.