I believe I have found a solution to removing blank rows at the bottom of
your worksheet so they do not display - at least until you page down past the
last displayed row again.
highlight (pick) an entire column, then F5specialblanksOK
then editdeleteentire row
The rows may still be displayed at this point but if you save and reopen the
file they will all be gone.
Understand that all these rows are still in the "worksheet" but just not
displayed on the screen and if you copy a number or formula down a column it
will only copy to the number of displayed rows.
Regards
Ed

"Irishcauffey" wrote:

I am working with a very large workbook and need to remove unformated or used
rows and columsn. I am new to excel and need some help please.