Cells get out of order

[Bill]

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

 

[Norman Jones]

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.