How do I reset the default so that when I tap the enter key, it returns to
column A?
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.
quot;btaftquot; gt; wrote in message
...
gt; How do I reset the default so that when I tap the enter key, it returns to
gt; column A?
Not possible to just quot;resetquot; 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 lt;ENTERgt; 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 MVPOn Thu, 9 Mar 2006 06:08:35 -0800, btaft gt;
wrote:
gt;How do I reset the default so that when I tap the enter key, it returns to
gt;column A?
- May 27 Tue 2008 20:44
Automatic enter that returns you to column A in Excel
close
全站熱搜
留言列表
發表留言