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
|