Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
copied subtotals only
Excel 2007 I had three very large sheet 70,000 plus rows. I arranged and subtotaled these as needed and then copied only the subtotals by using Find and Select Go To special visible cells only then copy and pasted this info to a new sheet. When I save these in the 97-2003 format i got a message that said it was too many lines and would be truncated. Since I only had about 15 rows of data on each sheet. Now when I do control end the cursor goes to N65536. I know there is no data past row 30. The file says it's over 6 megs in size and it should only be a few hundred K at most. How can I trim this thing down so that I can email it? gls858 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Original subtotals should not be within nested subtotals in excel | Excel Worksheet Functions | |||
Subtotals: Nested subtotals below higher subtotal | Excel Discussion (Misc queries) | |||
How do I copy an outline w/ subtotals & paste just the subtotals | Excel Discussion (Misc queries) | |||
Problem with nested subtotals, placing secondary subtotals BELOW . | Excel Discussion (Misc queries) | |||
why are nested subtotals coming out below outer subtotals? | Excel Worksheet Functions |