View Single Post
  #8   Report Post  
Posted to microsoft.public.excel.misc
[email protected] mymail.mba@gmail.com is offline
external usenet poster
 
Posts: 1
Default how to unhide multiple rows in one go?

On Wednesday, 26 December 2007 18:24:00 UTC+5:30, Satnam Randhawa wrote:
I have a worksheet with close to 100 rows out which 15-20 are hidden. How do
I unhide all the rows in one work sheet in one go without having to drag them
out individually?


Select the rows you want to unhide and press Ctrl+shift+0
hie and press Ctrl+0.