IT Support Services | Data Backup | Security | Ransomware Removal | Reviews | Careers | Videos (973) 882-4644 Get A Quote Remote Support
Contact Us

Tip of the Week: Handy Tricks to Formatting Excel Spreadsheets

Search a domain

www.
Tip of the Week: Handy Tricks to Formatting Excel Spreadsheets

Almost everybody uses Microsoft Excel for spreadsheets. However, there are many handy formatting capabilities and shortcuts that very few people know about. Today we’re sharing some tips to help you use Excel better and faster.

Quick and Easy Table Format

When you have a data set that outlines different related data points, a table is one of the best ways to visualize it. If your data is already in a spreadsheet, create a table by selecting a cell, pressing Ctrl + T, and then Enter. That was easy.

Excel Formatting Shortcuts

Here are some quick formatting shortcuts could that make your spreadsheet easier to understand.

You already know Ctrl + B for bold, Ctrl + I for italics, and Ctrl + U for underline, but there are plenty more:

  • Ctrl + 5 marks text with a strikethrough.
  • Ctrl + 1 brings up a format dialog box for your selection.
  • F4 repeats the last action, which makes it easier to apply specific formatting to certain cells.

Icon Sets Provide Visual Organization

Adding icons to your cells is an easy way to provide visual organization. Select your cells and click on Conditional Formatting under the Home tab. Go to Icon Sets and select the icon you want.

Icons can differentiate between certain data ranges. For example, with the option with three arrows, the lower 33 percent gets a downward arrow, the middle 33 percent gets the sideways arrow, and the top 33 percent gets an upward arrow. These numbers shift automatically with the number of items in your data set.

What Excel formatting tricks do you know? Share them in the comments below!

  • Was this Helpful?
  • YesNo

Comments are closed.

About Us

Since 2002 Quikteks has provided cutting edge, reliable business technology solutions to small and medium sized businesses in the Tri-State area. Our support solutions include technical help desk support, computer support and advising in order to deliver enterprise level IT solutions to the small and medium-sized business sectors at affordable rates.

Contact Us

info@quikteks.com
(973) 882-4644
373 US 46 Fairfield, NJ 07004

Connect With Quikteks
Reviews Referral Program Press Releases Newsletter Archives Careers
© 2020 Quikteks, LLC. All Rights Reserved