Shorten the Excel Sheet

N

nabanco

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
 
D

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

nabanco

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?
 
D

Dave Thomas

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

nabanco

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
 
D

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

nabanco

Thank you very much!

Dave Thomas said:
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.
Click to expand...
 
Top