| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
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! |
|
#2
|
|||
|
|||
|
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! |
|
#3
|
|||
|
|||
|
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! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how can you view cells from different worksheets in to one sheet,. | Excel Discussion (Misc queries) | |||
| Entering Data in multiple cells on one sheet & having it auto upda | Excel Worksheet Functions | |||
| Copying cells downward on sheet | New Users to Excel | |||
| linking multiple sheets to a summary sheet | Excel Discussion (Misc queries) | |||
| how can i select all the cells with same color on a sheet if there are multipale colors by vba code | Charts and Charting in Excel | |||
Linear Mode
