Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I move from cell A 10 to cell B1 with one move or click
I need to be able to, in one quick move, go from the last entry in a
spreadsheet column to the top of the next column and be able to do this repeatedly. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I move from cell A 10 to cell B1 with one move or click
one way..................
enter a macro activated by a shortcut this macro will cause the cell selection to go to the top of the next column Sub shiftup() ' ' Keyboard Shortcut: Ctrl+i ' If ActiveCell.Row = 1 Then Exit Sub ActiveCell(0, 2).Select Selection.End(xlUp).Select End Sub Greetings from New Zealand "chipsdad" wrote in message ... I need to be able to, in one quick move, go from the last entry in a spreadsheet column to the top of the next column and be able to do this repeatedly. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I move from cell A 10 to cell B1 with one move or click
Of course you can also insert a hyperlink in the cell but i prefer not to
have to grab the mouse. "Bill Kuunders" wrote in message ... one way.................. enter a macro activated by a shortcut this macro will cause the cell selection to go to the top of the next column Sub shiftup() ' ' Keyboard Shortcut: Ctrl+i ' If ActiveCell.Row = 1 Then Exit Sub ActiveCell(0, 2).Select Selection.End(xlUp).Select End Sub Greetings from New Zealand "chipsdad" wrote in message ... I need to be able to, in one quick move, go from the last entry in a spreadsheet column to the top of the next column and be able to do this repeatedly. |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I move from cell A 10 to cell B1 with one move or click
Hi,
Suppose the range you want to work with is A1:D10 and everytime you get to the bottom of a column you want to move to the top of the next column automatically. Hightlight the whole range A1:D10 as you press Enter your cursor will move down the column, when you arrive in A10 and press Enter you will be in B1. This works while the range remains highlighted. In addition you can use the Tab, Shift+Tab and Shift+Enter keys in this highlighted mode. You can't use the four cursor keys or the PgDn or PgUp keys though. Finally, while in this mode you can press Ctrl . (Control Period) to move around the outer corners of the selected range. -- If this helps, please click the Yes button. Cheers, Shane Devenshire "chipsdad" wrote: I need to be able to, in one quick move, go from the last entry in a spreadsheet column to the top of the next column and be able to do this repeatedly. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to increment a cell by 1 on mouse click or move to another cel | Excel Discussion (Misc queries) | |||
move to another cell on click | Excel Discussion (Misc queries) | |||
double click mouse, move to referenced wkbk/cell | Setting up and Configuration of Excel | |||
I click on a cell and move the cursor the entire area highlights | Excel Discussion (Misc queries) | |||
I click on a cell and move the cursor the entire area highlights . | Excel Discussion (Misc queries) |