• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint

Worksheet Editing

The better you are at editing worksheets, the more Excel will enhance your productivity. You already know that entering numeric data is error-prone at its best; the faster you edit cell values accurately, the faster you complete accurate worksheets. The following sections show you the primary editing techniques in Excel and explain how you can leverage those techniques to produce more accurate worksheets.

Selecting Cells

You can select a cell, a row of cells, or a column of cells just by clicking and dragging your mouse. As you drag your mouse, Excel selects a rectangular region, called a range. You notice as you drag your mouse that Excel displays the number of rows and columns you have selected. You see the message 10R X 4C appear in the toolbar's name box as you select 10 rows and 4 columns, for example. When you release your mouse, Excel displays the selection's upper-left corner cell name inside the name box, as Figure 7.1 shows.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint