Thread: Hidden rows
View Single Post
  #2   Report Post  
Peo Sjoblom
 
Posts: n/a
Default Hidden rows

What happens if go to a hidden cell, let's say A300, then do
formatrowheight and then put 15 and press enter?
If that works type 219:400 in the name box (box above column A where you
can see the cell address of the active cell) and press enter, now change the
row height for all the rows

--
Regards,

Peo Sjoblom

(No private emails please)


"rdrunner" wrote in
message ...

I have inherited a worksheet that has formula references to rows that I
can not get to display. I have unprotected the worksheet, selected the
entire worksheet and unhide rows and columns and reformatted the rows to
15 point height and I still can not display the the rows which seem to
be hidden. If I us the go to specific cell the curser goes to a point
on the page btween the row 219 and row 400 but I can not see he rows.
Any Ideas how to view them and how was this done in the first place??


--
rdrunner
------------------------------------------------------------------------
rdrunner's Profile:
http://www.excelforum.com/member.php...o&userid=28313
View this thread: http://www.excelforum.com/showthread...hreadid=478989