[mso] Re: Excel "insert"

In my experience, if the value in Column A of Row 151 is found as the 
sum(A1:A150) then the process of selecting rows 2 through 150 in Column A, 
choosing to Cut the selection, and Paste into Row 1 will result in the 
expression in Row 151 changing to sum(A1:A149).  The entry in Row 150 of Column 
A will no longer be included in the SUM.  To not have the relationship in Row 
151 change it is necessary to use the process of selecting rows 2 through 150, 
COPY the selection, Paste the selection starting in Row 1, select the entries 
in Row 150 and delete the selection or modify it with new data.
Jonathan

--- On Mon, 11/24/08, LarrysPCRemedies@xxxxxxx <LarrysPCRemedies@xxxxxxx> wrote:
From: LarrysPCRemedies@xxxxxxx <LarrysPCRemedies@xxxxxxx>
Subject: [mso] Re: Excel "insert"
To: mso@xxxxxxxxxxxxx
Date: Monday, November 24, 2008, 4:23 PM

I'm not exact sure I understand what you want to do, but if you have your  
total/average line on row 151, and you delete row 1 and insert new values in
row 
 150, why don't you just cut the rows 2-150 and paste into rows 1-149. That

will  open up row 150 for the new data without needing to insert any rows at  
all.
 
Larry
 
**************One site has it all. Your email accounts, your social networks, 
and the things you love. Try the new AOL.com 
today!(http://pr.atwola.com/promoclk/100000075x1212962939x1200825291/aol?redir=http://www.aol.com/?optin=new-dp
%26icid=aolcom40vanity%26ncid=emlcntaolcom00000001)

*************************************************************
You are receiving this mail because you subscribed to mso@xxxxxxxxxxxxx or
MicrosoftOffice@xxxxxxxxxxxxxxxx

To send mail to the group, simply address it to mso@xxxxxxxxxxxxx

To Unsubscribe from this group, visit the group's homepage and use the
dropdown menu at the top.  This will allow you to unsubscribe your email address
or change your email settings to digest or vacation (no mail).
http://www.freelists.org/webpage/mso

To be able to share files with the group, you must join our Yahoo sister group.
 This group will not allow for posting of emails, but will allow you to join and
share problem files, templates, etc.: 
http://tech.groups.yahoo.com/group/MicrosoftOffice . This group is for FILE
SHARING ONLY.

If you are using Outlook and you see a lot of unnecessary code in your email
messages, read these instructions that explain why and how to fix it:
http://personal-computer-tutor.com/abc3/v28/greg28.htm
*************************************************************



      
*************************************************************
You are receiving this mail because you subscribed to mso@xxxxxxxxxxxxx or 
MicrosoftOffice@xxxxxxxxxxxxxxxx

To send mail to the group, simply address it to mso@xxxxxxxxxxxxx

To Unsubscribe from this group, visit the group's homepage and use the dropdown 
menu at the top.  This will allow you to unsubscribe your email address or 
change your email settings to digest or vacation (no mail).
http://www.freelists.org/webpage/mso

To be able to share files with the group, you must join our Yahoo sister group. 
 This group will not allow for posting of emails, but will allow you to join 
and share problem files, templates, etc.:  
http://tech.groups.yahoo.com/group/MicrosoftOffice . This group is for FILE 
SHARING ONLY.

If you are using Outlook and you see a lot of unnecessary code in your email 
messages, read these instructions that explain why and how to fix it:
http://personal-computer-tutor.com/abc3/v28/greg28.htm
*************************************************************

Other related posts: