How do I only show a range of columns/rows in Excel?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I only want to view, say, columns A thru K and rows 1 thru 23. Even if I
scroll, I still don't want the sheet to go out of that range.
 
Hi Larry

Insert the following code into a module in the workbook.
Press Alt+F11 to bring up the VB Editor.
Insert>Module and paste the code below into the module.
Change the sheet name to your sheet name if it is different to Sheet1

Sub Auto_Open()

ThisWorkbook.Worksheets("Sheet1").ScrollArea = "A1:K23"
End Sub


Regards

Roger Govier
 
hide the colmns and rows
select column L then shift,end , right until you are at the end of the
sheet go to format,columns,hide
do the same for the rows
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel How to run multiple Private Sub Worksheet_Change(ByVal Target As Range) 0
I must make certain I have a specific range of numbers present. 3
Excel Limit to Named Ranges 1
Excel Complex Summing 3
VBA group the number in the Column and Copy to the new worksheet. 0
moving answer from one sheet to another 1
how do i move columns on one sheet to columns on another sheet 1
Loop returns only one value, does not loop & an assignment to columnhow-to problem. 26

Back
Top