Error Checking in Excel
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 3 of 3

Thread: copy/paste hidden column/row

  1. #1
    New Member
    Join Date
    Mar 2002
    Posts
    11
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Just curious,
    I hid column B, D, F
    Then I selected the visible colums, A to G
    So when I am pasting, I expect only to see column A, C, E, G.. but the hidden columns are shown as well.. Is there a way to work around this??

  2. #2
    MrExcel MVP Tom Urtis's Avatar
    Join Date
    Feb 2002
    Location
    San Francisco, California USA
    Posts
    11,162
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    There are a few ways to work around that. Maybe the least complicated, which doesn't involve VBA, is to select your column range A:G while B, D, and F are hidden as you say. Next, try clicking on Edit > Go To, Special, select "Visible cells only" and click OK. Then copy that selection, and go to your destination range and paste. What should show up is the data in A, C, E, and G.

    If this is a task you need to repeat often we could automate it, but to keep things simple, see if this method here does what you want first.

  3. #3
    New Member
    Join Date
    Mar 2002
    Posts
    39
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    There is also a button which selects visible cells.
    You will find it under Edit in the Customize menu.

    Russell

Some videos you may like

User Tag List

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
  •