Excel Tips: Shortcut Keys

File

How to automatically expand formula bar in Excel?

How to quickly toggle between formula and value with a shortcut in Excel?

How to show or hide outline symbols in Excel?

How to switch workbooks in Excel?

How to type in or edit cell without double clicking it in Excel?

Edit

How to insert current day or month or year into cell/header/footer in Excel?

How to quickly select non-adjacent cells or ranges in Excel?

How to concatenate columns with Alt + Enter in Excel?

How to copy cell above or cell left with shortcut key in Excel?

How to display system time or date in Excel?

How to enter the same data/formula in multiple cells at once in Excel?

How to extend selection to the end of column or entire row in Excel?

How to go back to previous active sheet cell after clicking hyperlink in Excel?

How to move or go to last row/last column with data in Excel?

How to quickly go to the bottom of a selection in Excel?

How to quickly insert timestamp in Excel?

How to quickly jump back to previous cell in Excel?

How to quickly jump between two tabs in Excel?

How to quickly jump to a specific cell (A1) in Excel?

How to quickly jump to next cell with data in Excel?

How to quickly jump to next unique value in an Excel column?

How to quickly move to the end of column or row in Excel?

How to quickly move to top left cell or A1 cell in a large worksheet?

How to quickly select large range of cells in a worksheet?

How to rename worksheet without using mouse in Excel?

How to retrieve date and time from computer in Excel?

How to select entire column except header/first row in Excel?

How to select multiple or all sheet tabs in Excel?

How to toggle between hidden and visible columns in Excel?

How to toggle between sheets by shortcut keys in Goolge sheet?

How to use shortcut keys to paste special into Excel?

How to use shortcut keys to select rows/columns/data/tabs in Excel?

How to use shortcut to remove duplicates in Excel column or row?

Insert

How to quickly insert multiple blank rows or columns in Excel at once?

How to use shortcut keys to insert or delete row/column/tab in Excel?

How to automatically insert rows in Excel?

How to create bulleted list in a cell or multiple cells in Excel?

How to hide selected items in pivot table?

How to insert bullet points into cells of Google sheet?

How to show or insert division symbol in cell in Excel?

How to wrap X axis labels in a chart in Excel?

Format

How to add all borders to cells with shortcuts in Excel?

How to auto fit column width in Excel?

How to force or auto line break within an Excel cell?

How to format part text as superscript or subscript within a cell?

How to use shortcut to quickly format cells as number/text/general or other format in Excel?

Calculation & Formulas

How to quickly apply formula to an entire column or row with/without dragging in Excel?

How to keep formula cell reference constant in Excel?

How to anchoring formula cells (change cell reference to absolute) in Excel?

How to AutoSum multiple rows/columns/worksheets in Excel?

How to change relative reference to absolute reference in Excel?

How to change/convert absolute reference to relative reference in Excel?

How to force formula to always use same cell in Excel?

How to highlight all cells referenced by a formula in Excel?

Others

How to auto add date and time to comment in Excel?

How to group adjacent columns or rows separately or independently in Excel?

How to repeat the last or previous action in Excel?

How to sort linked data and keep formulas in Excel?

How to use shortcut to quickly insert/delete comment in active cell?