 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / New Users / November 2006Hide/unhide
Hi, How does hide/hide work in Excell for e.g. rows ? When I hide some rows, how can I see where in my sheet hidden rows are ? Is here a marker indicating hidden rows ? And can I also unhide row per row, or does "unhide" work for the entire sheet ? Some help would be nice. Thxs. The rows are identifiable by looking at the row numbers along the left, and see which if any are missing. You can hide a single row, select the row and goto Format>Row>hide. HTH Bob > Hi, > [quoted text clipped - 9 lines] > > Thxs. In addition, if you have several rows hidden and wish to unhide just one of these.............. Say rows 4 through 12 are hidden. Type a cell address like A9 in the namebox and hit ENTER then Format>Row>Unhide. Only that row will be unhidden. Gord Dibben MS Excel MVP >The rows are identifiable by looking at the row numbers along the left, and >see which if any are missing. [quoted text clipped - 18 lines] >> >> Thxs. I didn't know that. It is useful, thanks Gord. Bob > In addition, if you have several rows hidden and wish to unhide just one > of [quoted text clipped - 32 lines] >>> >>> Thxs. You're welcome. Gord >I didn't know that. It is useful, thanks Gord. > [quoted text clipped - 36 lines] >>>> >>>> Thxs. Gord Dibben MS Excel MVP
|
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.