Copying Non-Continuous Rows

  • Thread starter Thread starter Jonathan S.
  • Start date Start date
J

Jonathan S.

Hi All,

Thanks in advance for your responses.

My boss noticed an unusual behavior the other day when sending email
that had data pasted into it from Excel 2000. I'm hoping one of you will
have a possible explanation / solution for us.

He was copying two non-continuous rows into his email program. The way
he did so was to hide the intervening rows between what he wanted copy.
For example, in a 15 row spreadsheet, if he wanted to copy just rows 1
and 15 he would hide 2-14, then select 1 and 15, and copy.

The resulting two rows would appear fine in the outbound email, and on
the stored message in his outbox. However, some of the responses he got
back that quoted his original message contained all 15 rows of data.

Because my boss uses a non-standard email program, I also tested on
Outlook 2000 and got the same results.

It appears that despite rows 2-14 being hidden, Excel is copying them
anyway, and it's appearing in the email source with a style sheet
command to keep the row hidden as well. What I've found through testing
is that AOL Mail, Eudora, Yahoo!, Hotmail, and any text only client will
display all 15 rows of data.

I don't believe this is an email program issue since the extra data had
to have some from Excel. So, my question is this: Is there any way to
copy two non-continuous rows of data without in any way copying the
intervening rows? I already tried CRTL + Click to see if that would
work, but it did the same thing.

Thanks!

Jonathan
 
Off the wall guess:

Copy the two columns to a new sheet and e-mail that.

If the two columns contain formulas dependant on the other columns in the
sheet, then just
<Copy> <PasteSpecial> <Values> <OK>
--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================

Hi All,

Thanks in advance for your responses.

My boss noticed an unusual behavior the other day when sending email
that had data pasted into it from Excel 2000. I'm hoping one of you will
have a possible explanation / solution for us.

He was copying two non-continuous rows into his email program. The way
he did so was to hide the intervening rows between what he wanted copy.
For example, in a 15 row spreadsheet, if he wanted to copy just rows 1
and 15 he would hide 2-14, then select 1 and 15, and copy.

The resulting two rows would appear fine in the outbound email, and on
the stored message in his outbox. However, some of the responses he got
back that quoted his original message contained all 15 rows of data.

Because my boss uses a non-standard email program, I also tested on
Outlook 2000 and got the same results.

It appears that despite rows 2-14 being hidden, Excel is copying them
anyway, and it's appearing in the email source with a style sheet
command to keep the row hidden as well. What I've found through testing
is that AOL Mail, Eudora, Yahoo!, Hotmail, and any text only client will
display all 15 rows of data.

I don't believe this is an email program issue since the extra data had
to have some from Excel. So, my question is this: Is there any way to
copy two non-continuous rows of data without in any way copying the
intervening rows? I already tried CRTL + Click to see if that would
work, but it did the same thing.

Thanks!

Jonathan
 
Want something even scarier - You may find that if you click on the data in the
email and then look at the bottom of the data you will see the sheet tabs, and
then realise that every bit of that file went with that email and not just the
rows he copied.

Ron De Bruin has a superb addin for anyone that regularly mails data from
Excel:-

http://www.rondebruin.nl/sendmail.htm#Add-in

Failing that, I would hide the rows you don't want, select the range you do, do
Edit / Go To / Special / Visible cells only, then copy and paste to a new sheet
in a new book. Then copy and send that data.
 
Jonathan S. said:
He was copying two non-continuous rows into his email program. The way
he did so was to hide the intervening rows between what he wanted copy. [...]
The resulting two rows would appear fine in the outbound email, and on
the stored message in his outbox. However, some of the responses he got
back that quoted his original message contained all 15 rows of data.
Click to expand...

Of course they did, since he pasted them there. An Excel selection
includes everything selected, whether visible or not. What happens to
the hidden rows depends on the 'pastee' application: Word will mark
the characters as 'hidden', but will display them if you press
Show/Hide ¶. Notepad will omit the hidden stuff. Outlook will behave
like Word if the email is in RTF or [shudder]HTML[/ugh] format,
otherwise it'll behave like Notepad.

The obvious solution seems to be to select only the desired rows (by
whatever method - holding down Ctrl, or using the 'Select Visible
Cells' command[1]) and copying and pasting that. Problem is, the
clipboard can't deal with multiple selections, so it will simply
include everything between the top left and bottom right corners of
the selected areas. Whoops.

To achieve what he wants, your boss needs to 'Select Visible Cells',
then copy and paste to a blank area within Excel, *then* copy and
paste that *single* selection to the email or wherever.

[1] The only way I know of to access this very useful command is to
add a button to your toolbar. (Tools > Customize > Commands tab >
select Edit on the left, scroll to near the bottom of the list on the
right, select the command and drag it to a toolbar.)
 
Back
Top