Excel Shortcuts - Ctrl+1 to Format Selected - Episode 2115
4,082 views · Published 24 July 2017 · 1:27 · Indexed 30 October 2026
Channel: MrExcel.com · 2017 · Education
Microsoft Excel Tutorial: Master Excel Formatting with Ctrl+1 Shortcut! Microsoft Excel Keyboard Shortcuts. A favorite keyboard shortcut is Ctrl+1 to format anything. Select a cell or an object in Excel. Press Ctrl+1 to Format that item. Welcome to another episode of MrExcel broadcast! In this episode, we will be discussing one of my all-time favorite keyboard shortcuts in Excel - Ctrl+1. This simple shortcut allows you to quickly format any selected cells, saving you time and effort. As mentioned in my book, MrExcel, I often ask people for their favorite keyboard shortcuts and Ctrl+1 is one that comes up over and over again. It's a versatile shortcut that can be used in various situations, making it a must-know for any Excel user. Whether you want to change the font, add borders, or adjust the number format, Ctrl+1 has got you covered. It's a powerful tool that can help you customize your data and make it more visually appealing. So if you want to save time and make your Excel experience more efficient, be sure to add Ctrl+1 to your list of go-to shortcuts. Buy Bill Jelen's latest Excel book: https://www.mrexcel.com/products/latest/ You can help my channel by clicking Like or commenting below: https://www.mrexcel.com/like-mrexcel-on-youtube/ In this podcast episode, the speaker discusses a keyboard shortcut in Excel that allows users to quickly access the format dialogue box for any selection. By pressing control one, users can easily format various elements such as currency, font color, objects, and even charts. The speaker demonstrates how this shortcut can be used to change the font color, adjust the color of an icon, and modify the alignment of labels in a chart. This shortcut is highly recommended by the speaker and is a convenient way to access the format dialogue box for any object in Excel. #excel #microsoftexcel #exceltricks #excelhacks #excelshortcut #evergreen #shortcutkey #excelformatting This video answers these common search terms: what shortcut in excel is formattin excel shortcut to format selected cells shortcut to format cells shortcut to format object in excel Table of Contents (0:00) Shortcut to Format Selection (0:10) Favorite Excel keyboard shortcut (0:20) Ctrl+1 opens the appropriate Format dialog (0:30) Number format or text color for cell (0:40) Formatting icon in Task Pane (0:50) Formatting chart labels in Excel (1:05) Rotate chart labels to vertical (1:15) Clicking Like really helps the algorithm Join the MrExcel Message Board discussion about this video at https://www.mrexcel.com/board/threads/1153940/
More from this channel
-
2:13
Excel Calculate Decimal Hours from two Time Cells - Episode 902
-
3:57
Excel 2007 - Color of Selected Sheets is too much like unselected sheets - Episode 907
-
2:48
Excel - Adding Equals Icon to Excel QAT - Build Formula with Mouse - Episode 911
-
3:30
Excel Grouping Percentages into Buckets for a Pivot Table - Method 2 - Episode 913
-
2:04
Excel Change Color of Selected Cells - Episode 914
-
4:38
Excel - Auto Numbering a List with Frequent Inserts & Deletes - Episode 916
-
2:00
Excel Hiding Data in Plain Site - Episode 919
-
2:20
Excel - Bring Back The Full Excel 2003 Dialogs In Excel! - Episode 920