Improve company productivity with a Business Account.Sign Up

x
?
Solved

Excel - Restricting Spreadsheet size

Posted on 2002-03-06
3
Medium Priority
?
614 Views
Last Modified: 2012-06-21
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
Comment
Question by:yeggstry
  • 2
3 Comments
 
LVL 22

Expert Comment

by:ture
ID: 6844269
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
 
LVL 22

Accepted Solution

by:
ture earned 200 total points
ID: 6844283
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
 

Author Comment

by:yeggstry
ID: 6844415
Thanks m8, that is EXACTLY what I wanted!!!!

Thanks for your time

Yeggstry
0

Featured Post

Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

As a person who answers a lot of questions, I often see code that could be simplified, made easier to read, and perhaps most importantly made easier to maintain if the code was modified to use the Select Case statement. This article explains how to…
Usually, rounding is performed by some power of 10 - to thousands, hundreds, tens, or integer - or to one, two, or more decimals. But rounding can also be done to a power of two, say, 16 or 64, or 1/32 or 1/1024, even for extreme values.
Learn how to create and modify your own paragraph styles in Microsoft Word. This can be helpful when wanting to make consistently referenced styles throughout a document or template.
This lesson discusses how to use a Mainform + Subforms in Microsoft Access to find and enter data for payments on orders. The sample data comes from a custom shop that builds and sells movable storage structures that are delivered to your property. …

608 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question