Filling empty cells in a range:

In the example below, we have a table with two columns. In the first column we have dates and we have amounts in the second column .

To apply a filter on the data in the “Date” column, it is better that each cell of the table contains data, otherwise we have to deal with empty cells in the filter list.

We are going to fill dates in the cells of the “Date” column.

Click in the cell A2, and keep the Shift key pressed and click on cell A22 (To select all the cells of the table including the cells of column B, also, you can use the Ctrl + Shift + * combination). Then click the “Home” tab in the “Ribbon” , click “Find and Select” button and, select “Go to Special” in that menu.

In the “Go to Special” dialog box, select “Blanks” and click OK.

You can now see that all the empty cells in the date column are selected (1) and the focus is on cell A3 (2).

With the cells still selected, type an equal sign, press the up arrow key and then press Ctrl + Enter; i.e, “=up arrow+ Ctrl + Enter”.

Now, when you want to filter, you will not have empty cells in the filter list.

Featured Courses

• Downloading iPad Apps
• Lesson 1: Introduction to Publisher
• Lesson 65: File Formats