how to skip the blank cells

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel 2003 - Skip a cell 5
VBA Script 1
paste special 3
Skipping Blanks (Again) 2
Excel 2002: How to avoid pasting blanks ? 3
Even after selecting "skip blanks" in the paste special menu in e. 1
Even after selecting "skip blanks" in the paste special menu in e. 5
Access Skip address field if previous field is blank 2

Back
Top