Columns in Excel

[TLZ]

I have the following problem I need help with:

Column 1 Column2 Column3 Column4

017290 117110 246781
017450 117118 246790
017451 117119 317891
116127 246761 317990
116128 246771 341772
116129 246780 358381


Say I want to insert a new number into "Column 2." The
number 119000. How can I do this and make all the
information move automatically to look like the following:

Column 1 Column2 Column3 Column4

017290 117110 246780 358381
017450 117118 246781
017451 117119 246790
116127 119000 317891
116128 246761 317990
116129 246771 341772


I would like to keep the same number of rows in each
column. As each column fills, I would like the
information to move to the next column to the right. As
of now, I cannot find a way for the spreadsheet to
automatically move the information in this way for me.

Thank you for any help you can give.

 

[David McRitchie]

Hi anonymous poster TLZ,
Select the cell, Insert (menu), cells, shift to the right


HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm