Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

Office - FAQs

Table of Contents

Table of Contents
minLevel1
maxLevel7
excludeTable of Contents


Copying data from within an “Outlined” section of a MS Excel file

Image RemovedImage Added
  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.)