Solutions Through Learning
Forum home » Delegate support and help forum » Microsoft Excel Training and help » formulas
Trish,
AutoFilter is an easy way to turn the values in Excel column into specific filters based on the cell contents.
For a good, detailed tutorial of how it works, I found this page the other day:
http://www.timeatlas.com/mos/5_Minute_Tips/General/Excel_AutoFilter_Makes_Spreadsheets_More_Useful/
Regards, Rich
In Excel 97 and 2000 it was known as the Paste Function dialog box, these days it's known as the Insert Function dialog box. Regardless, one has to choose Insert|Function. or the fx button to open it up. There is, however, a non-mousey way to get hold of the Insert Function dialog box: press Shift+F3 in a blank cell to open the Insert Function dialog.
Press Shift+F3 after a function name and open bracket to open the Function Arguments dialog. For example, type =VLOOKUP( into a cell and press Shift+F3 to obtain a detailed description of VLOOKUP's arguments.
TrustScore
4.9
/ 5
2394 reviews
Connect with us:
Call for assistance
We will call you back
Formerly Best Training
© 2025 STL. All Rights Reserved.
All prices offered for business users and exclude VAT. E&OE
2nd Floor, CA House, 1 Northey Street, Limehouse Basin, London, E14 8BT, United Kingdom.
