Excel Keyboard Shortcut to Open Format Cells Options

open format cells

To open the format cells options in Excel, you need to select a cell or a range of cells and then press the following keyboard shortcut.

Control + 1

When you press the above shortcut key, it instantly opens the format cells option which gives you the following dialog box.

How to use shortcut key to format cell

  1. First of all, select a cell or a range of cells where you want to use the format cells options.
  2. After that, press and hold the Control key from the left side of the keyboard.
  3. Next, press the 1 key from the top of  keyboard.
  4. In the end, select the tab from the options.

Free Excel Templates

Absconding-Letter-Excel-Template

Absconding Letter

What is absconding letter? A company issues an absconding letter …

Blue-expense-report

Expense Report

Download our user-friendly Expense Report Template in Excel and start …

General Register and Bonafide Generator

General Register and Bonafide Generator

School General Register and Bonafide Generator is ready-to-use excel template …

F1_MotoGP_Dashboard

Formula 1 Dashboard and Championship

This is 2018 Formula 1 Dashboard and Championship Tracker spreadsheet. If …

We Create Your Life Easy With Our Free Excel Templates & Spreadsheet Dashboards

Use free Excel Templates, Tools and Dashboards to create and draft a professional looking dashboards and computation sheet for your personal and business use. You can Explore Calendars, Activity Planners, Invoice Templates, Sales Forecast Sheets, Budget templates and various business information delivering Templates in Excel and Spreadsheet at XLSX Templates. 

These templates, dashboards and tools are useful in various occasions. You can also customize these templates as per your requirement. Modification of fields and data source helps in making the template more relevant.

Learn Microsoft Excel : Blogs and Articles

Learn about various tips and tricks in Microsoft Excel and Spreadsheet. Create best templates and dashboards using free tricks and tutorials in excel and spreadsheet. These tutorial posts are useful for everyone who wants to master the skills in excel and spreadsheet.