1. Open more than one window of Excel
Excel files are opened in a same window in Windows 7. But there are times when you may like to have more than one window open, particularly when using two screens. You are able to do this by installing a quick fix, available here: http://support.microsoft.com/kb/26366702. Customise your default workbook
Excel opens with a default worksheet containing three sheets, despite the fact that most of the time you will only use one. Change Excel’s default settings by going to the File menu, then General, and then adjust the settings under “When creating new workbooks.” You can specify the default font and size, whether to open in normal or print-layout view, and the number of sheets to create.
3. Save your workspace
There are times when you will be working on two or more separate worksheets at the same time, each in a separate window, and you know you’ll want to work on the same set of worksheets again tomorrow. In this instance, before you shut down Excel, go to the View menu and click Save Workspace near the right side. In the Save Workspace dialog, enter a name and location for your saved view settings, and a Saved Workspace icon gets created in the location you choose, ready for the next day.
4. Apply the same formatting to multiple sheets
When you want to format multiple tabs in the same way, you just need to Ctrl-click the tabs of the sheets that you want to group together, and the grouped tabs will all turn white. While sheets are grouped, anything you enter in one sheet also gets entered into the others.
5. Select- All
You many know that Ctrl-A is the shortcut key that selects everything in a window or document. Ctrl-A works this way in every application you can find—except Excel. When you press Ctrl-A in a worksheet with data in it, you select the current region not the whole worksheet. However, you immediately press Ctrl-A a second time, you select the entire worksheet—unless the worksheet contains a table, in which case your second press of Ctrl-A will select the current region and the summary rows (typically the headers) of the current table. But if you press Ctrl-A a third time, you will select the entire worksheet.