View Single Post
 
Old 03-10-2016, 09:07 AM
kellytag kellytag is offline Windows 10 Office 2013
Novice
 
Join Date: Mar 2016
Location: Padre Island TX
Posts: 2
kellytag is on a distinguished road
Question Opening Rows that have been Closed

I have inherited a number of spreadsheets where the previous user closed rows by dragging the mouse up the table and collapsing them. I have found no way to open them except by looking for each line and opening them individually. This has become painful with 600+ row sheets where I have to scroll down and look for groups (and sometimes a single one) of rows to open...one row at a time.

Is there a shortcut or command to make these open? The hide/unhide option is not working in this instance.
Reply With Quote