Solved

Excel - Restricting Spreadsheet size

Posted on 2002-03-06
3
592 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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

Technology Partners: 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!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In this article we discuss how to recover the missing Outlook 2011 for Mac data like Emails and Contacts manually.
I was prompted to write this article after the recent World-Wide Ransomware outbreak. For years now, System Administrators around the world have used the excuse of "Waiting a Bit" before applying Security Patch Updates. This type of reasoning to me …
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…
The viewer will learn how to  create a slide that will launch other presentations in Microsoft PowerPoint. In the finished slide, each item launches a new PowerPoint presentation and when each is finished it automatically comes back to this slide: …

739 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