Microsoft Office Tutorials and References
In Depth Information
Jumping to the Bottom of Data with Ctrl+Arrow
Dec. If you are currently on the Jan worksheet, hold down Ctrl and press
Page Down five times to move to Jun.
Jumping to the Bottom of Data with Ctrl+Arrow
Provided there are no blank cells in your data, press Ctrl+Down Arrow to
move to the last row in the data set. Use Ctrl+Up Arrow to move to the first
row in the data set.
Add the Shift key to select from the current cell to the bottom. If you have
data in A2:J987654 and are in A2, you can hold down Ctrl+Shift while press-
ing the down arrow and then the right arrow to select all the data rows but
exclude the headings in row 1.
Selecting the Current Region with Ctrl+*
Press Ctrl+* to select the current range. The current range is the whole
dataset, in all directions from the current cell until Excel hits the edge of
the worksheet or a completely blank row and column. On a desktop computer,
pressing Ctrl and the asterisk on the numeric keypad does the trick.
Jumping to the Next Corner of a Selection
You ve just selected A2:J987654 but you are staring at the bottom-right
corner of your data. Press Ctrl+Period to move to the next corner of your
data. Because you are at the bottom-right corner, it takes two presses of
Ctrl+Period to move to the top-left corner. Although this moves the active
cell, it does not undo your selection. Although I always use Ctrl+Period
twice, I should probably learn Ctrl+Backspace to bring the active cell back
into view. That will be my new trick for next week.
Pop Open the Right-Click Menu Using Shift+F10
Pop Open the Right-Click Menu Using Shift+F10
When I do my seminars, people always ask why I don t use the right-click
menus. I don t use them because my hand is not on the mouse! Pressing
Shift+F10 opens the right-click menu. Use the up/down arrow keys to move to
various menu choices and the right arrow key to open a fly-out menu. When
you get to the item you want, press Enter to select it.
Crossing Tasks Off Your List with Ctrl+5
Crossing Tasks Off Your List with Ctrl+5
I love to make lists, and I love to cross stuff off my list. It makes me
feel like I ve gotten stuff done. Select a cell and press Ctrl+5 to apply
strikethrough to the cell.
Search JabSto ::




Custom Search