How to Delete Extra Cells and Columns
 

Dear Readers,
Can anyone tell me how can I delete the rest of columns and rows of
worksheet which I dont want. I mean to say I work in excel, my workplace is
just the size of my monitor screen. But there or millions of other cells and
rows which are completely blank and useless. Is there any way to delete the
rest of the worksheet and only my workplace stays visible and the rest of it
disapears. I'll be realy grateful for your help. Thanks.

How to Delete Extra Cells and Columns
 

Notdony

Can't delete them but you can select them and hide them.

Mike Rogers

"Notdony" wrote:

Dear Readers,
Can anyone tell me how can I delete the rest of columns and rows of
worksheet which I dont want. I mean to say I work in excel, my workplace is
just the size of my monitor screen. But there or millions of other cells and
rows which are completely blank and useless. Is there any way to delete the
rest of the worksheet and only my workplace stays visible and the rest of it
disapears. I'll be realy grateful for your help. Thanks.

How to Delete Extra Cells and Columns
 

An alternate method to Mike's would be to set the scrollarea so's users could
not stray out of your designated area.

Since the scrollarea method does not stick between sessions you will have to
reset it each time you open the workbook.

You may wish to place the code into a WorkBook_Open Sub in ThisWorkbook module
and specify which worksheet if only one sheet required.

Adjust the sheetname and range to suit.

Private Sub WorkBook_Open()
Sheets("YourSheet").ScrollArea = "A1:M36"
End Sub

Or also in the Thisworkbook module to limit scrollarea on all sheets.

Private Sub Workbook_SheetActivate(ByVal Sh As Object)
With ActiveSheet
.ScrollArea = "A1:M36"
End With
End Sub


Gord Dibben MS Excel MVP


On Wed, 18 Jun 2008 07:19:02 -0700, Notdony
wrote:

Dear Readers,
Can anyone tell me how can I delete the rest of columns and rows of
worksheet which I dont want. I mean to say I work in excel, my workplace is
just the size of my monitor screen. But there or millions of other cells and
rows which are completely blank and useless. Is there any way to delete the
rest of the worksheet and only my workplace stays visible and the rest of it
disapears. I'll be realy grateful for your help. Thanks.