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

Hello !!

To unhide particular range of rows or column rather to unhide all rows/columns which are hidden in different places, select one rows/column before the hidden range and one row/column after hidden range and then press SHIFT + DOUBLE CLICK in between the selected rows/column. In this case the other hidden rows/column would remain hidden.

Might this help others.

Thanks.