Selecting more than one cell range is a little more complicated with the keyboard than it is with the mouse. When using the keyboard, you alternate between anchoring the cell cursor and moving the cell cursor to select the cell range and unanchoring the cell cursor and repositioning it at the beginning of the next range.
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.
You need to use more than one field in sorting when the first field you use contains duplicate values and you want a say in how the records with duplicates are arranged. (If you don't specify another field to sort on, Excel just puts the records in the order in which you entered them.)
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 comment tool in Word 2007 is a great way to proof-read a report or thesis paper and make notes to yourself instead of writing them onto a sheet of paper.
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.
A paragraph of text in Word sits snugly between the page's left and right margins. Those margins can be broken or extended, allowing you to indent the left and right sides of one or more paragraphs however you want. The secret is found in the Page Layout tab's Paragraph group.