software

I am looking for a formula to end a column say at A20 and then begin again at
B1. Is there a formula for this. So when typing you don't have to click B1
everytime??
Thanks for your help.

Hi,

You may try this solution.

Suppose you want to start inputing numbers from cell A1. Now select cell A2
down till A20 and the press the Ctrl key and select from B1 till where you
want. Next press the Ctrl key and select cell A1.

Now go to the Name box (it appears on the top left corner of the Excel
workbook) which will currently be showing you the cell reference. Type a
name here, say quot;Rangequot; (without quotes)

Now whenever you want to go to the range, just type quot;Rangequot; in the Name box
and that range will get highlighted. type the number and pres tab (not
enter) to input a number in the other cell of the range. You will notice
that once you reach cell A20 and press tab, you will automatically be
transferred to cell B1.

Hope thsi helps. If you have any furhter queries or any further
clarifications, please feel free tro contact me at

Regards

quot;Amberquot; wrote:

gt; I am looking for a formula to end a column say at A20 and then begin again at
gt; B1. Is there a formula for this. So when typing you don't have to click B1
gt; everytime??
gt; Thanks for your help.

Hi Amber,

You can use either TAB or ENTER with Ashish's method. Enter is more
convient for typing, I would think.

HTH
Regards,
Howard

quot;Amberquot; gt; wrote in message
...
gt;I am looking for a formula to end a column say at A20 and then begin again
gt;at
gt; B1. Is there a formula for this. So when typing you don't have to click B1
gt; everytime??
gt; Thanks for your help.