If you want to scroll sideways (horizontally) in Excel, you can use the scroll bar on the bottom of the page, or you can use these shortcuts:
Category: Uncategorized
Excel Shortcut: Add Filter
If you want to add filters to your headers in a table in Excel, you can go to Data > Filter, or simply use this shortcut:
Ctrl + Shift + L
READ MOREExcel shortcut: Copy the cell to the left
If you want to copy the cell to the left of your selected cell, you can use the shortcut Ctrl+R. This also works with ranges, e.g. if you want to copy the range A1:A5, you can select B1:B5 and use the shortcut.
Ctrl + R
READ MOREExcel shortcut: Copy as Picture
If you want to copy a cell, a range, or an object in Excel as a picture, you can select a cell or an area, go to the Home tab, click on the little arrow next to “Copy” and choose “Copy as Picture”.
Or if you prefer a shortcut instead of using the mouse, you can use the following shortcut to copy as picture:
Alt > H > F > S
Select a cell, a range or an object, press the Alt key and release it before you press H, C, P and Enter.
READ MOREExcel shortcut: Change Font Size
If you want to change the font size in Excel, you can select a cell or an area, go to the Home tab and click on the little font size section. Or if you prefer a shortcut instead of using the mouse, you can use the following shortcut to change font size:
Alt > H > F > S
Select a cell or a range, press the Alt key and release it before you press H, F and S.
READ MOREExcel shortcut: Open a new workbook
Excel Shortcut: Open a new workbook in Excel
If you want to open a new workbook in Excel, you can go to File > New, or simply use this shortcut:
Ctrl + N
READ MOREExcel shortcuts: Close workbook and close Excel application
Excel shortcuts: Close workbook and close Excel application
If you want to close your currrent workbook in Excel, you can go to File > Close, or simply use this shortcut:
Ctrl + W
READ MOREExcel shortcut: Lock a cell reference
If you want to lock or unlock a cell reference in Excel, ie. toggle between relative and absolute references, you can type a Dollar sign in front of the reference you want to lock (A1 > $A$1, $A1 or A$1), or you can select the cell reference or range and use this shortcut:
F4
Excel shortcut: Change to Edit Mode
If you want to edit your formula in Excel, you can either use the mouse and click in the formula bar, or you can use this shortcut:
F2
Excel shortcut: Print
If you want to print your workbook, you can go to File > Print, or you can use this shortcut: