Shorten the Excel Sheet
 

Hello,

Previously I shortened an excel spreadsheet so that only rows 1-199 show,
everything below row 199 is grey.

When I go in now to add a column, the sheet freezes on me and I have to shut
it down.

Is the solution to open up the rows again to the end, for example row 66xxx?
If so, how do I do this?

Or is there a way to add a column without the sheet freezing up?

Tahnk you fo ryour help

Shorten the Excel Sheet
 

I have hidden rows 21 thru 65536 on my sheet. I can insert columns just
fine. I don't understand what you mean by "freezing up".

"nabanco" wrote in message
...
Hello,

Previously I shortened an excel spreadsheet so that only rows 1-199 show,
everything below row 199 is grey.

When I go in now to add a column, the sheet freezes on me and I have to
shut
it down.

Is the solution to open up the rows again to the end, for example row
66xxx?
If so, how do I do this?

Or is there a way to add a column without the sheet freezing up?

Tahnk you fo ryour help

Shorten the Excel Sheet
 

The hour glass comes up and will stay there until I task list out of excel.
I do have macros and tac coding in the sheet, do you think that woul dmess it
up?

"Dave Thomas" wrote:

I have hidden rows 21 thru 65536 on my sheet. I can insert columns just
fine. I don't understand what you mean by "freezing up".

"nabanco" wrote in message
...
Hello,

Previously I shortened an excel spreadsheet so that only rows 1-199 show,
everything below row 199 is grey.

When I go in now to add a column, the sheet freezes on me and I have to
shut
it down.

Is the solution to open up the rows again to the end, for example row
66xxx?
If so, how do I do this?

Or is there a way to add a column without the sheet freezing up?

Tahnk you fo ryour help

Shorten the Excel Sheet
 

If your macro code is being executed for some reason. I don't know what you
mean by tac coding.

"nabanco" wrote in message
...
The hour glass comes up and will stay there until I task list out of
excel.
I do have macros and tac coding in the sheet, do you think that woul dmess
it
up?

"Dave Thomas" wrote:

I have hidden rows 21 thru 65536 on my sheet. I can insert columns just
fine. I don't understand what you mean by "freezing up".

"nabanco" wrote in message
...
Hello,

Previously I shortened an excel spreadsheet so that only rows 1-199
show,
everything below row 199 is grey.

When I go in now to add a column, the sheet freezes on me and I have to
shut
it down.

Is the solution to open up the rows again to the end, for example row
66xxx?
If so, how do I do this?

Or is there a way to add a column without the sheet freezing up?

Tahnk you fo ryour help

Shorten the Excel Sheet
 

Is there a way to "re=expand" the excel sheet to 65536? Currently it ends at
199. If I could do that, i think that will solve the problem

"Dave Thomas" wrote:

If your macro code is being executed for some reason. I don't know what you
mean by tac coding.

"nabanco" wrote in message
...
The hour glass comes up and will stay there until I task list out of
excel.
I do have macros and tac coding in the sheet, do you think that woul dmess
it
up?

"Dave Thomas" wrote:

I have hidden rows 21 thru 65536 on my sheet. I can insert columns just
fine. I don't understand what you mean by "freezing up".

"nabanco" wrote in message
...
Hello,

Previously I shortened an excel spreadsheet so that only rows 1-199
show,
everything below row 199 is grey.

When I go in now to add a column, the sheet freezes on me and I have to
shut
it down.

Is the solution to open up the rows again to the end, for example row
66xxx?
If so, how do I do this?

Or is there a way to add a column without the sheet freezing up?

Tahnk you fo ryour help

Shorten the Excel Sheet
 

Excel 2003: Select the last visible row and move down. You should see 65338R
which is 65536-199 appear in a box in column A. On the Format menu, select
Row then unhide

Excel 2007 Home tab. Cells section. Click Format. Click Hide & Unhide Click
Unhide Rows.

"nabanco" wrote in message
...
Is there a way to "re=expand" the excel sheet to 65536? Currently it ends
at
199. If I could do that, i think that will solve the problem

"Dave Thomas" wrote:

If your macro code is being executed for some reason. I don't know what
you
mean by tac coding.

"nabanco" wrote in message
...
The hour glass comes up and will stay there until I task list out of
excel.
I do have macros and tac coding in the sheet, do you think that woul
dmess
it
up?

"Dave Thomas" wrote:

I have hidden rows 21 thru 65536 on my sheet. I can insert columns
just
fine. I don't understand what you mean by "freezing up".

"nabanco" wrote in message
...
Hello,

Previously I shortened an excel spreadsheet so that only rows 1-199
show,
everything below row 199 is grey.

When I go in now to add a column, the sheet freezes on me and I have
to
shut
it down.

Is the solution to open up the rows again to the end, for example
row
66xxx?
If so, how do I do this?

Or is there a way to add a column without the sheet freezing up?

Tahnk you fo ryour help

Shorten the Excel Sheet
 

CTRL + a(twice in 2003) and FormatRowUnhide


Gord Dibben MS Excel MVP



On Wed, 18 Jul 2007 12:44:02 -0700, nabanco
wrote:

Is there a way to "re=expand" the excel sheet to 65536? Currently it ends at
199. If I could do that, i think that will solve the problem

"Dave Thomas" wrote:

If your macro code is being executed for some reason. I don't know what you
mean by tac coding.

"nabanco" wrote in message
...
The hour glass comes up and will stay there until I task list out of
excel.
I do have macros and tac coding in the sheet, do you think that woul dmess
it
up?

"Dave Thomas" wrote:

I have hidden rows 21 thru 65536 on my sheet. I can insert columns just
fine. I don't understand what you mean by "freezing up".

"nabanco" wrote in message
...
Hello,

Previously I shortened an excel spreadsheet so that only rows 1-199
show,
everything below row 199 is grey.

When I go in now to add a column, the sheet freezes on me and I have to
shut
it down.

Is the solution to open up the rows again to the end, for example row
66xxx?
If so, how do I do this?

Or is there a way to add a column without the sheet freezing up?

Tahnk you fo ryour help

Shorten the Excel Sheet
 

Thank you very much!

"Dave Thomas" wrote:

Excel 2003: Select the last visible row and move down. You should see 65338R
which is 65536-199 appear in a box in column A. On the Format menu, select
Row then unhide

Excel 2007 Home tab. Cells section. Click Format. Click Hide & Unhide Click
Unhide Rows.

"nabanco" wrote in message
...
Is there a way to "re=expand" the excel sheet to 65536? Currently it ends
at
199. If I could do that, i think that will solve the problem

"Dave Thomas" wrote:

If your macro code is being executed for some reason. I don't know what
you
mean by tac coding.

"nabanco" wrote in message
...
The hour glass comes up and will stay there until I task list out of
excel.
I do have macros and tac coding in the sheet, do you think that woul
dmess
it
up?

"Dave Thomas" wrote:

I have hidden rows 21 thru 65536 on my sheet. I can insert columns
just
fine. I don't understand what you mean by "freezing up".

"nabanco" wrote in message
...
Hello,

Previously I shortened an excel spreadsheet so that only rows 1-199
show,
everything below row 199 is grey.

When I go in now to add a column, the sheet freezes on me and I have
to
shut
it down.

Is the solution to open up the rows again to the end, for example
row
66xxx?
If so, how do I do this?

Or is there a way to add a column without the sheet freezing up?

Tahnk you fo ryour help