COLUMNS IN EXCEL

T

TLZ

I currently have a spreadsheet that has 3 columns in it.

Instead of cutting and pasting everytime I need to add
another number to one of the cells, I would like the
worksheet to automatically move the cells to the next
column on the right after the bottom of the column has
been reached.

Column1 Column2 Column3 Column4
Column1 Column2 Column3 Column4
Column1 Column2 Column3
Column1 Column2 Column3

<End Page>

After Column4 is full, and I an inserting a cell into
column1, I would like Everything after my insertion point
to move 1 space and begin column5 automatically.

I would like to keep creating columns that go across the
page instead of adding to columns going down the page.
But I need this to be automatic. Cutting and pasting all
of this is getting old quick.

Thank You for your help...
 

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