![]() |
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 ? |
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 ? |
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