How can I make the cursor move down 8 cells each time I press ente

G

Guest

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!
 
G

Guest

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top