There have been occasions when I have had to send just a part of my Excel worksheet data to a colleague in an e-mail. I am sure that some of you have also had the same need occasionally.
Were you aware that you could simply copy and paste any range of cells into the program you use for e-mail? Well, let me quantify that – I have been told that you cannot do this if you use G-mail as your e-mail provider, but I did use it with my G-mail account and it worked just fine for me.
Follow the steps below to learn how:
- Select the range of cells you would like to use.
- Click CTRL + C to copy.
- Go to your e-mail program and click in the body of the message where you would like to paste your data.
You should find several paste options provided by your e-mail program, some of which appear below:
- If you want the recipient to have the ability to edit, add comments or copy your data from your message, you can simply click CTRL + V to paste. Your data with all (most) of the original formatting intact, will be pasted into the e-mail.
- Sometimes you may want to paste your data with no formatting. In that instance look for a Paste as Text option or something similar.
- To paste the data into your e-mail as a static image that the recipient cannot change, select a Paste as Picture or something similar to that.
I hope you find this information as valuable as I did!