DW Faisalabad New Version

DW Faisalabad New Version
Please Jump to New Version
  • Working with Tables
    • While there are four types of database objects in Access, tables are arguably the most ... read more
    Octber 25 2017

    Friday, 17 February 2017

    Copy Visible Cells Only

    By default, Excel copies both visible and hidden cells. However, it is possible to copy visible cells only.

    In this example, row 2 is hidden.


    When you copy/paste this range, this is the result:


    To copy visible cells only, execute the following easy steps.

    1. Select the range A1:A4.

    2. On the Home tab, click Find & Select, Go To Special...


    3. Click Visible cells only and click OK.


    Excel selects the visible cells.

    4. Press Ctrl + c to copy the range.

    5. Select cell A6 and press Ctrl + v to paste the range.

    Result:


    .
    Posted by
    Labels: