Excel shortcut: Scroll sideways

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:

Alt + PageUp
Alt + PageDown

Scroll Sideways in Excel: Alt+PageUp og Alt+PageDown

Excel 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.

Copy as Picture in Excel: Alt > H > C > P
READ MORE

Excel 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.

Change font size in Excel: Alt > H > F > S
READ MORE

Excel 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

Toggle between absolute and relative cell references in Excel: F4
Toggle between absolute and relative cell references in Excel: F4