[mso] Re: Excel "insert"

Good  point, I forgot about that. Mea Culpa. But changing the range s/b  
simpler than inserting a bunch of.
 
Too bad  Excel can't permanently "lock" a range. 
 
Larry
--- On Mon, 24 Nov 2008 18:39:53 -0800 (PST) Jonathan Drawer 
_jdrawer07@xxxxxxxxxx (mailto:jdrawer07@xxxxxxxxx)  wrote: 
From:  Jonathan Drawer <jdrawer07@xxxxxxxxx>
Subject: [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
*************************************************************

Other related posts: