Home |
Search |
Today's Posts |
|
#1
|
|||
|
|||
Paste Special - Skip Blanks
Hi there! Using E02 in XP. I have a section of data that I
am copying for use elsewhere and I have a few rows that have data in Col A but Cols B-H are blank. I tried the Paste Special and selected Skip Blanks but still got all the lines. Could have sworn I've used it before and was able to identify which Col or Cols to look at for the blanks kind of like when you use Data/Sort. Can anyone put me back on track? Thanks in advance for any help or advice!!! |
#2
|
|||
|
|||
Bonnie
If you read the Help on "skip blanks" you will get a better understanding of its function. "skip blanks" will still copy blank cells, but those blanks will not over-write existing data. If you truly don't want to copy blanks, autofilter them out them F5SpecialVisible cell onlyOK. Copy those selected cells. Gord Dibben Excel MVP On Thu, 3 Mar 2005 10:13:22 -0800, "Bonnie" wrote: Hi there! Using E02 in XP. I have a section of data that I am copying for use elsewhere and I have a few rows that have data in Col A but Cols B-H are blank. I tried the Paste Special and selected Skip Blanks but still got all the lines. Could have sworn I've used it before and was able to identify which Col or Cols to look at for the blanks kind of like when you use Data/Sort. Can anyone put me back on track? Thanks in advance for any help or advice!!! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
paste special (values) | Excel Worksheet Functions | |||
Paste Special Skip Blanks not skipping blanks, but overwriting... | Excel Discussion (Misc queries) | |||
Even after selecting "skip blanks" in the paste special menu in e. | Excel Discussion (Misc queries) | |||
Even after selecting "skip blanks" in the paste special menu in e. | Excel Discussion (Misc queries) | |||
Paste Special Question | Excel Discussion (Misc queries) |