PC Review


Reply
Thread Tools Rate Thread

Cells get out of order

 
 
=?Utf-8?B?QmlsbA==?=
Guest
Posts: n/a
 
      23rd May 2006
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 With Quote
 
 
 
 
Norman Jones
Guest
Posts: n/a
 
      23rd May 2006
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" <(E-Mail Removed)> wrote in message
news:471B48AC-BF44-497F-AD37-(E-Mail Removed)...
>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 With Quote
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

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


Similar Threads
Thread Thread Starter Forum Replies Last Post
copy cells down a column (in order) to across a row (same order?? Tampa9 Microsoft Excel Misc 1 4th Dec 2008 04:23 PM
Order Cells Accessed Bill Bradshaw Microsoft Excel Misc 3 24th Sep 2008 10:29 PM
Ranking order of cells. =?Utf-8?B?SnJKb3NlcGg=?= Microsoft Excel Misc 9 19th Aug 2007 11:50 PM
Tab order for cells =?Utf-8?B?Sm9obiBX?= Microsoft Excel Discussion 1 23rd Feb 2006 04:55 PM
Shapes, Cells and Z-Order Jonathan Furman Microsoft Excel Discussion 3 15th Sep 2004 07:52 PM


Features
 

Advertising
 

Newsgroups
 


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