Microsoft Office Tutorials and References
In Depth Information
Excel’s Ribbon User Interface
The keystrokes that combine the Ctrl or End key with an arrow key listed in
Table 1-1 are among the most helpful for moving quickly from one edge to the
other in large tables of cell entries or for moving from table to table in 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
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 2013 on a device that lacks any kind of physical
keyboard, you need to open the Touch keyboard and use it to input your
To open the Touch keyboard, simply tap the Touch Keyboard button that
appears on the right side of the Windows 7 or 8 taskbar. Doing this displays
the Touch keyboard, floating undocked at the bottom of the Excel program
To dock the Touch keyboard beneath the Excel 2013 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. Figure 1-7 shows you how
your touchscreen looks after docking the Windows 8 Touch keyboard.