Home |
Search |
Today's Posts |
|
#1
|
|||
|
|||
How do I only show a range of columns/rows in Excel?
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. |
#2
|
|||
|
|||
How do I only show a range of columns/rows in Excel?
Hi Larry
Insert the following code into a module in the workbook. Press Alt+F11 to bring up the VB Editor. InsertModule 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 Larry Zukerman wrote: 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. |
#3
|
|||
|
|||
How do I only show a range of columns/rows in Excel?
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel finds a value that is not in the lookup range | Excel Worksheet Functions | |||
allow users to edit a range in excel 2000 | Excel Discussion (Misc queries) | |||
Display form from an VB application in Excel | Excel Discussion (Misc queries) | |||
Excel Range Names | Excel Discussion (Misc queries) | |||
UDF and Calculation tree | Links and Linking in Excel |