Excel how-to

Jun
3
2003
Tags:
Comments (1)

This is an entry more for my record keeping than any other reason. The question is how to best create summary tables in Excel. The data I have has a row for each customer and sets of columns for each month. Each customer row had data in only one set of columns. Subtotal gives an easy way to consolidate this data onto a single line. The problem comes in that if you copy the excel data with the sub-rows hidden they show up in the pasted data

The solution: This only happens if you paste into Excel. Paste into a text editor, select all and paste back into Excel and voila. All is good.

No votes yet

Comments

Oct
9
2009

This is an entry more for my

by ajay

This is an entry more for my record keeping than any other reason. The question is how to best create summary tables in Excel. The data I have has a row for each customer and sets of columns for each month. Each customer row had data in only one set of columns. Subtotal gives an easy way to consolidate this data onto a single line. The problem comes in that if you copy the excel data with the sub-rows hidden they show up in the pasted data

Post new comment

The content of this field is kept private and will not be shown publicly.
  • Link to Amazon products with: [amazon product_id inline|full|thumbnail|datadescriptor]. Example: [amazon 1590597559 thumbnail] or [amazon 1590597559 author]. Details are on the Amazon module handbook page.
  • Twitter-style @usersnames are linked to their Twitter account pages.
  • Twitter-style #hashtags are linked to search.twitter.com.
  • Allowed HTML tags: <a> <b> <dd> <dl> <dt> <i> <li> <ol> <u> <ul><p> <img> <table> <tr> <td><strong><em><sup><div><fn><h1><h2><h3><h4><blockquote><img style="">
  • Use [fn]...[/fn] (or <fn>...</fn>) to insert automatically numbered footnotes.
  • You may insert videos with [video:URL]
  • Lines and paragraphs break automatically.
  • Web page addresses and e-mail addresses turn into links automatically. (Better URL filter.)
  • You may post code using <code>...</code> (generic) or <?php ... ?> (highlighted PHP) tags.

More information about formatting options