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

Watch on YouTube

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