Is there a way to cut off unused cells on a sheet

N

newbie

It seems there are an infinite number of cells on a sheet. As I really dont
have much info to enter on each sheet I was hoping there was a way I could
somehow cut off all the extra stuff to the sides and bottoms. It is a hassle
because everytime I scroll, it will scroll off the side or bottom way past
what I was looking for.

Thanks!
 
D

Don Guillett

A manual way is to goto the last used row and delete all rows below. Do the
same with columns. SAVE
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How do I turn scroll lock off (2007 excel)? No scroll lock key 1
Info cut off in a cell 3
Embedded chart not appearing correctly in PDF 0
Formula Audit mode active in one column only; cannot kill. 2
How do I conceal the unused range from the scroll bar? 1
Text Cutting Off When Printing 1
automating data across cells/sheets 0
mail merge (word 2010) cuts off the text after 255 characters 1

Top