How To Filter By Colour

Earlier this week a customer asked me how she could filter a list based on strikethrough. She had a multi-column list similar to the following: The file was opened several times a day by different people who reviewed each entry and if appropriate, marked it for...

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...