Office - FAQs - Copy and Paste in Excel - help with those hidden columns in exporting
Table of Contents
Overview
This guide will show how to copy and paste data from Excel.
Required Permissions
Copying data from within an “Outlined” section of a MS Excel file
Select the range or rows to copy.
On the Edit menu, click Go To
3. Click Special
4. Select Visible cells only and then click OK
Now Copy & Paste the data
The pasted data contains no outlines. (Now, simply format the data as desired.)
Best Practices
FAQs
, multiple selections available, Use left or right arrow keys to navigate selected items