I'm wanting to copy data from a sheet with deleted columns (ie. goes straight from G to I, K to M etc.) When I copy the list of values I get blanks where those missing columns would have been, which I don't want. How do I get rid of them or prevent this happening? I'm using Excel 2010.
Thanks in advance, I'd really appreciate any help!
for that u need to copy the datas without blanks. U can find it in filter option. Or you can copy whole datas with blanks also, then filter only blanks. then
u can sort it the way u want.l
Could be easier if u could upload a file.
thanks,
Ryan
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks