 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / Worksheet Functions / June 2006paste only subtotals, not individual date that makes up subtotal
i only want to copy & paste the subtotals, not the supporting data thanks Hi Judy, select the subtotals copy and paste special as values > i only want to copy & paste the subtotals, not the supporting data > > thanks where is the subtotal copy?- if i use the regular copy & paste special -values i still paste all the supporting date not just the subtotal rows > Hi Judy, > [quoted text clipped - 3 lines] > > > > thanks Try hiding the details then select the range and then one more step edit|goto|special|visible cells only Now do the edit|copy and edit|paste. > where is the subtotal copy?- if i use the regular copy & paste special > -values i still paste all the supporting date not just the subtotal rows [quoted text clipped - 6 lines] > > > > > > thanks  SignatureDave Peterson Ok Judy, you are coping the entire figures, as the rows are hiding, try to select the area, press F5 click on the Special botton, select visible only. hope this helps regards from Brazil Marcelo > where is the subtotal copy?- if i use the regular copy & paste special > -values i still paste all the supporting date not just the subtotal rows [quoted text clipped - 6 lines] > > > > > > thanks |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2009 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.