SUMMARY: A keyboard shortcut to manually add a line break inside a cell.
Category: Microsoft Excel 2010
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.
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.
SUMMARY: A few mouse clicks or a keyboard shortcut are all it take to clear formatting from a cell or group of cells.
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.
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.