• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 611
  • Last Modified:

Excel - Restricting Spreadsheet size

Is it possible without hiding the columns/rows to restrict the spreadsheet to a certain no. of rows/columns?? I know that there is a way of doing this, but I can't remember how to do it.

Any help will be most welcome.
0
yeggstry
Asked:
yeggstry
  • 2
1 Solution
 
tureCommented:
veggstry,

No, there is no way to change the size of an Excel worksheet. The sheet is always 256 columns * 65536 rows.
The only way to make a sheet look as if it has fewer rows or columns is to hide rows or columns, as suggested by yourself.

Ture Magnusson
Karlstad, Sweden
0
 
tureCommented:
Or perhaps you just want to restrict the ACCESS to a certain part of the worksheet? That can be done!

Manually:
1. Show control toolbox (View - Toolbar - Control toolbox)
2. With any cell selected, click the "Properties" button in the control toolbox
3. Set the ScrollArea property to A1:E10
4. Close the properties window and the Control Toolbox

This setting will NOT be saved with the workbook. To have it set again automatically when reopening the workbook, you must use a VBA procedure. Put this code in ThisWorkbook:

Private Sub Workbook_Open()
  Worksheets("Sheet1").ScrollArea = "A1:E10"
End Sub

Ture Magnusson
Karlstad, Sweden
0
 
yeggstryAuthor Commented:
Thanks m8, that is EXACTLY what I wanted!!!!

Thanks for your time

Yeggstry
0

Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now