Forum home » Delegate support and help forum » Microsoft Excel Training and help » excel training in london - Filters

excel training in london - Filters

ResolvedVersion Standard

Thu 1 Mar 2007, 10:01 Delegate Christina said...

Christina has attended:
Excel Advanced course

Filters

I have noticed that sometimes filters do not list all items underneath if there are blank lines within the spreadsheet, whereas it does on other occasions. How can I ensure that a filter will include all items underneath?

Fri 2 Mar 2007, 14:49 Trainer Amanda said...

RE: Filters

Hi Christina

To ensure that all items in a column were listed in a filter dropdown list, you would have to eliminate any blank rows from the list to be 100% sure all items were included.

thanks
Amanda

Training courses

98.2 % recommend us

More live stats...

Training information:

Excel tip:

Moving between split pane sections in a spreadsheet

If you have used the split panes feature in your worksheet, use the following keyboard shortcut keys to move quickly and effortlessly between paned sections:

F6 - Move to the next pane
Shift + F6 - Move to the previous pane

View all Excel hints and tips