Microsoft Office Tutorials and References
In Depth Information
Excel’s Ribbon User Interface
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 8 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 8 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. The big bonus is that you can enter both
numbers and text into the cells of your worksheet without having to switch
back and forth between the QWERTY letter and numeric key arrangements. 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 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
To understand how scrolling works in Excel, imagine its humongous
worksheet as a papyrus scroll attached to rollers on the left and right. To bring
into view a section of papyrus hidden on the right, you crank the left roller
until the section with the cells that you want to see appears. Likewise, to
scroll into view a worksheet section hidden on the left, you crank the right
roller until the section of cells appears.
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.
 
Search JabSto ::




Custom Search