Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Delete Extra Pages | Excel Discussion (Misc queries) | |||
Delete extra pages | Excel Worksheet Functions | |||
delete extra space | Excel Worksheet Functions | |||
delete extra columns and rows | Excel Discussion (Misc queries) | |||
how do i delete the extra empty rows and columns that i dont need. | Excel Discussion (Misc queries) |