/
Office - FAQs - Copy and Paste in Excel - help with those hidden columns in exporting

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

  1. Select the range or rows to copy.  

      

  1. On the Edit menu, click Go To

     

     3. Click Special

     

     4. Select Visible cells only and then click OK

     

  1. Now Copy & Paste the data 

     

  1. The pasted data contains no outlines. (Now, simply format the data as desired.) 

     


Best Practices

FAQs

 

 

Related content

Office - Reporting - Financial Report Writer
Office - Reporting - Financial Report Writer
More like this
Office - FAQs - Take Advantage of Customizable Grids
Office - FAQs - Take Advantage of Customizable Grids
More like this
Office - Reporting - Interactive Reports - Glossary
Office - Reporting - Interactive Reports - Glossary
More like this