View Single Post
 
Old 01-21-2011, 12:24 AM
macropod's Avatar
macropod macropod is offline Windows 7 32bit Office 2000
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 22,467
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

Quote:
Originally Posted by tatihulot View Post
Is dragging down the column, as per your instructions, the only way to do this?
If you press Ctrl-End, that will take you to the last active cell in the worksheet. Pressing the Home key will then take you to column A. Of course, you can navigate to the left by scrolling. You can also scroll up from the bottom if you don't want to include the very last row.

To select from there to the top of the column, hold down the Shift key and press Ctrl-Home and scroll to the desired column. Keeping the Shift key depressed, you can also scroll down from the top of the column to another row if you prefer - and you can span more than one column if desired.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote