Category: Microsoft Excel 2010

Change Worksheet Gridline Colors to Fit Your Mood

SUMMARY: In Excel 2010, alter the standard gridlines so they appear in blue, green, or yellow.Read More

Stop Typing Decimal Points for Currency and Other Figures

SUMMARY: Entering a large number of currency values into an Excel 2010 worksheet or other numbers that need decimal points placed in every value? Have the software add the decimal points for you.Read More

Remove Duplicates from a Selection of Data

SUMMARY: Quickly clear duplicated information from an Excel 2010 worksheet.

Read More

Choose Where Saved and AutoRecover Files Go

SUMMARY: If you need to store workbooks and AutoRecover files elsewhere, configure Excel 2010 as to where they should be placed.

Do you have multiple hard drives or partitions and want to save Microsoft Excel 2010workbooks and AutoRecover files on a location reserved for data? Or do you just want to organize your files differently on your one hard drive / partition?

Read More

Add Caps Lock, Num Lock, Scroll Lock Indicators

SUMMARY: See at a glance whether or not the Caps Lock, Num Lock, or Scroll Lock buttons have been pressed via indicators on the Excel 2010 Status Bar.

By default, Microsoft Excel 2010 displays an indicator in the status bar whenever the Scroll Lock key has been pressed. This is useful as when Scroll Lock is selected, pressing cursor keys do not move the cell selection, instead scrolling through the current worksheet.

Read More

Hide Recent Documents or Show More

SUMMARY: Configure Excel 2010 to hide the list of recent documents for privacy, or show more of them.

Read More

Rotate Text for Effect

SUMMARY: Make header cells in an Excel 2010 worksheet stand out by rotating text.

Read More

Working on a Wide Worksheet? Make ENTER Move to the Right

SUMMARY: If you’re editing a wide worksheet with the 10-key, you might find it more convenient to have the ENTER key move the cursor to the cell to the right.

Read More

Change the Tab Color of a Worksheet

SUMMARY: Tabs representing different worksheets in an Excel 2010 workbook can be colored for organizational purposes.

Read More

Repeat Columns and / or Rows on Every Printed Sheet

SUMMARY: If information in particular rows or columns need to be repeated on every page, here’s how to configure Excel to do so.

 When scanning printouts of larger Microsoft Excel 2010 worksheets, by the time you get to the 10th page or so you may forget the type of data represented by each row or column. To solve this problem, you can configure Excel to repeat certain rows and/or columns on every page that you add to describe the data.

Read More