18 Keyboard Shortcuts For Formatting Data In Excel
Ctrl + 1 - Open the Format Cells dialog box.
Ctrl + 2 - Apply or remove the bold format to a cell or range of cells.
Ctrl + 3 - Apply or remove the italic format to a cell or range of cells.
Ctrl + 4 - Apply or remove the underline format to a cell or range of cells.
Ctrl + 5 - Apply or remove the strikethrough format to a cell or range of cells.
Ctrl + B - Apply or remove the bold format to a cell or range of cells.
Ctrl + I - Apply or remove the italic format to a cell or range of cells.
Ctrl + U - Apply or remove the underline format to a cell or range of cells.
Ctrl + Shift + ! - Apply the thousands comma with two decimal places number format to a cell or range of cells.
Ctrl + Shift + # - Apply the date format to a cell or range of cells.
Ctrl + Shift + $ - Apply the currency format to a cell or range of cells.
Ctrl + Shift + % - Apply the percent format to a cell or range of cells.
Ctrl + Shift + & - Apply outside boarders to a cell or range of cells.
Ctrl + Shift + @ - Apply the time format to a cell or range of cells.
Ctrl + Shift + _ - Remove all borders from a cell or range of cells.
Ctrl + Shift + ~ - Apply the general format to a cell or range of cells.
Ctrl + Shift + F - Open the Format Cells dialog box with the Font tab active.
Ctrl + Shift + P - Open the Format Cells dialog box with the Font tab active. 👇
Check out my full courses and ebooks here
👉 https://www.howtoexcel.org/courses/
DOWNLOAD the example workbook here
📖 https://www.howtoexcel.org/downloads/
SUBSCRIBE & get my 3 FREE eBooks
📧 https://www.howtoexcel.org/newsletter/
CONNECT with me on social
Facebook: / howtoexcelblog
Twitter: / howtoexcelblog
LinkedIn: / john-macdougall
Thanks for all your support!
