Hyperlinks automate Excel worksheets by making the opening of other Office documents and Excel workbooks and worksheets just a mouse click away. It doesn't matter whether these documents are located on your hard drive, a server on your LAN (Local Area Network), or Web pages on the Internet or a company's intranet.
Instead of entering the records of a data list directly in the table, you can use Excel's data form to make the entries. The only problem with using the data form is that the command to display the form in a worksheet with a data list is not part of the Ribbon commands.
Creating a new data list in a worksheet is much like creating a worksheet table except that it has only column headings and no row headings.
The Selection and Visibility task pane enables you not only to change the layering of various graphic objects in the worksheet but also to control whether they are hidden or displayed.
If selecting gazillions of preset shapes available from the Shapes gallery doesn’t provide enough variety for jazzing up your worksheet, you may want to try adding some fancy text using the WordArt gallery opened by clicking the WordArt command button in the Text group of the Insert tab.
Clip Art is the name given to the over 150,000 ready made illustrations offered by Microsoft for use in its various Microsoft Office programs, including Excel 2007. Clip Art drawings are now so numerous that the images are classified into a bunch of different categories ranging from Abstract to Web Elements.
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.
After creating a pivot table, you can create a pivot chart to display its summary values graphically in literally two really simple steps:
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!
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.
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).
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.
By assigning descriptive names to cells and cell ranges, you can go a long way toward keeping on top of the location of important information in a worksheet. Rather than try to associate random cell coordinates with specific information, you just have to remember a name.
Cell names are not only a great way to identify and find cells and cell ranges in your spreadsheet, but they're also a great way to make out the purpose of your formulas. For example, suppose that you have a simple formula in cell K3 that calculates the total due to you by multiplying the hours you work for a client (in cell I3) by the client's hourly rate (in cell J3).
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.