Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Linking Groups of cells between workbooks | Excel Discussion (Misc queries) | |||
Copy cells in a determined order | Excel Discussion (Misc queries) | |||
how do i protect cells in a shared worksheet | Excel Discussion (Misc queries) | |||
Display first, second, etc Nonblank Cells in a Range | Excel Worksheet Functions | |||
Use functions when cells are merged | Excel Worksheet Functions |