rows and cells

Is there a way of manually telling excel how many rows and columns you wish to have?


Thanks

Ed

By only putting data in the cells you need you are effectively doing that.
When you print it only prints active cells. If you can clarify what you want
to do I may be able to help but you can't change the default size of a
workbook to the best of my knowledge


"changetires" wrote:

>
> Is there a way of manually telling excel how many rows and columns you
> wish to have?
>
>
> Thanks
>
> Ed
>
>
> --
> changetires
> ------------------------------------------------------------------------
> changetires's Profile: http://www.excelforum.com/member.php...o&userid=35414
> View this thread: http://www.excelforum.com/showthread...hreadid=556461
>
>

You cannot change the number of rows and columns.

You can hide the ones you don't want to see.

You can also, using VBA, set the scroll range to a fixed range.

Users will not be able to scroll out of that range.

Note: Setting ScrollArea is good for that session only and only the
activesheet. Has to be reset next time workbook is opened.

Best to place the code into a WorkBook_Open Sub in ThisWorkbook module and
specify which worksheet.

Private Sub WorkBook_Open()
Sheets("YourSheet").ScrollArea = "A1:P60"
End Sub


Gord Dibben MS Excel MVP

On Wed, 28 Jun 2006 08:36:32 -0500, changetires
<changetires.2a470n_1151502002.1872@excelforum-nospam.com> wrote:

>
>Is there a way of manually telling excel how many rows and columns you
>wish to have?
>
>
>Thanks
>
>Ed