Extra cells removal. EXCEL

Solved/Closed
Carman - Jul 12, 2010 at 08:18 PM
 Carman - Jul 13, 2010 at 08:03 PM
Hello,
Does anyone know how to hide unused cells in excel?

I have got a program that does all the matching for me, but everytime when i finished loading the program ( the program itself is successful), it results in a few thousands more empty cells after my last data.

What can i do the make excel Not producing the extra blank cells? And only give the number of cells that i need ( no blank cells after the last data).

Thanks.

2 replies

rizvisa1
Posts
4479
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
770
Jul 13, 2010 at 08:03 AM
You cannot delete unused rows

you can hide them or you can have backgroud in such color that they seem to have disappear
1
Thanks!
0
* I want to delete all the unneeded rows.
0