Results 1 to 5 of 5

Do not copy hidden columns

This is a discussion on Do not copy hidden columns within the Excel Questions forums, part of the Question Forums category; I have a spreadsheet of data that has a few hidden columns. However, if I copy and paste or even ...

  1. #1
    Board Regular
    Join Date
    Oct 2006
    Posts
    186

    Default Do not copy hidden columns

    I have a spreadsheet of data that has a few hidden columns.

    However, if I copy and paste or even paste special it still copies the hidden columns and exposes them so they now show.

    When I use an AutoFilter and copy data it never copies the hidden rows, which is great.
    So is there a method I could use in the same way for my hidden columns, so that it only pastes what shows?
    Regards,

    Bradley

  2. #2
    Board Regular
    Join Date
    Jun 2005
    Location
    London
    Posts
    6,344

    Default Re: Do not copy hidden columns

    Press F5
    Press 'Special'
    Select 'Visible cells only'
    Neil

  3. #3
    VoG
    VoG is offline
    MrExcel MVP
    Moderator
    VoG's Avatar
    Join Date
    Jun 2002
    Location
    127.0.0.1
    Posts
    63,136

    Default Re: Do not copy hidden columns

    Try this: select the data, press F5, click Special, tick Visible Cells Only and click OK. Then copy and paste.
    HTH, Peter
    Please test any code on a copy of your workbook.

  4. #4
    Board Regular
    Join Date
    May 2010
    Location
    Delhi
    Posts
    67

    Default Re: Do not copy hidden columns

    Dear,

    Press F5, Special Select Visible cells only. then copy & paste.

    Ravinder

  5. #5
    Board Regular
    Join Date
    Oct 2006
    Posts
    186

    Default Re: Do not copy hidden columns

    This forum is fantastic!

    I would never of figured that out in a million years, thank you all.
    Regards,

    Bradley

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


DMCA.com