#1   Report Post  
Old December 14th 04, 04:39 PM
 
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  
Old December 14th 04, 04:57 PM
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  
Old December 14th 04, 04:58 PM
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  
Old December 14th 04, 05:28 PM
 
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 06:00 PM
interchange columns with rows Herman Excel Discussion (Misc queries) 2 December 8th 04 05:40 PM
Why cannot I unhide the hidden rows ? Jim Edwards Excel Discussion (Misc queries) 2 December 4th 04 04:38 PM
How do I remove blank rows in Excel? m28leics Excel Discussion (Misc queries) 2 November 29th 04 11:56 PM
Filtering rows with tracked changes Kiwi Mike Excel Discussion (Misc queries) 0 November 27th 04 11:50 PM


All times are GMT +1. The time now is 09:05 AM.

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

About Us

"It's about Microsoft Excel"

 

Copyright © 2017