Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Valser
 
Posts: n/a
Default How do I limit number of rows and columns on a spreadsheet

How do I restrict what I see on my screen (and specifically, limit the scroll
feature) to the rows and columns I'm actually using in an Excel 2003 Pro
spreadsheet?

  #2   Report Post  
Gord Dibben
 
Posts: n/a
Default

Valser

Hiding the unused rows and columns then protecting the sheet is one method.

Setting the scrollarea using VBA is another method.

Note: Setting ScrollArea is good for that session only and only the
activesheet. Has to be reset next time workbook is opened.

Best to place the code into a WorkBook_Open Sub in ThisWorkbook module and
specify which worksheet.

Private Sub WorkBook_Open()
Sheets("YourSheet").ScrollArea = "A1:M36"
End Sub


Gord Dibben Excel MVP

On Sat, 12 Feb 2005 10:05:03 -0800, Valser
wrote:

How do I restrict what I see on my screen (and specifically, limit the scroll
feature) to the rows and columns I'm actually using in an Excel 2003 Pro
spreadsheet?


  #3   Report Post  
Valser
 
Posts: n/a
Default

Thank you, Gord, for your quick response. However, I am not an experienced
enough user to understand your answer. I need non-technical language, step
by step. I looked up the suggestions you gave in the Microsoft Excel Help,
but could not understand the directions there either. It's a question of the
technical semantics - defining terms. If you have the patience to deal with
a rank beginner, I'd appreciate detailed step-by-step - where to place the
cursor or which menu to select from - instruction. Thanks, again. Valser

"Gord Dibben" wrote:

Valser

Hiding the unused rows and columns then protecting the sheet is one method.

Setting the scrollarea using VBA is another method.

Note: Setting ScrollArea is good for that session only and only the
activesheet. Has to be reset next time workbook is opened.

Best to place the code into a WorkBook_Open Sub in ThisWorkbook module and
specify which worksheet.

Private Sub WorkBook_Open()
Sheets("YourSheet").ScrollArea = "A1:M36"
End Sub


Gord Dibben Excel MVP

On Sat, 12 Feb 2005 10:05:03 -0800, Valser
wrote:

How do I restrict what I see on my screen (and specifically, limit the scroll
feature) to the rows and columns I'm actually using in an Excel 2003 Pro
spreadsheet?



  #4   Report Post  
Gord Dibben
 
Posts: n/a
Default

OK.

To hide unused rows and columns manually.........

Select first column to the right of your desired area to show.

Hit SHIFT + END + Right Arrow to select all columns.

FormatHide.

Do same for rows below the desired area to show.

If you want to limit the scrollarea.........

Copy the code I provided.

Right-click on the Excel logo left of "File" on the menubar.

Select "View Code"

Paste the code in there.

Revise the "yoursheet" to the name of the sheet you are on and adjust the
"A1:M36" range to suit your needs.

ALT + Q to go back to Excel.

Set your ToolsOptionsSecurityMacro Security to "Medium".

Save and close the workbook.

Re-open and click "enable macros" at the message.

You should not be able to scroll below or to the right of your scrollarea
range set in the code.


Gord



On Sat, 12 Feb 2005 13:43:07 -0800, Valser
wrote:

Thank you, Gord, for your quick response. However, I am not an experienced
enough user to understand your answer. I need non-technical language, step
by step. I looked up the suggestions you gave in the Microsoft Excel Help,
but could not understand the directions there either. It's a question of the
technical semantics - defining terms. If you have the patience to deal with
a rank beginner, I'd appreciate detailed step-by-step - where to place the
cursor or which menu to select from - instruction. Thanks, again. Valser

"Gord Dibben" wrote:

Valser

Hiding the unused rows and columns then protecting the sheet is one method.

Setting the scrollarea using VBA is another method.

Note: Setting ScrollArea is good for that session only and only the
activesheet. Has to be reset next time workbook is opened.

Best to place the code into a WorkBook_Open Sub in ThisWorkbook module and
specify which worksheet.

Private Sub WorkBook_Open()
Sheets("YourSheet").ScrollArea = "A1:M36"
End Sub


Gord Dibben Excel MVP

On Sat, 12 Feb 2005 10:05:03 -0800, Valser
wrote:

How do I restrict what I see on my screen (and specifically, limit the scroll
feature) to the rows and columns I'm actually using in an Excel 2003 Pro
spreadsheet?




Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Row selections by row # OR by even/odd rows in another spreadsheet Tom Excel Discussion (Misc queries) 0 February 9th 05 05:03 PM
Using PROPER for Columns, rows or ENTIRE spreadsheet Tom Excel Worksheet Functions 3 February 4th 05 04:43 PM
Data from a number of rows and columns to one column mark_h82 Excel Discussion (Misc queries) 2 January 15th 05 04:02 AM
Convert multiple columns to rows Lois Lane Excel Worksheet Functions 8 January 10th 05 01:47 AM
interchange columns with rows Herman Excel Discussion (Misc queries) 2 December 8th 04 06:40 PM


All times are GMT +1. The time now is 12:53 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"