Logo 
Search:

MS Office Answers

Ask Question   UnAnswered
Home » Forum » MS Office       RSS Feeds
  Question Asked By: Trupti Patil   on Nov 27 In MS Office Category.

  
Question Answered By: Rayner Fischer   on Nov 27

I often cut-n-paste lists from one WorkSheet to another. Select the
list and make a note of how many cells you're selecting; then go to
the destination Sheet and select the same number of cells and paste
(or it's equivalent Ctrl-V). With the "totals" in Column H, you might
need to use "Paste Special." You'll need to do this if the totals  are
referencing other data in which case the cells actually would contain
formulas like "=SUM(B1:G1)." By using Paste Special you'll have the
option to "Paste Values." ...Of course if this list  is in fact a
total of other values AND you want this list to dynamically add up
these values you'll have to be more careful.

Share: 

 

This Question has 6 more answer(s). View Complete Question Thread

 
Didn't find what you were looking for? Find more on total newbie question Or get search suggestion and latest updates.


Tagged: