AutoFill Copies Values Not Formulas

Last year I recorded a short video about the “Fill Handle” (the little black cross that allows you to quickly copy or autofill) in Excel not working. If you haven’t seen the video, check it out here. I received a query this week about the video...

Double Click AutoFill Not Working

Yesterday a comment was left on one of my YouTube videos regarding the use of the “Fill Handle” – this is where you point your mouse at the bottom right hand corner of a cell, the mouse pointer changes to a little black cross and you can double click...

AutoFill & Filters

Using AutoFill you can fill a column or row of cells with numbers, dates, days of the week, months of the year and other pre-defined data lists. For example, to fill column G with consecutive numbers starting at 1, type 1 into G4 and 2 into the cell below, select both...