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

FULL POST

Excel shortcut: Apply number format with two decimals and thousands separator

If you want to apply one of the most common number formats, with two decimals, thousands separator and a minus sign for negative values, you can go to the number format drop-down menu on the Home tab and choose More Number Formats in order to open the Format Cells dialog box, you can use the shortcut Ctrl+1 to open the same dialog box, or you can simply use this shortcut:

Ctrl + Shift + !

Example:
US: 2450 > 2,450.00
Europe: 2450 > 2 450,00

Apply number format with decimals and thousands separator in Excel: Ctrl+Shift+!
Apply number format with decimals and thousands separator in Excel: Ctrl+Shift+!

FULL POST