ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Is there a way to cut off unused cells on a sheet (https://www.excelbanter.com/excel-discussion-misc-queries/38494-there-way-cut-off-unused-cells-sheet.html)

newbie

Is there a way to cut off unused cells on a sheet
 
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!

Don Guillett

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

--
Don Guillett
SalesAid Software

"newbie" wrote in message
...
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!




Ron de Bruin

Maybe you must save/close/re-open

More info here
http://www.contextures.com/xlfaqApp.html#Unused

--
Regards Ron de Bruin
http://www.rondebruin.nl


"Don Guillett" wrote in message ...
A manual way is to goto the last used row and delete all rows below. Do the
same with columns. SAVE

--
Don Guillett
SalesAid Software

"newbie" wrote in message
...
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!







All times are GMT +1. The time now is 07:11 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com