In Order to Clear / Unfilter a filter quickly you can use the Filter Hotkey Two Times :
Press 2 Times : CTRL + SHIFT + L
Showing posts with label shift. Show all posts
Showing posts with label shift. Show all posts
Monday, March 14, 2016
Excel Tip: Clear / Unfilter FILTERs Quickly
Wednesday, February 24, 2016
Excel Tip: Write and Edit Formulas in several sheets at the same time!
You can Edit several Worksheets in Excel at the same time just by Selecting multiple Sheet Tabs through holding the SHIFT button.
After the Sheets are selected you can keep on editing them until you click in one specific WorkSheet again.
After the Sheets are selected you can keep on editing them until you click in one specific WorkSheet again.
The selection of Sheets can be used to input formulas and to edit the format of cells.
Created by DoMyExcel.com © | Excel & VBA Consulting | Customized Excel Solutions starting at 29 USD
Subscribe to:
Posts (Atom)