Word/outlook

Hello Sujal,

Hope you enjoyed your Microsoft Word course with Best STL.

Thank you for your question regarding copying data containing hidden rows and columns from Word / Excel into Outlook.

First let's look at copying from Excel. If you have hidden rows and columns and select an area to copy... when you paste into Outlook you will not see the hidden rows/columns. If you paste into an EXCEL worksheet then the hidden rows/columns will be pasted as well as the selected area.

To prevent this happening when pasting in an Excel worksheet first select the area you wish to copy then click Find & Select on the Home ribbon. From here click Go to Special then select Visible Cells Only and click OK. Now when you copy the selected area the hidden rows/columns will not be copied.

Copying from Word shouldn't be a problem since since tables do not have hidden rows and columns.

When you finally paste into Outlook a table will be created the same as in Word.

I hope this resolves your question. If it has, please mark this question as resolved.

If you require further assistance, please reply to this post. Or perhaps you have another Microsoft Office question?

Have a great day.
Regards,

Rodney
Microsoft Office Specialist Trainer