View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Dave Thomas Dave Thomas is offline
external usenet poster
 
Posts: 146
Default 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