Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Copy and paste visible cells to outlook
I created subtotals in Excel. In the list I have 5 field headers. I want to copy subtotals only with corresponding lables to outlook - into email body. My subtotal lables are in column one. and numbers are in column 5. I select this two columns separetly and go to visible cells only. Then I copy. And if I paste it in excel - it works perfectly - pastes just two columns. But when I paste it in Outlook it creates a table with all 5 headers (5 columns). First and last columns have relevant data. And the other three have headers only. I am completely puzzled. Could someone help, please?
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Copy and paste visible cells to outlook
I could get only columns 1 and 5 to copy/paste into Outlook by temporarily
hiding columns 2-4 before the copy/paste. No need to use Goto Special either. -- Jim "Tania UK" wrote in message ... | | I created subtotals in Excel. In the list I have 5 field headers. I want | to copy subtotals only with corresponding lables to outlook - into email | body. My subtotal lables are in column one. and numbers are in column 5. | I select this two columns separetly and go to visible cells only. Then I | copy. And if I paste it in excel - it works perfectly - pastes just two | columns. But when I paste it in Outlook it creates a table with all 5 | headers (5 columns). First and last columns have relevant data. And the | other three have headers only. I am completely puzzled. Could someone | help, please? | | | | | -- | Tania UK |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Copy/Paste Visible cells only | Excel Discussion (Misc queries) | |||
copy and paste visible columns | Excel Discussion (Misc queries) | |||
copy & paste spreadsheet cells from excel to outlook to excel | Excel Discussion (Misc queries) | |||
Copy & Paste Visible Cells with Formulas | Excel Worksheet Functions | |||
Excel Copy/Paste into Outlook | Excel Discussion (Misc queries) |