ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   how to skip the blank cells (https://www.excelbanter.com/excel-discussion-misc-queries/1291-how-skip-blank-cells.html)

nayeemoddin

how to skip the blank cells
 
hi,
i copied some cells including blank, but after checking the skip blank
button when i try to paste the blank cells are also copied.

Rrneri

Select the copied cells including the blank...
....Select Edit then Go to (ctrl G)
Click the special botton...select BLANKS click OK
the performed delete command
-----Original Message-----
hi,
i copied some cells including blank, but after checking

the skip blank
button when i try to paste the blank cells are also

copied.
.



All times are GMT +1. The time now is 05:18 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com