Category: Microsoft Excel 2010

Quick Tip: Add a Manual Line Break

SUMMARY: A keyboard shortcut to manually add a line break inside a cell.

Read More

Hide Worksheet Tabs, Scroll Bars if Not Needed

SUMMARY: If you’re only using one worksheet in an Excel 2010 workbook, why display the worksheet tabs if you’ll never use them? Also learn how to hide one or both scroll bars if not needed.

 While some complicated Microsoft Excel 2010 workbooks may have dozens, if not more worksheets, you may sometimes create workbooks that only require one worksheet tab. In this case, why show the worksheet tabs if you don’t need to use them? By hiding these tabs, and also the horizontal and / or vertical scroll bars, you can slightly increase the room onscreen used to display your workbook.

Read More

Show Trends Inside a Cell via Sparklines

SUMMARY: Display miniature graphs, sparklines, showing trends in a series of data in an Excel 2010 worksheet.

Read More

Save AutoRecover Data More or Less Often

SUMMARY: Is 10 minutes too long a time to wait between saving AutoRecover information in Excel 2010 to potentially prevent data loss? Change this interval.

Read More

How do I Spell Check a Worksheet?

SUMMARY: Other Office 2010 apps automatically check document spelling, but not Excel 2010. Here’s how to perform a manual spell check.

This tip is for Microsoft Excel 2010 beginners.

While other Office 2010 applications automatically spell check a document, this does not happen in Excel 2010. This is presumably because most worksheets contain primarily numerical data, and may contain headers and other descriptor text (such as acronyms or business names) that won’t be found in the dictionary. However, mistakes can happen even when tyipng (sic) just a little bit of text, so here’s how to manually spell check an entire worksheet or just part of one.

Read More

Double or Accounting Underline Text

SUMMARY: Choose from several underline styles in an Excel 2010 workbook.

Read More

Filtering Data in a Worksheet, with an Example

SUMMARY: Instructions on how to filter data in an Excel 2010 worksheet, with screenshots showing filters performed on an example worksheet.

Read More

Clear Cell Formatting

SUMMARY: A few mouse clicks or a keyboard shortcut are all it take to clear formatting from a cell or group of cells.

 Have you ever had a cell or group of cells in a Microsoft Excel 2010 worksheet that contain a lot of formatting applied, such as combinations of different fonts, colors, underline styles, effects, etc.? If you need to remove formatting from these cells try the following:

Read More

For Worksheet Drafts Print Default Headings And / Or Gridlines

SUMMARY: Don’t want to spend time manually creating border lines or headers for a particular draft worksheet? Have Excel 2010 print default gridlines and column headings.

 Though a simple tip, if you didn’t know how to do this before, you’ll be happy to know this option is available. By default, Microsoft Excel 2010 does not print gridlines, expecting that you will add your own borders to presented data. The letter column headings are also not printed, as you are expected to create your own descriptors for data.

Read More

Stop Accidentally Showing the Ribbon Shortcut Keys

SUMMARY: While navigating through worksheets in Excel 2010, pressing slash on the keyboard shows the ribbon shortcut keys. Learn how to prevent this from happening.

While navigating through cells in a Microsoft Excel 2010 worksheet, have you ever seen letters and numbers appear next to options in the Ribbon like the below screenshot?

Read More