Not sure what I need to ask

[Brown]

Once I have a SS created is there are way to only view it and not have infinite cells to scroll through?
I guess what I am asking is can I freeze the entire SS?
I hope I am making sense.
Thanks
Brown

 

[pedie]

Once I have a SS created is there are way to only view it and not have infinite cells to scroll through?

I guess what I am asking is can I freeze the entire SS?
I hope I am making sense.
Thanks
Brown

what is SS? Social Security?

 

[cstimart]

Once I have a SS created is there are way to only view it and not have infinite cells to scroll through?
I guess what I am asking is can I freeze the entire SS?
I hope I am making sense.
Thanks
Brown

What version of Excel? When I used to use 2003, I would just "Hide" the unused Columns/Rows on my SS (SpreadSheet).

 

[Brown]

SS = Spread Sheet
not sure I will ever see Social Security

I will try to hide the others.
I am working between two versions of Excel right now, 2007 and 10

 

[Brown]

I dont think the hide option will work, I tried to scroll over to the right to see how many cells I would have to hide and ended up scrolling over about 4000 cells before I stopped.

 

[pedie]

SS = Spread Sheet

not sure I will ever see Social Security

I will try to hide the others.
I am working between two versions of Excel right now, 2007 and 10

Oh alright
you can set scroll range like this in vba or freeze the sheet and protect it...maybe...totally up to you...

[/FONT]
[FONT=Courier New]Sheet1.ScrollArea = "A1:A100"[/FONT]
[FONT=Courier New]

however if you have to use the code then you'll have to run this code on start many thisworkbook.open event...

 

[mikerickson]

What is the issue?
If you have all your data in the upper left cells of the spreadsheet, just ignore the empty vastness and don't scroll.

Why would one need to scroll through "infinite cells"?

 

[cstimart]

What is the issue?
If you have all your data in the upper left cells of the spreadsheet, just ignore the empty vastness and don't scroll.

Why would one need to scroll through "infinite cells"?

What if there's important/secret data hidden in Cell KLA99999?

 

[Taul]

as long as you type something in cell C3, the view area would be restricted to A1:G16

Private Sub Worksheet_Change(ByVal Target As Range)
   If Target.Cells.Count = 1 And Target.Address = "$C$3" Then
  
      If LCase(Target.Value) <> "" Then
         Rows("17:65536").EntireRow.Hidden = True
         Columns("H:IV").EntireColumn.Hidden = True
      Else
        Rows("17:65536").EntireRow.Hidden = False
        Columns("H:IV").EntireColumn.Hidden = False
      End If
      
   End If
End Sub

 

[mikerickson]

Actuly, its pretty easy to hide unused columns.
If all your cells are in column H or leftward, select all of column I, press Shift+Cmd+Right (on a Mac) and then Format>Columns>Hide.

Similarly for rows.

I just wonder why bother even that much.