Settings in Excel 2007
Every workbook uses a palette of 56 colors, but you can change palette for the current workbook or even change the default colors for new workbooks.
You can greatly reduce data-entry problems in your workbooks by making Excel check entries before entering them in specific cells. To do so, you need to define restrictions and data-validation rules for those cells.
Excel 2007 no longer has a menu (unless you call Home, Insert, Page Layout, etc., a menu), and you can't customize what's not there. Excel does still have context-sensitive right-click menus. However, unlike in previous versions of Excel, the user interface no longer provides a way to customize them.
If you prefer to avoid the empty workbook to be created when Excel starts up, you can do so by editing the command line that is used to start Excel.
Excel automatically creates three worksheets in each new workbook, but you can force it to create as many worksheets as you need.
When you need as much space as possible on screen to view a workbook, you can collapse (or minimize) the Ribbon to only its labels by double-clicking the label of the tab you're currently using.
Suppose you'd like to add a couple more commands to the Quick Access toolbar. Perhaps you miss the menu in earlier versions of Excel that let you quickly switch between open Excel windows. Also, say you're a big fan of AutoSum. You can add the AutoSum button to the Quick Access toolbar, so you can quickly create and use AutoSum entries.
If you are creating chart or diagram in Excel with shapes, you might need to update the shape text automatically depending on the value in a particular cell.
If you assigned a key combination to a macro when you recorded it, you can run the macro by pressing that key combination. If not, you can subsequently assign the macro to the menu item.
If you're willing and able to edit the Registry on your computer, you can change Excel's number of Undo levels.