Results 1 to 3 of 3
  1. #1
    New Lounger
    Join Date
    Sep 2003
    Posts
    11
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Copy Values (XP)

    Isn't there a way to copy a worksheet that has hidden rows/columns and paste it into a new sheet with those columns still hidden OR not even there?

  2. #2
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts

    Re: Copy Values (XP)

    Yes to both

    To copy with the hidden rows, rt-click the worksheet tab
    move or copy
    check "create a copy"
    <ok>

    To copy a region and NOT copy the hidden items:
    Select the range
    Edit - goto - special
    check "visible cells only"
    <ok>
    edit -copy
    Go to the sheet to copy
    edit -paste

    Steve

  3. #3
    New Lounger
    Join Date
    Sep 2003
    Posts
    11
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Copy Values (XP)

    Thanks Steve! That is perfect.

Posting Permissions

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