Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 144
Default I am unable to unhide certain rows in my worksheet-it is locked?

Can you tell me how to unlock the rows?

Thanks!!!!
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 1
Default I am unable to unhide certain rows in my worksheet-it is locked?


Is the menu greyed out ??

If it is then unprotect the sheet otherwise just select all then Format
Columns unhide


VBA Noob


--
VBA Noob
------------------------------------------------------------------------
VBA Noob's Profile: http://www.excelforum.com/member.php...o&userid=33833
View this thread: http://www.excelforum.com/showthread...hreadid=566766

  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 1,047
Default I am unable to unhide certain rows in my worksheet-it is locked?

Hi Cheryl, did your sheet protected?

hth
regards from Brazil
Marcelo

"Cheryl" escreveu:

Can you tell me how to unlock the rows?

Thanks!!!!

  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 144
Default I am unable to unhide certain rows in my worksheet-it is locke

No, it is not protected. I am not able to scroll up the side bar either.

"Marcelo" wrote:

Hi Cheryl, did your sheet protected?

hth
regards from Brazil
Marcelo

"Cheryl" escreveu:

Can you tell me how to unlock the rows?

Thanks!!!!

  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 144
Default I am unable to unhide certain rows in my worksheet-it is locke

No, the menu is not greyed out and it is not protected either. I am unable
to move the side scroll bar either.

"VBA Noob" wrote:


Is the menu greyed out ??

If it is then unprotect the sheet otherwise just select all then Format
Columns unhide


VBA Noob


--
VBA Noob
------------------------------------------------------------------------
VBA Noob's Profile: http://www.excelforum.com/member.php...o&userid=33833
View this thread: http://www.excelforum.com/showthread...hreadid=566766




  #6   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 644
Default I am unable to unhide certain rows in my worksheet-it is locke

is the Freeze Pane option on? (Windows... Freeze Panes)
Die_Another_Day
Cheryl wrote:
No, the menu is not greyed out and it is not protected either. I am unable
to move the side scroll bar either.

"VBA Noob" wrote:


Is the menu greyed out ??

If it is then unprotect the sheet otherwise just select all then Format
Columns unhide


VBA Noob


--
VBA Noob
------------------------------------------------------------------------
VBA Noob's Profile: http://www.excelforum.com/member.php...o&userid=33833
View this thread: http://www.excelforum.com/showthread...hreadid=566766



  #7   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 1
Default I am unable to unhide certain rows in my worksheet-it is locked?


Is freeze pane on

Try Window unfreeze pane

VBA Noob


--
VBA Noob
------------------------------------------------------------------------
VBA Noob's Profile: http://www.excelforum.com/member.php...o&userid=33833
View this thread: http://www.excelforum.com/showthread...hreadid=566766

  #8   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 144
Default I am unable to unhide certain rows in my worksheet-it is locke

Bingo, it worked!!!!! Thanks a millions to you!!!

"Die_Another_Day" wrote:

is the Freeze Pane option on? (Windows... Freeze Panes)
Die_Another_Day
Cheryl wrote:
No, the menu is not greyed out and it is not protected either. I am unable
to move the side scroll bar either.

"VBA Noob" wrote:


Is the menu greyed out ??

If it is then unprotect the sheet otherwise just select all then Format
Columns unhide

VBA Noob


--
VBA Noob
------------------------------------------------------------------------
VBA Noob's Profile: http://www.excelforum.com/member.php...o&userid=33833
View this thread: http://www.excelforum.com/showthread...hreadid=566766




  #9   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 144
Default I am unable to unhide certain rows in my worksheet-it is locke

Yes, the Freeze pane was on, and now it works!!!! Thanks a million! I
appreciate it!!!!

"VBA Noob" wrote:


Is freeze pane on

Try Window unfreeze pane

VBA Noob


--
VBA Noob
------------------------------------------------------------------------
VBA Noob's Profile: http://www.excelforum.com/member.php...o&userid=33833
View this thread: http://www.excelforum.com/showthread...hreadid=566766


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
how do i unhide a worksheet in excel 2003? unhide tab don't work mikekeat Excel Discussion (Misc queries) 2 March 6th 06 03:36 AM
New rows at the end of a worksheet don't sort with the worksheet John Bloor Excel Worksheet Functions 1 February 21st 06 07:03 PM
rows 1-2 missing from excel worksheet Perplexed Excel Worksheet Functions 1 October 29th 05 03:09 AM
copy rows meeting criteria to another worksheet confused Excel Worksheet Functions 4 October 4th 05 11:51 AM
Can't Unhide Rows in 'batches'! raehippychick Excel Discussion (Misc queries) 3 July 20th 05 02:26 PM


All times are GMT +1. The time now is 05:42 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"