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, 19 May 2017

    Skip Blanks

    Use the 'Paste Special Skip Blanks' option and Excel will not overwrite existing values with blanks.

    1. Select the range B1:B12.

    2. Right click, and then click Copy.



    3. Select cell A1.

    4. Right click, and then click Paste Special.

    5. Check Skip Blanks.



    6. Click OK.


    .
    Posted by
    Labels: