Tip 258 – Quickly highlight all formulas in a sheet
DOWNLOAD PDF If you are sent an Excel sheet and you wish to know which numbers have been typed in and which numbers are calculated by a formula, press the CTRL and G keys together to open the “Go To” dialogue box, click the Special button, select Formulas and then click OK. All cells containing […]
Tip 250 – Automatically create sequences
DOWNLOAD PDF Excel can automatically fill number, month and day sequences. For a month or day, type the first entry, such as Monday, and then click on the cell handle and drag down as many cells as desired and Excel will insert the rest of the days of the week. For a number, type the […]
Tip 242 – Print a section of an Excel sheet rather than the entire sheet
DOWNLOAD PDF If you only need to print off a small section of your Excel sheet, select the cells to Print, then press the CTRL and F2 keys together to open the print preview window. Under the settings options, select the drop down list labelled “Print Active Sheets” and select “Print Selection”.
Tip 238 – For quick edits, use the F2 key
DOWNLOAD PDF To quickly edit the name of a file, or the contents of an Excel cell, press the F2 key to quickly enter editing mode without having to use the mouse. Once the file or cell is selected, simply press the F2 key and start typing.
Tip 235 – Quickly filter data using the value of the selected cell
DOWNLOAD PDF If you would like to filter a list of information by the contents of the cell you currently have selected, rather than turning filters on, clicking the filter drop down list and locating the item, simply right click the cell and select Filter > Filter by Selected Cells value.
Tip 233 – Easily Copy Data from the Cell Above Using a Shortcut
DOWNLOAD PDF When you need an exact copy of the data from the cell above, in Excel, you can use a shortcut key. Press Control + ‘ to make a duplicate of the contents of the cell above the current cell. Dates, values and formulas are copied exactly so, using this shortcut, formulas won’t update […]
Tip 232 – Easily Select Non-Adjacent Ranges in Excel Using the Keyboard
DOWNLOAD PDF To select non-adjacent ranges using the keyboard, click in the first cell of the first range. Tap the F8 key and use the arrow keys to select the first range. Press Shift + F8 to turn off Extended Mode and arrow to the beginning of the next range. Press F8 and then use […]
Tip 231 – Quickly Copy Excel Data Validation Rules to Other Cells
DOWNLOAD PDF When you have data validation rules applied to a cell or range in Excel, you can copy those rules to other cells without having to re-creating them. To do this first select a cell that has the rules applied to it. Press Control + C to copy the cell. Select over all the […]
Tip 230 – Quickly Align Shapes, Charts and Images in Excel
DOWNLOAD PDF To quickly align shapes, charts, images or any combination thereof, first select all the objects. To do this, from the Home tab click Find & Select > Select Objects. Drag over the objects to select them and then, from the Drawing Tools > Format tab, click Align and click the desired alignment option […]
Tip 228 – Quickly Copy or Move a Sheet in an Excel Workbook
DOWNLOAD PDF To quickly copy or move a sheet inside an Excel workbook first click on tab of the sheet to copy or move. If making a copy of the sheet, hold the Control key and drag the sheet tab to duplicate it. If moving the sheet, simply drag the sheet to its new position. […]