Excel 2016 For Dummies. Harvey Greg
Чтение книги онлайн.

Читать онлайн книгу Excel 2016 For Dummies - Harvey Greg страница 8

Название: Excel 2016 For Dummies

Автор: Harvey Greg

Издательство: John Wiley & Sons Limited

Жанр: Зарубежная образовательная литература

Серия:

isbn: 9781119297338

isbn:

СКАЧАТЬ a section of a worksheet with many blocks of cells.

      When you use Ctrl and an arrow key to move from edge to edge in a table or between tables in a worksheet, you hold down Ctrl while you press one of the four arrow keys (indicated by the + symbol in keystrokes, such as Ctrl+→).

      When you use End and an arrow-key alternative, you must press and then release the End key before you press the arrow key (indicated by the comma in keystrokes, such as End, →). Pressing and releasing the End key causes the End Mode indicator to appear on the Status bar. This is your sign that Excel is ready for you to press one of the four arrow keys.

      Because you can keep the Ctrl key depressed while you press the different arrow keys that you need to use, the Ctrl-plus-arrow-key method provides a more fluid method for navigating blocks of cells than the End-then-arrow-key method.

      

You can use the Scroll Lock key to “freeze” the position of the cell pointer in the worksheet so that you can scroll new areas of the worksheet in view with keystrokes, such as PgUp (Page Up) and PgDn (Page Down), without changing the cell pointer’s original position (in essence, making these keystrokes work in the same manner as the scroll bars).

      After engaging Scroll Lock, when you scroll the worksheet with the keyboard, Excel does not select a new cell while it brings a new section of the worksheet into view. To “unfreeze” the cell pointer when scrolling the worksheet via the keyboard, you just press the Scroll Lock key again.

TIPS ON USING THE TOUCH KEYBOARD

      If you’re running Excel 2016 on a device that lacks any kind of physical keyboard, you need to open the Touch keyboard and use it to input your spreadsheet data.

To open the Touch keyboard, simply tap the Touch Keyboard button that appears on the right side of the Windows taskbar. Doing this displays the Touch keyboard, floating undocked at the bottom of the Excel program window, as shown in Figure 1-7.

       FIGURE 1-7: Windows 10 touchscreen shown after displaying the Touch keyboard beneath the Excel 2016 program window.

      To dock the Touch keyboard beneath the Excel 2016 program window, simply click the Dock button that appears to the immediate left of the Close button in the upper-right corner of the keyboard. To once again undock the Touch keyboard so that it floats and you can move around with your finger, tap the Float button (with a caret pointing upward on top of the keyboard icon) that replaces the Dock button (with a caret pointing downward).

      As shown in this figure, when docked, the Windows 10 Touch keyboard remains completely separate from the Excel program window so that you still have access to all the cells in the current worksheet when doing your data entry. The Windows Touch keyboard is limited mostly to letter keys above a spacebar with a few punctuation symbols (apostrophe, comma, period, and question mark). This keyboard also sports the following special keys:

      ❯❯ Backspace key (marked with the x in the shape pointing left) to delete characters to the immediate left when entering or editing a cell entry

      ❯❯ Enter key to complete an entry in the current cell and move the cursor down one row in the same column

      ❯❯ Shift keys (with an arrow pointing upward) to enter capital letters in a cell entry

      ❯❯ Numeric key (with the &123) to switch to the Touch keyboard so that it displays a numeric keyboard with a Tab key and extensive punctuation used in entering numeric data in a cell (tap the &123 key a second time to return to the standard QWERTY letter arrangement)

      ❯❯ Ctrl key to run macros to which you’ve assigned letter keys (see Chapter 12 for details) or to combine with the Left arrow or Right arrow key to jump the cursor to the cell in the last and first column of the current row, respectively

      ❯❯ Emoticon key (with that awful smiley face icon) to switch to a bunch of emoticons that you can enter into a cell entry (tap the Emoticon key a second time to return to standard QWERTY letter arrangement)

      ❯❯ Left arrow (with the < symbol) to move the cell cursor one cell to the immediate right and complete any cell entry in progress

      ❯❯ Right arrow (with the > symbol) to move the cell cursor one cell to the immediate left and complete any cell entry in progress

      When you finish entering your worksheet data with the Windows 10 Touch keyboard, you can close it and return to the normal full screen view of the Excel program window by tapping the Close button.

      

The Windows Touch keyboard supports a split-keyboard arrangement that separates the QWERTY letter keys into two banks on the left and right with a ten-key numeric keypad in the middle. The drawback is that the individual keys are smaller than the normal, non-split arrangement and can be harder to select with your finger or stylus. To switch to the split-keyboard arrangement, tap the Keyboard button in the very lower-right corner of the Touch keyboard (to the immediate right of the Right arrow key) and then tap the second button from the left (that shows a gap in the keyboard icon) in the pop-up menu that appears.

TIPS ON USING THE SCROLL BARS

      You can use the horizontal scroll bar at the bottom of the Worksheet area to scroll back and forth through the columns of a worksheet and the vertical scroll bar to scroll up and down through its rows. To scroll a column or a row at a time in a particular direction, select the appropriate scroll arrow at the ends of the scroll bar. To jump immediately back to the originally displayed area of the worksheet after scrolling through single columns or rows in this fashion, simply click (tap on a touchscreen) the area in the scroll bar that now appears in front of or after the scroll bar.

      You can resize the horizontal scroll bar making it wider or narrower by dragging the button that appears to the immediate left of its left scroll arrow. Just keep in mind when working in a workbook that contains a whole bunch of worksheets that widening the horizontal scroll bar can hide the display of the workbook’s later sheet tabs.

      

To scroll very quickly through columns or rows of the worksheet when you have a physical keyboard available, hold down the Shift key and then drag the scroll button in the appropriate direction within the scroll bar until the columns or rows that you want to see appear on the screen in the Worksheet area. When you hold down the Shift key while you scroll, the scroll button within the scroll bar becomes skinny and a ScreenTip appears next to the scroll bar, keeping you informed of the letter(s) of the columns or the numbers of the rows that you’re whizzing through.

      If you have a mouse and it’s equipped with a wheel, you can use it to scroll directly through the columns and rows of the worksheet without using the horizontal or vertical scroll bars. Simply position the white cross mouse pointer in the center of the Worksheet area and then hold down the wheel button of the mouse. When the mouse pointer changes to a four-pointed arrow with a black dot in its center, drag the mouse pointer in the appropriate direction (left and right to scroll through columns or up and down to scroll through rows) until the desired column or row comes into view in the Worksheet area.

      

On a touchscreen device, you can also scroll new parts of a worksheet into view simply by swiping with your finger or stylus to scroll (by dragging it on the screen). СКАЧАТЬ