Excel Tips & Tricks
Convert Excel Data into a Friendlier Format
Have you ever tried to paste information from an Excel spreadsheet into another application like Outlook or MyPCC? The problem is that it shows up in Excel format, “trapped” within cells and columns and rows. This often makes it impossible to use the data compatibly with other applications.
Here’s how to take Excel content and remove all the rows and cells so you can use it for virtually anything you want, with a little help from MS Word.
- In Excel, highlight the cells you want to work with (only).
- Copy the cells.
- Open a blank Word document.
- Paste the cells you copied from Excel. (Ctrl + v is the keystroke shortcut.)
- Highlight the information you just pasted.
- Click on the “Layout” tab, located on the upper right of your screen.
That's the "Layout" tab, NOT "Page Layout."
- Click the button, located on the upper right (within your toolbar icons).
- In the mini-window that appears, choose Tabs, then click OK.
No more rows or columns!
You may want to do some other formatting with your data, like remove the line separators or add a comma between each entry. Once you've done that, your data is all ready to paste into an email, MyPCC, or whatever else you want to do with it.