?
Solved

Excel - Restricting Spreadsheet size

Posted on 2002-03-06
3
Medium Priority
?
599 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 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

NFR key for Veeam Agent for Linux

Veeam is happy to provide a free NFR license for one year.  It allows for the non‑production use and valid for five workstations and two servers. Veeam Agent for Linux is a simple backup tool for your Linux installations, both on‑premises and in the public cloud.

Question has a verified solution.

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

Microsoft Office Picture Manager is not included in Office 2013. This comes as a shock to users upgrading from earlier versions of Office, such as 2007 and 2010, where Picture Manager was included as a standard application. This article explains how…
My attempt to use PowerShell and other great resources found online to simplify the deployment of Office 365 ProPlus client components to any workstation that needs it, regardless of existing Office components that may be needing attention.
This video walks the viewer through the process of creating Hyperlinks for the web and other documents. Select the "Insert" tab: Click "Hyperlink":  Type "http://" followed by a web address to reference a website or navigate to a document to ref…
Do you want to know how to make a graph with Microsoft Access? First, create a query with the data for the chart. Then make a blank form and add a chart control. This video also shows how to change what data is displayed on the graph as well as form…

777 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