Solved

Excel - Restricting Spreadsheet size

Posted on 2002-03-06
3
576 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 50 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

Why You Should Analyze Threat Actor TTPs

After years of analyzing threat actor behavior, it’s become clear that at any given time there are specific tactics, techniques, and procedures (TTPs) that are particularly prevalent. By analyzing and understanding these TTPs, you can dramatically enhance your security program.

Join & Write a Comment

Article by: dandraka
There are several quick shortcuts that can make your life easier in Microsoft Programs.  These simple tips and tricks will your work more productive and you faster at completing your tasks! MS Word (1) Creating Re-usable Scraps You can create s…
No matter the version of Windows you are using, you may have some problems with Windows Search running too slow or possibly not running at all. Before jumping into how you can solve this issue, just know there are many other viable alternative deskt…
This video shows where to find the word count, how to display it, and what it breaks down to in Microsoft Word.
The viewer will learn how to simulate a series of sales calls dependent on a single skill level and learn how to simulate a series of sales calls dependent on two skill levels. Simulating Independent Sales Calls: Enter .75 into cell C2 – “skill leve…

747 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

Need Help in Real-Time?

Connect with top rated Experts

12 Experts available now in Live!

Get 1:1 Help Now