Reduce columns and rows count?

Hello everyone,

Excel sheet has 256 columns and 65536 rows as default. Can I reduce their
count without hiding them? I want to clear unnecessary columns and rows
permanently.

How can i do it?

thanks.

Hi

AFAIK no, only by hiding them

Cheers
JulieD

"murat" <murat@discussions.microsoft.com> wrote in message
news:2748FFB8-A8D0-449C-8360-67EDA8E49EE9@microsoft.com...
> Hello everyone,
>
> Excel sheet has 256 columns and 65536 rows as default. Can I reduce their
> count without hiding them? I want to clear unnecessary columns and rows
> permanently.
>
> How can i do it?
>
> thanks.

murat

Cannot be done.

Hiding the unused rows and columns then protecting the sheet is the usual
method.

Setting the scrollarea using VBA is another method.

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:M36"
End Sub


Gord Dibben Excel MVP

On Wed, 16 Mar 2005 07:13:02 -0800, "murat" <murat@discussions.microsoft.com>
wrote:

>Hello everyone,
>
>Excel sheet has 256 columns and 65536 rows as default. Can I reduce their
>count without hiding them? I want to clear unnecessary columns and rows
>permanently.
>
>How can i do it?
>
>thanks.

I'm grateful for your interest.
Thanks a lot!