I am entering a whole load of data into Excel and need to jump down 8 cells
each time I press enter.
So I start in c2 and need to jump to c10, c18, c26 etc... up to c82
Then I start in c3 and on to c11,c19,c27 etc... then c4,c5 etc
Then I move on to d2 and enter the 89 lines of data jumping down 8 cells
each time.
An then onto e2, f2, g2 etc
Any easy way to just make the cursor move down 8 cells each time i press
enter?
Thanks!
Pete_UK - 11 Aug 2007 01:11 GMT
You have answers at your other thread - please do not multi-post.
Pete
On Aug 10, 8:52 pm, Cadnys Kisses <Candys
Kis...@discussions.microsoft.com> wrote:
> I am entering a whole load of data into Excel and need to jump down 8 cells
> each time I press enter.
[quoted text clipped - 12 lines]
>
> Thanks!
GinaZ - 17 Aug 2007 20:08 GMT
Hi. Have you tried to write a macro for 8 'enters'?
allocate a keystroke to it, which you can hit each time to jump down 8.
:)g
----------------
> I am entering a whole load of data into Excel and need to jump down 8 cells
> each time I press enter.
[quoted text clipped - 12 lines]
>
> Thanks!