![]() |
Cells get out of order
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 |
Cells get out of order
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. --- Regards, Norman "Bill" wrote in message ... 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 |
All times are GMT +1. The time now is 12:54 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com