Cells get out of order

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a fairly large excel document (over 1500 rows) that I use to put
policies for my job in, so there is a lot of text in it. The problem I have
is the cells within a row tend to move up and down. For example: Row 3 may
have information in A3, B3, C3. But somehow the information in Cell B3 will
shift down to Cell B4? But A3 and C3 will not change though. I understand
that inserting a row will shift all cells down but why only certain cells in
the row? Any input would be greatly appreciated. Thanks
 
Hi Bill,

To avoid this behaviour, ensure that entire rows are inserted:

Click the row number (at the left-hand edge of the sheet)
Right-click the mouse
Select 'Insert' from the displayed mouse menu.
 
Back
Top