Extra cells removal. EXCEL

[Solved/Closed]
Report
-
 Carman -
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

Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
768
You cannot delete unused rows

you can hide them or you can have backgroud in such color that they seem to have disappear
1
Thank you

A few words of thanks would be greatly appreciated. Add comment

CCM 2821 users have said thank you to us this month

* I want to delete all the unneeded rows.