SUMMARY: In Excel 2010, alter the standard gridlines so they appear in blue, green, or yellow.Read More
Category: Microsoft Excel 2010
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
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?
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.
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.
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.