ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   arrow across, up and down etc in an excel row? How ? (https://www.excelbanter.com/excel-worksheet-functions/67812-arrow-across-up-down-etc-excel-row-how.html)

progress2work

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 ?

Paul B

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 ?




BJ Gates

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.




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

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com