Although Excel automatically embeds all new charts on the same worksheet as the data they graph (unless you create using the F11 trick), you may find it easier to customize and work with it if you move the chart to its own chart sheet in the workbook.
Although Excel automatically creates all new pivot charts on the same worksheet as the pivot table, you may find it easier to customize and work with itif you move the chart to its own chart sheet in the workbook.
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.
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.
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:
In addition to varying the increment in a series created with AutoFill, you can also create your own custom series. For example, say your company has offices in the following locations and you get tired of typing out the sequence in each new spreadsheet that requires them.
Excel offers a wide variety of keystrokes for moving the cell cursor to a new cell. When you use one of these keystrokes, the program automatically scrolls a new part of the worksheet into view, if this is required to move the cell pointer.
There are various ways to hide comments that are made in your document. These tricks don't delete the comments. Instead, just like a good wrinkle cream, you can cover up the comments temporarily.
The quickest way to copy the formats from one cell to another cell or range is to use the Format Painter button in the Ribbon's Home tab.
Sometimes you have two versions of a workbook, and you want to compare the differences in the data visually. Excel provides a convenient feature that allows you to compare two documents side by side.
If you're no longer working with a excel workbook, you may want to close the excel workbook so that you can work on other documents without distraction. Closing unneeded excel workbooks also frees memory and minimizes potential screen clutter.