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: https://www.facebook.com/howtoexcelblog Twitter: https://twitter.com/howtoexcelblog LinkedIn: https://www.linkedin.com/in/john-macdougall/ Thanks for all your support!

Category