Nope. There's no way to reduce the number of rows or columns in a worksheet.
You can hide them like the prodigal son Harald suggested or you could actually
use some code that won't let the user scroll too far right or too far down. But
that requires a macro.
If you want to try that:
Option Explicit
Sub auto_open()
With Worksheets("sheet1")
.ScrollArea = .Range("a1:f22").Address
End With
End Sub
Excel won't remember these settings after you close it and reopen the workbook
(that's why it's in auto_open).
If you're new to macros, you may want to read David McRitchie's intro at:
http://www.mvps.org/dmcritchie/excel/getstarted.htm
=====
Personally, seeing all those columns doesn't bother me. I don't think it
bothers most excel users either. And if you're new to excel, then give it some
time and it won't bother you either <bg>.
Ahmed SHEBL wrote:
>
> Hi Harald,
>
> as I said in my first posting, I had a colleague who did that before in a
> prior job. and I left that place and worked for another place. I am sure he
> did it.
>
> There must be another way to work around that Harald. do u think you can
> help me on that
>
> by the way, I can see you met an old friend of your through my post. you owe
> me one ;-)
>
> Many thanks,
> Ahmed
>
> "Harald Staff" <(E-Mail Removed)> wrote in message
> news:%(E-Mail Removed)...
> > Hi Ahmed
> >
> > The number of rows and columns are fixed. Your workaround would be to hide
> > the ones you consider unneeded.
> >
> > HTH. Best wishes Harald
> >
> > "Ahmed SHEBL" <(E-Mail Removed)> skrev i melding
> > news:%(E-Mail Removed)...
> >> Hi
> >>
> >> I had a collegue who told me once a way to dtermine the number of the
> >> rows
> >> in a sheet of the workbook I am working at.
> >> It is known that when you open a new workbook each sheet has maybe 65365
> > or
> >> something like that rows.
> >>
> >> MY QUESTION IS: HOW TO MAKE THE SHEET 1000 ROWS OR WHATEVER NUMBERS OF
> >> ROWS I ONLY NEED?
> >>
> >> Thanks in Advance,
> >>
> >> Ahmed
> >>
> >
> >
--
Dave Peterson
Similar Threads
