Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old March 21st 05, 06:55 PM
piddilin
 
Posts: n/a
Default Keyboard Shortcut to move to top of column in worksheet?

What is the keyboard shortcut to move to the top of a column? Also what is
the keybord shortcut to get to the bottom of a column (of my worksheet) not
row 65,536)?

  #2   Report Post  
Old March 21st 05, 07:21 PM
cvgairport
 
Posts: n/a
Default

There are commands to do what you described. The ones that I know about arre
the old Lotus navigational commands such as {End}{Up} and {End}{Down} to move
up and down a column of data. To access these handy commands you must go to
the Tools/Options command. On the transition tab, in the middle, click on
the Transition Navigation keys. That should restore all the Lotus
navigational commands including {Home} to get to cell A1 and tab to move
across the screen one window at a time.

Hope this helps,

Amy

"piddilin" wrote:

What is the keyboard shortcut to move to the top of a column? Also what is
the keybord shortcut to get to the bottom of a column (of my worksheet) not
row 65,536)?

  #3   Report Post  
Old March 21st 05, 07:24 PM
Max
 
Posts: n/a
Default

Try:

CTRL + Up arrow
CTRL + Down arrow

--
Rgds
Max
xl 97
---
GMT+8, 1 22' N 103 45' E
xdemechanik <atyahoo<dotcom
----
"piddilin" wrote in message
...
What is the keyboard shortcut to move to the top of a column? Also what is
the keybord shortcut to get to the bottom of a column (of my worksheet)

not
row 65,536)?



  #4   Report Post  
Old March 21st 05, 09:19 PM
piddilin
 
Posts: n/a
Default

Some cells in the column are blank so CTRL+Up arrow, etc. only goes to the
next nonblank cell.


"Max" wrote:

Try:

CTRL + Up arrow
CTRL + Down arrow

--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <atyahoo<dotcom
----
"piddilin" wrote in message
...
What is the keyboard shortcut to move to the top of a column? Also what is
the keybord shortcut to get to the bottom of a column (of my worksheet)

not
row 65,536)?




  #5   Report Post  
Old March 21st 05, 11:49 PM
Max
 
Posts: n/a
Default

Agreed, but you could just keep holding down CTRL,
and continue to tap the Up / Down arrow ?

Alternatively,
press CTRL+End, then use Left arrow
press CTRL+Home, then use Right arrow

Not sure if there's a direct keystroke combo to do as you want

Try browsing Chip's:
http://www.cpearson.com/excel/KeyboardShortcuts.htm

and Debra's:
http://www.contextures.com/excel.htm
--
Rgds
Max
xl 97
---
GMT+8, 1 22' N 103 45' E
xdemechanik <atyahoo<dotcom
----
"piddilin" wrote in message
...
Some cells in the column are blank so CTRL+Up arrow, etc. only goes to the
next nonblank cell.





  #6   Report Post  
Old October 29th 12, 11:36 AM
Junior Member
 
First recorded activity by ExcelBanter: Oct 2012
Posts: 2
Smile

Try Ctrl+home.


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Shortcut key to move to beginning of a worksheet Martha Excel Discussion (Misc queries) 1 February 22nd 05 08:53 PM
keyboard shortcut Aditya Excel Worksheet Functions 1 February 21st 05 02:34 PM
How to move one piece of text to another column Needs Help Excel Discussion (Misc queries) 5 December 29th 04 03:41 PM
In Excel keyboard arrow keys no longer work OL Marv Setting up and Configuration of Excel 1 December 28th 04 11:50 PM
Keyboard shortcut to follow hyperlinks? Jack Kohn Links and Linking in Excel 2 December 18th 04 02:05 AM


All times are GMT +1. The time now is 02:04 PM.

Powered by vBulletin® Copyright ©2000 - 2017, Jelsoft Enterprises Ltd.
Copyright 2004-2017 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017