View Single Post
  #27   Report Post  
Old February 20th 16, 10:52 AM posted to microsoft.public.excel.misc
[email protected] deepakfaasos@gmail.com is offline
external usenet poster
 
First recorded activity by ExcelBanter: Feb 2016
Posts: 1
Default how to unhide multiple rows in one go?

On Wednesday, December 26, 2007 at 6:24:00 PM 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 individ


Hi Madarchodo,

Select all row and column, then click on home button, Find & click Format button, Under Visibilities Select Unhide Row.

But remember all filter should on excel sheet must has removed, other wise it will not work.

Regar: Deepak Nariyal