Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Automatic enter that returns you to column A in Excel
How do I reset the default so that when I tap the enter key, it returns to
column A? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Automatic enter that returns you to column A in Excel
Hi
I don't think there is any built-in function to do this. A workaround is to highlight the area you are working in and using the Tab key. This will cycle through the selected cells. It may help - but it may not! An alternative is to use a macro to do it for you. Andy. "btaft" wrote in message ... How do I reset the default so that when I tap the enter key, it returns to column A? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Automatic enter that returns you to column A in Excel
Not possible to just "reset" the default but there is one way of returning to
column A. Say you start with A1 selected. Type something in A1 and hit the Tab key to go to B1. Type and Tab your way across to H1. When leaving H1 hit the <ENTER key and you will go back to A2 Rule is.........you will go back to the original column in which you started. Gord Dibben MS Excel MVP On Thu, 9 Mar 2006 06:08:35 -0800, btaft wrote: How do I reset the default so that when I tap the enter key, it returns to column A? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How can I enter carriage returns into text within a cell in excel | Excel Discussion (Misc queries) | |||
Check COlumn - Excel VBA | Excel Discussion (Misc queries) | |||
Categorizing an excel column | Excel Discussion (Misc queries) | |||
Return Count for LAST NonBlank Cell in each Row | Excel Worksheet Functions | |||
How to enter a two line column heading in excel | New Users to Excel |