select the entire row 156
shift end down to highlight the rest of the sheet
hit Ctrl 9 (hides rows)
select column AB
shift end right to highlight the rest of the sheet
and press Ctrl 0 ( hides columns)

to unhide rows highlight the entire sheet (by clicking on the top left
corner)and press
Ctrl shift 9

column
Ctrl shift 0


--
davesexcel


------------------------------------------------------------------------
davesexcel's Profile: http://www.excelforum.com/member.php...o&userid=31708
View this thread: http://www.excelforum.com/showthread...hreadid=564601