Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
progress2work
 
Posts: n/a
Default arrow across, up and down etc in an excel row? How ?

I am using Excel, and I need to arrow up and down etc into other rows by
using the arrow keys on the keyboard. Can you tell me how to do this ?
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Paul B
 
Posts: n/a
Default arrow across, up and down etc in an excel row? How ?

progress2work, from help, Keyboard shortcuts

Arrow keys
Move one cell up, down, left, or right.
CTRL+arrow key
Move to the edge of the current data region.


Move within a selected range

ENTER
Move from top to bottom within the selected range.
SHIFT+ENTER
Move from bottom to top within the selected range.
TAB
Move from left to right within the selected range. If cells in a single
column are selected, move down.
SHIFT+TAB
Move from right to left within the selected range. If cells in a single
column are selected, move up.
CTRL+PERIOD
Move clockwise to the next corner of the selected range.
CTRL+ALT+RIGHT ARROW
In nonadjacent selections, switch to the next selection to the right.
CTRL+ALT+LEFT ARROW
Switch to the next nonadjacent selection to the left.
Note You can change the direction of movement after pressing ENTER or
SHIFT+ENTER: press ALT+T and then O (Tools menu, Options command), press
CTRL+TAB until the Edit tab is selected, and then change the Move selection
after Enter settings.



--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003

"progress2work" wrote in message
...
I am using Excel, and I need to arrow up and down etc into other rows by
using the arrow keys on the keyboard. Can you tell me how to do this ?



  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
BJ Gates
 
Posts: n/a
Default Non adjacent cell selections

I am fairly new to Excel after years of using Lotus 1-2-3. I know how to do
non adjacent cell selections there, and from what I read, it should work the
same in Excel, but when I get my selections made and save print area, and
preview, the entire worksheet comes us.

I must be missing a step. I can do the selections with the mouse or with
the keyboard.


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



All times are GMT +1. The time now is 12:33 PM.

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

About Us

"It's about Microsoft Excel"