Shorten the Excel Sheet

[Guest]

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

 

[Dave Thomas]

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".

 

[Guest]

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]

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

 

[Guest]

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]

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.

 

[Gord Dibben]

CTRL + a(twice in 2003) and Format>Row>Unhide


Gord Dibben MS Excel MVP

 

[Guest]

Thank you very much!

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.