View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
Tense Tom Tense Tom is offline
external usenet poster
 
Posts: 1
Default How do I display limited columns in excel?

I figured it out.

Select the row or column after the last one that you want displayed. Then
hold Shift+Ctrl+ the down or right arrow key depending upon whether you have
columns or row selcted. Then hide them.

"Tense Tom" wrote:

I am trying to make a form and I can't figure out how to display a limited
number of rows or colums. For example I only want there to be 30 rows
instead of the infinite number by default. I have a file that is like this
so I know it can be done, I just don't know how to get there.