Creating a pivot table has never been as easy as it is in Excel 2007: simply open the worksheet that contains the data list you want summarized by the pivot table, position the cell cursor somewhere in the cells of this list, and then click the Pivot Table command button on the Ribbon's Insert tab or press Alt+NVT.
In some situations, you need to move a particular worksheet or copy it from one workbook to another.
The sheet names that Excel comes up with for the tabs in a workbook (Sheet1 through Sheet3) are, to put it mildly, not very original - and are certainly not descriptive of their function in life!
Locking workbooks in Excel is a great way to prevent yourself of breaking the whole thing when you are not suppose to touch it. Protect yourself from such actions by locking the whole thing.
After you more or less finalize a worksheet by checking out its formulas and proofing its text, you often want to guard against any unplanned changes byprotecting the document.
Certain formulas use constant values, such as a 7.5% tax rate or a 10% discount rate. If you don't want to have to enter these constants into a cell of the worksheet in order to use the formulas, you create range names that hold their values and then use their range names in the formulas you create.
When you create very long documents in Word like theses, annual reports, or even books .You may need to provide a table of contents. Your readers will be glad you did. What's more, if you did a good job of creating headers and subheads, then most of the hard work is done.
Most of the time, the stock headers and footers available on the Header buttons and Footer buttons drop-down menus are sufficient for your report printing needs.
Excel makes it easy to copy custom cell styles that you've saved as part one workbook into the workbook you're currently working on. To copy custom styles from workbook to another, follow these steps:
Although you can hide worksheet columns and rows by just adjusting them out of existence, Excel does offer an easier method of hiding them, via the Hide & Unhide option on the Format button’s drop-down menu (located in the Cells group of the Home tab).