Microsoft Office Tutorials and References
In Depth Information
Using the Format as Table Gallery
Move the cell cursor to select all the cells in the first cell range.
Alternatively, hold the Shift key while you move the cell cursor.
3. Press Shift+F8 to switch from Extend Selection mode to Add to
Selection mode.
The Add to Selection indicator appears in the Status bar.
4. Move the cell cursor to the first cell of the next nonadjacent range that
you want to select.
5. Press F8 again to get back into Extend Selection mode and then move
the cell cursor to select all the cells in this new range.
6. If you still have other nonadjacent ranges to select, repeat Steps 3, 4,
and 5 until you select and add all the cell ranges that you want to use.
Cell selections à la Go To
If you want to select a large cell range that would take a long time to select by
pressing various cell-pointer movement keys, use the Go To feature to extend
the range to a far distant cell. All you gotta do is follow this pair of steps:
1. Position the cell cursor in the first cell of the range and then press F8
to anchor the cell cursor and get Excel into Extend Selection mode.
2. Press F5 or Ctrl+G to open the Go To dialog box, type the address of
the last cell in the range (the cell kitty-corner from the first cell), and
then click OK or press Enter.
Because Excel is in Extend Selection mode at the time you use the Go To
feature to jump to another cell, the program not only moves the cell cursor to
the designated cell address but selects all the intervening cells as well. After
selecting the range of cells with the Go To feature, don’t forget to press F8
(the Extend Selection key) again to prevent the program from messing up your
selection by adding more cells the next time you move the cell cursor.
Using the Format as Table Gallery
Here’s a formatting technique that doesn’t require you to do any prior cell
selecting. (Kinda figures, doesn’t it?) The Format as Table feature is so
automatic that the cell cursor just has to be within the table of data prior to you
clicking the Format as Table command button in the Styles group on the
Home tab. Clicking the Format as Table command button opens its rather
extensive Table Styles gallery with the formatting thumbnails divided into
three sections — Light, Medium, and Dark — each of which describes the
intensity of the colors used by its various formats.
Search JabSto ::




Custom Search