Results 1 to 4 of 4
  1. #1
    3 Star Lounger
    Join Date
    Mar 2001
    Posts
    309
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Copy data to new spreadsheet (Excel 2002)

    I have a spreadsheet with both ROWS and COLUMNN "hidden"
    (cell + format + hide row/col)
    I want to copy a column to another spreadhseet
    without picking up the hidden cells. (just what is on the screen).

  2. #2
    Gold Lounger
    Join Date
    Feb 2001
    Location
    Dublin, Ireland, Republic of
    Posts
    2,697
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Re: Copy data to new spreadsheet (Excel 2002)

    Select the range of data, press F5 (or Ctrl G) and then select visible cells. You can then copy and paste and the operation should only include the visible cells.

    The following code will copy the visible cells of the current selection and paste to Sheet2, starting at A1.

    Selection.SpecialCells(xlCellTypeVisible).Copy _
    Destination:=Worksheets("Sheet2").Range("A1")

    Andrew C.

  3. #3
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Copy data to new spreadsheet (Excel 2002)

    Select a range including hidden rows and/or columns.
    Select Edit | Goto...
    Click Special...
    Select "Visible cells only".
    Click OK.
    Now you can copy and paste the visible cells.

    If you use this type of operation often, you can put a "Select Visible Cells" button on a toolbar:
    Right-click a toolbar.
    Click Customize...
    In the Commands tab, select the Edit category, then locate the Select Visible Cells command (see small screenshot)
    Drag this command to a convenient location on one of the toolbars.

  4. #4
    2 Star Lounger
    Join Date
    Dec 2000
    Location
    Sault Ste. Marie, Michigan, USA
    Posts
    102
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Copy data to new spreadsheet (Excel 2002)

    After you have "selected a range including hidden rows and/or columns"
    Just type Alt + ; (semicolon) and save a few clicks.

    Ken

Posting Permissions

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