• Blog
  • Excel Downloads
    • Audit Tickmark Toolbar
  • Courses
    • Power BI
  • Contact
  • Checkout

Excel Zoom

...because it's more than just a calculator


10 Excel Tips For Increased Productivity

July 4, 2014 by Mark 4 Comments

Excel Tip #8: Create a New Custom Formatting Style

Excel Tip New FormatIn the previous tip, we looked at how to use the default Excel formats to quickly style your tables and other cells.

If none of those formats are exactly what you were looking for, then create your own style.

To create your own format in Excel:

  1. Select a single cell in your worksheet.
  2. Apply the desired formatting to the selected cell. Any formats are possible, including backgrounds, fonts, borders, etc.
  3. Click the Cell Styles button in the Styles group on the Home tab.
    • If you don’t see the Cell Styles button, you can click the down arrow next to the different formats to open up the Cell Styles menu.
  4. Click the New Cell Style link at the bottom of the menu.
  5. All the included styles will be shown in the Style window.
    • Give a descriptive name for your style in the Style name box.
    • Un-check any of the included styles you don’t want to have applied to your custom style.
    • If you want to edit some of the styles, click the Format button, and make the necessary changes.
    • Click OK.
  6. Your style will be added to the Cell Styles menu in the Styles group on the Home tab under the Custom heading.

If you ever want to remove or edit your custom style, simply right click it and select Delete or Modify as appropriate.

Pages: 1 2 3 4 5 6 7 8 9 10 11

Filed Under: Tips Tagged With: Automatic, Cell, Formats, Shortcuts, Tips

Looking For More Help?

Contact us with any specific questions or feedback. We love to hear from you!

Recommend a new product and EARN! Contact us here for info

Need to level up your career? See our amazing Excel Courses here

Looking for the Excel Audit Tickmark Toolbar? Click Here, NOW ONLY $97!

Subscribe to our mailing list
  • Facebook
  • Twitter

Search this site…

Power BI Webinar
Power BI Course
Free Excel Dashboard Webinar

Copyright © 2025 · Magazine Pro Theme on Genesis Framework

Login Form

Lost your password?