Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.newusers
Bill
 
Posts: n/a
Default 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   Report Post  
Posted to microsoft.public.excel.newusers
Norman Jones
 
Posts: n/a
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Linking Groups of cells between workbooks vnacj-joe Excel Discussion (Misc queries) 4 June 14th 07 05:18 PM
Copy cells in a determined order pmarques Excel Discussion (Misc queries) 3 February 6th 06 04:15 PM
how do i protect cells in a shared worksheet Debi Excel Discussion (Misc queries) 3 September 30th 05 11:15 PM
Display first, second, etc Nonblank Cells in a Range Jeremy N. Excel Worksheet Functions 12 September 25th 05 01:47 PM
Use functions when cells are merged Amanda Excel Worksheet Functions 3 September 12th 05 06:08 PM


All times are GMT +1. The time now is 02:36 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"