microsoft excel training courses london - auto filter

Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

Forum home » Delegate support and help forum » Microsoft Excel Training and help » microsoft excel training courses london - Auto filter

microsoft excel training courses london - Auto filter

resolvedResolved · Low Priority · Version Standard

Richard has attended:
Excel Introduction course

Auto filter

how to get rid of auto filter buttons on my spread sheet

the auto filter will order alphabetically but only the one column. How do I get all the other colums (and data relevant to the cell which is moved) to move with the cell which is moved by the auto filter

thank you

Richard

RE: auto filter

Hi Richard,

To take the Autofilter off you can go into the Data menu down to Filter and where the AutoFilter has a tick on it you click on it and it will remove the filter.

The AutoFilter maintains the row order across the table, so when you order one column the rest should move with it. However if you highlight one column excel will only sort one column and leave the rest as they were.

Good luck

Tracy


 

Excel tip:

Autofit column width – Excel (all versions)

a. Highlight the column or columns you wish to alter the width of. You do this by clicking on the grey button at the top of the column showing the column letter. Click and drag on these letters to select more than one column.
b. Double click the dividing line between the columns. This dividing line is the break between the columns on the column headers (grey buttons showing the column letter at the top of each column). When you hover your mouse over one of these dividing lines the point will change and show an arrow pulling a line in two directions. When you have this mouse pointer you should double click to get Excel to automatically set the column width to fit the contents of the column (autofit)

View all Excel hints and tips


Server loaded in 0.08 secs.