|
[ Pobierz całość w formacie PDF ]
.The active area is arectangle that encompasses all regions that is, all the filled cells in the active worksheet.The techniques used to navigate regions are especially helpful if you typically work with largetables of data.Getting to the bottom row of a 500-row table is easier when you don t have touse the scroll bars.Read on to find out how.101Part 2: Building Worksheets Microsoft Office Excel 2003 Inside Outf05ie01Figure 5-1.The four blocks of cells on this worksheet are separate regions.Note The small square in the lower-right corner of the active cell is called the Fill handle.If the Fill handle isn t visible on your screen, it means that the Allow Cell Drag And Dropoption, which is necessary for region navigation to work, isn t available.Choose Tools,Options, click the Edit tab, and select Allow Cell Drag And Drop.Note You can find the sample file used in this example, Regional Sales.xls, on the book scompanion CD.Navigating Regions with the KeyboardTo move between the edges of regions, hold down the Ctrl key while pressing any of the arrowkeys.For example, in Figure 5-1, cell A3 is the active cell; press Ctrl+Right Arrow to activatecell E3.If a blank cell is active when you press Ctrl and an arrow key, Excel moves to the first filled cellin that direction or to the last available cell in the worksheet if there are no filled cells in thatdirection.In Figure 5-1, for example, suppose cell F3 is active; if you press Ctrl+Right Arrow,the selection moves to cell G3.Navigating Regions with the MouseWhen you move the mouse pointer over the edge of the active cell s border, the pointerchanges from a plus sign to an arrow.With the arrow pointer visible, you can double-clickany edge of the border to change the active cell to the cell on the edge of the current region inthat direction it is the same as pressing Ctrl and an arrow key in that direction.For exam-ple, if you double-click the bottom edge of the active cell in Figure 5-1, Excel selects cell A7.The right side of the status bar displays the indicators in Table 5-1 when the correspondingmode is active.102Part 2: Building WorksheetsChapter 5 Part 1: Part TitleHow to Work a WorksheetTable 5-1.Keyboard Mode CodesCode DescriptionEXT Extend mode.Press F8 to turn on the Extend mode, which you can use to extendthe current selection using the keyboard.(Make sure Scroll Lock is turned off.) Thisis a keyboard equivalent of selecting cells by dragging the mouse.Furthermore,unlike holding down the Shift key and pressing an arrow key, you can extend therange by pressing only one key at a time.Press F8 again to turn off Extend mode.ADDAdd mode.Press Shift+F8 to add more cells to the current selection using thekeyboard.The cells need not be adjacent; after pressing Shift+F8, click any cellor drag through any range to add it to the selection.This is the keyboard equiva-lent of holding down Ctrl and selecting additional cells with the mouse.NUMNum Lock mode.This mode is on by default and locks the keypad in numeric-entry mode.To turn off Num Lock mode, press the Num Lock key.FIXFixed Decimal mode.Choose Tools, Options, click the Edit tab, and selectFixed Decimal to add a decimal point to the numeric entries in the currentselection.Excel places the decimal point in the location you specify in thePlaces box.For example, when you turn on Fixed Decimal mode, specify twodecimal places, and enter the number 12345 in a cell, the value 123.45appears in the cell after you press Enter.Existing cell entries are not affectedunless you edit them.To turn off Fixed Decimal mode, return to the Edit tab ofthe Options dialog box and clear the Fixed Decimal option.CAPSCaps Lock mode.Press the Caps Lock key to enter typed text in capital let-ters.Number and symbol keys are not affected.To turn off Caps Lock mode,press the Caps Lock key again.SCRLScroll Lock mode.Press Scroll Lock to use the Page Up, Page Down, and arrowkeys to move the viewed portion of the window without moving the active cell.When Scroll Lock mode is off, the active cell moves one page at a time when youpress Page Up or Page Down, or one cell at a time when you press one of thearrow keys.To turn off Scroll Lock mode, press the Scroll Lock key again.ENDEnd mode.Press the End key and then press an arrow key to move the selectionto the edge of the region in that direction, or to the last worksheet cell in that direc-tion.This mode functions like holding down Ctrl and pressing an arrow key, exceptthat you need to press only one key at a time.To turn off End mode, press the Endkey again.End mode is also turned off after you press one of the arrow keys.WhileEnd mode is active, the word END appears toward the right side of the status bar.OVROverwrite mode.Click the formula bar or double-click a cell and press theInsert key to turn on Overwrite mode.Normally, new characters you type in theformula bar are inserted between existing characters.With Overwrite modeturned on, the characters you type replace any existing characters to the rightof the insertion point.Overwrite mode turns off when you press Insert again orwhen you press Enter or one of the arrow keys.103Part 2: Building WorksheetsChapter 5 Microsoft Office Excel 2003 Inside OutNavigating with Special KeysThe following table shows how you can use the Home and End keys alone and in conjunctionwith other keys to make selections and to move around a worksheet.Press ToHome Move to the first cell in the current row.Ctrl+Home Move to cell A1.Ctrl+End Move to the last cell in the last column in the active area.Forexample, in Figure 5-1, pressing Ctrl+End selects cell H10.End Start End mode.Then use an arrow key to move within cellregions.Scroll Lock+Home Move to the first cell within the current window.Scroll Lock+End Move to the last cell within the current window.Selecting StuffBefore you can work with a cell or range, you must select it, and when you do, it becomesactive.The reference of the active cell appears in the Name box at the left end of the formulabar.Only one cell can be active at a time, but you can select ranges of cells.You can change theactive cell in a selected range without changing your range selection.Selecting with the MouseTo select a range of cells, drag the mouse over the range.Alternatively, instead of draggingthrough all the cells you want to select, you can use a technique known as extending to indi-cate two diagonal corners of the range.Simply click the cell at one corner of the range youwant to select, then hold Shift and click the cell at the corner of the range diagonal to theselected cell.For example, to extend the selection A1:B5 so that it becomes A1:C10, holddown the Shift key and click cell C10.When you need to select a large range, this techniqueis more efficient than dragging the mouse across the entire selection.Selecting Beyond the Window BordersIt s impossible to see an entire workbook on the screen [ Pobierz całość w formacie PDF ] |
Archiwum
|