| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Unhiding Rows
I have accidently hidden rows 1 through to 20 on my spreadsheet and saved the
file. When I opened it I found that I couldn't unhide them by right clicking and selecting 'unhide' as this option wasn't available to me. Can anyone help? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Unhiding Rows
Go to the center of the top of row 21 at the corner of top row and column A or whatever column is visible. Move your mouse slowly in that area and it should change from a large "PLUS" to something like the following = when you see that, hold the left mouse button down and drag down and it should resize those rows for you. -- wjohnson ------------------------------------------------------------------------ wjohnson's Profile: http://www.excelforum.com/member.php...o&userid=29640 View this thread: http://www.excelforum.com/showthread...hreadid=497317 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Unhiding Rows
How do I unhide rows 1 through to 20 though?
"wjohnson" wrote: Go to the center of the top of row 21 at the corner of top row and column A or whatever column is visible. Move your mouse slowly in that area and it should change from a large "PLUS" to something like the following = when you see that, hold the left mouse button down and drag down and it should resize those rows for you. -- wjohnson ------------------------------------------------------------------------ wjohnson's Profile: http://www.excelforum.com/member.php...o&userid=29640 View this thread: http://www.excelforum.com/showthread...hreadid=497317 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Unhiding Rows
Hi
Press CTRL+A to select the whole sheet FormatRowsUnhide -- Regards Roger Govier Struggling of Essex wrote: How do I unhide rows 1 through to 20 though? "wjohnson" wrote: Go to the center of the top of row 21 at the corner of top row and column A or whatever column is visible. Move your mouse slowly in that area and it should change from a large "PLUS" to something like the following = when you see that, hold the left mouse button down and drag down and it should resize those rows for you. -- wjohnson ------------------------------------------------------------------------ wjohnson's Profile: http://www.excelforum.com/member.php...o&userid=29640 View this thread: http://www.excelforum.com/showthread...hreadid=497317 |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Unhiding Rows
Many thanks
"Roger Govier" wrote: Hi Press CTRL+A to select the whole sheet FormatRowsUnhide -- Regards Roger Govier Struggling of Essex wrote: How do I unhide rows 1 through to 20 though? "wjohnson" wrote: Go to the center of the top of row 21 at the corner of top row and column A or whatever column is visible. Move your mouse slowly in that area and it should change from a large "PLUS" to something like the following = when you see that, hold the left mouse button down and drag down and it should resize those rows for you. -- wjohnson ------------------------------------------------------------------------ wjohnson's Profile: http://www.excelforum.com/member.php...o&userid=29640 View this thread: http://www.excelforum.com/showthread...hreadid=497317 |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Unhiding Rows
Another way:
Edit|goto type in A1:A20 format|row|Unhide Struggling of Essex wrote: I have accidently hidden rows 1 through to 20 on my spreadsheet and saved the file. When I opened it I found that I couldn't unhide them by right clicking and selecting 'unhide' as this option wasn't available to me. Can anyone help? -- Dave Peterson |
|
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Unhiding Rows
Hi,
None of these suggestions seems to work on Excel 2008 for Mac. Any clues? Thanks, Stefano "Dave Peterson" wrote: Another way: Edit|goto type in A1:A20 format|row|Unhide Struggling of Essex wrote: I have accidently hidden rows 1 through to 20 on my spreadsheet and saved the file. When I opened it I found that I couldn't unhide them by right clicking and selecting 'unhide' as this option wasn't available to me. Can anyone help? -- Dave Peterson |
|
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Unhiding Rows
Check to see if you can use Window|Unfreeze panes.
Then scroll to the left if that doesn't work, then try the edit|goto stuff If that doesn't work, then you may want to post in news://msnews.microsoft.com/microsof...c.office.excel smaruzzi wrote: Hi, None of these suggestions seems to work on Excel 2008 for Mac. Any clues? Thanks, Stefano "Dave Peterson" wrote: Another way: Edit|goto type in A1:A20 format|row|Unhide Struggling of Essex wrote: I have accidently hidden rows 1 through to 20 on my spreadsheet and saved the file. When I opened it I found that I couldn't unhide them by right clicking and selecting 'unhide' as this option wasn't available to me. Can anyone help? -- Dave Peterson -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| hidden rows keep unhiding themselves! | Excel Discussion (Misc queries) | |||
| Unhiding Protected Rows and Columns? is it possible? | Excel Discussion (Misc queries) | |||
| Unhiding multiple rows simutaneously | Excel Worksheet Functions | |||
| unhiding rows automatically | Excel Worksheet Functions | |||
| Unhiding rows using data validation | Excel Worksheet Functions | |||
Hybrid Mode
