Deleting unused cells in excel

[BlackPanther]

Hi everyone,

I tried to delete the unused cells , But couldnt find a option & tried to hide all the cells & it worked but . i want this to be saved in .csv file. After saving the same on .cvs file , the hidden cells are visible .

My query is there any option to hide or delete unused cells while saving in .csv file?

Thanks in advance

 

[shg]

Clear all unused rows and columns, then delete all unused rows and columns, then save, close and reopen the worbook. Then save as csv.

 

[BlackPanther]

i did the same , but i dont want to see unused cells . Hope you got my point. it wont get saved in .csv. i could share u the file , but i dont see any option of sharing in here , i am new to Mr.excel

 

[shg]

Excel doesn't export unused cells. If you follow the instructions, it won't.

You can put the workbook on box.net or dropbox and post a link, and I'll do it for you.

 

[BlackPanther]

check your pm , sent you the link inthere .

 

[shg]

When I save that as csv exactly as you uploaded it, I get nothing extra in the output:

bfnbgn,bfnbgn,bfnbgn,bfnbgn,bfnbgn,bfnbgn,bfnbgn,bfnbgn
bfnbgn,bfnbgn,bfnbgn,bfnbgn,bfnbgn,bfnbgn,bfnbgn,bfnbgn
bfnbgn,bfnbgn,bfnbgn,bfnbgn,bfnbgn,bfnbgn,bfnbgn,bfnbgn
bfnbgn,bfnbgn,bfnbgn,bfnbgn,bfnbgn,bfnbgn,bfnbgn,bfnbgn
bfnbgn,bfnbgn,bfnbgn,bfnbgn,bfnbgn,bfnbgn,bfnbgn,bfnbgn
bfnbgn,bfnbgn,bfnbgn,bfnbgn,bfnbgn,bfnbgn,bfnbgn,bfnbgn
bfnbgn,bfnbgn,bfnbgn,bfnbgn,bfnbgn,bfnbgn,bfnbgn,bfnbgn
bfnbgn,bfnbgn,bfnbgn,bfnbgn,bfnbgn,bfnbgn,bfnbgn,bfnbgn
bfnbgn,bfnbgn,bfnbgn,bfnbgn,bfnbgn,bfnbgn,bfnbgn,bfnbgn
bfnbgn,bfnbgn,bfnbgn,bfnbgn,bfnbgn,bfnbgn,bfnbgn,bfnbgn
bfnbgn,bfnbgn,bfnbgn,bfnbgn,bfnbgn,bfnbgn,bfnbgn,bfnbgn
bfnbgn,bfnbgn,bfnbgn,bfnbgn,bfnbgn,bfnbgn,bfnbgn,bfnbgn
bfnbgn,bfnbgn,bfnbgn,bfnbgn,bfnbgn,bfnbgn,bfnbgn,bfnbgn
bfnbgn,bfnbgn,bfnbgn,bfnbgn,bfnbgn,bfnbgn,bfnbgn,bfnbgn
bfnbgn,bfnbgn,bfnbgn,bfnbgn,bfnbgn,bfnbgn,bfnbgn,bfnbgn
bfnbgn,bfnbgn,bfnbgn,bfnbgn,bfnbgn,bfnbgn,bfnbgn,bfnbgn
bfnbgn,bfnbgn,bfnbgn,bfnbgn,bfnbgn,bfnbgn,bfnbgn,bfnbgn
bfnbgn,bfnbgn,bfnbgn,bfnbgn,bfnbgn,bfnbgn,bfnbgn,bfnbgn
bfnbgn,bfnbgn,bfnbgn,bfnbgn,bfnbgn,bfnbgn,bfnbgn,bfnbgn
bfnbgn,bfnbgn,bfnbgn,bfnbgn,bfnbgn,bfnbgn,bfnbgn,bfnbgn
bfnbgn,bfnbgn,bfnbgn,bfnbgn,bfnbgn,bfnbgn,bfnbgn,bfnbgn

 

[shg]

BTW, there is no need to hide unused rows and columns before saving.