#1   Report Post  
 
Posts: n/a
Default Unhide rows

I have a spreadsheet that has 100 columns of data.
Unfortunetely rows 21 - 60 are hidden. The spreadsheet is
unprotected and I have tried to unhide these rows without
success. The only way to unhide it is to physically drag
one row at a time. I also noted that the numbers listing
rows 1 -20 (number of the row on the left side) are purple
color, where as rows 21+ are normal black color.

thanks

Comic_fly
  #2   Report Post  
Peo Sjoblom
 
Posts: n/a
Default

Sounds like there is a filter on, do datafiltershow all


Regards,

Peo Sjoblom


" wrote:

I have a spreadsheet that has 100 columns of data.
Unfortunetely rows 21 - 60 are hidden. The spreadsheet is
unprotected and I have tried to unhide these rows without
success. The only way to unhide it is to physically drag
one row at a time. I also noted that the numbers listing
rows 1 -20 (number of the row on the left side) are purple
color, where as rows 21+ are normal black color.

thanks

Comic_fly

  #3   Report Post  
Ron de Bruin
 
Posts: n/a
Default

Hi

Try DataFilter
Show all

--
Regards Ron de Bruin
http://www.rondebruin.nl


" wrote in message ...
I have a spreadsheet that has 100 columns of data.
Unfortunetely rows 21 - 60 are hidden. The spreadsheet is
unprotected and I have tried to unhide these rows without
success. The only way to unhide it is to physically drag
one row at a time. I also noted that the numbers listing
rows 1 -20 (number of the row on the left side) are purple
color, where as rows 21+ are normal black color.

thanks

Comic_fly



  #4   Report Post  
 
Posts: n/a
Default

Thanks. It worked
-----Original Message-----
Hi

Try DataFilter
Show all

--
Regards Ron de Bruin
http://www.rondebruin.nl


"

wrote in message
...
I have a spreadsheet that has 100 columns of data.
Unfortunetely rows 21 - 60 are hidden. The spreadsheet

is
unprotected and I have tried to unhide these rows

without
success. The only way to unhide it is to physically

drag
one row at a time. I also noted that the numbers

listing
rows 1 -20 (number of the row on the left side) are

purple
color, where as rows 21+ are normal black color.

thanks

Comic_fly



.

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
Multiple rows of data on a single axis (charting) ramseysgirl Charts and Charting in Excel 8 December 29th 04 07:00 PM
interchange columns with rows Herman Excel Discussion (Misc queries) 2 December 8th 04 06:40 PM
Why cannot I unhide the hidden rows ? Jim Edwards Excel Discussion (Misc queries) 2 December 4th 04 05:38 PM
How do I remove blank rows in Excel? m28leics Excel Discussion (Misc queries) 2 November 30th 04 12:56 AM
Filtering rows with tracked changes Kiwi Mike Excel Discussion (Misc queries) 0 November 28th 04 12:50 AM


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

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

About Us

"It's about Microsoft Excel"