Excel Help (1 Viewer)

[chet]

Somehow I've managed to hide a bunch of rows in a spreadsheet.  I right clicked and hit Unhide but it didn't reveal the data.  

Does anyone know how to reveal the rows? I can post a pic if that would help.

 

[Mr. Ected]

Are they just narrowed?

Can you highlight the area rows, going above and below, then right click and do 'row height'? After that pick something like 1 (that's in inches) and it will hopefully give you the set of rows, you will just need to readjust them.

Try that and give us feedback!

 

[chet]

Are they just narrowed?

Can you highlight the area rows, going above and below, then right click and do 'row height'? After that pick something like 1 (that's in inches) and it will hopefully give you the set of rows, you will just need to readjust them.

Try that and give us feedback!

I tried that but it didn't work.  Thx for the try.

 

[Nathan R. Jessep]

Hit the blank square top left corner to highlight everything, then right-click anywhere and hit Unhide. That will usually do the trick, unless you pulled off some real wizardry. 

 

[chet]

Hit the blank square top left corner to highlight everything, then right-click anywhere and hit Unhide. That will usually do the trick, unless you pulled off some real wizardry. 

I tried that.  No work.

 

[Nathan R. Jessep]

I tried that.  No work.

have you tried restarting?   

Let's see a pic. Are the row numbers skipped? Bc if that "unhide all" trick doesn't work, that usually means they weren't "hidden" and something else is going on. 

 

[Nathan R. Jessep]

Buy Microsoft.

all his rows are belong to them

 

[rodg12]

Yeah, gonna need a pic here if those two solutions didn't work.

 

[fantasycurse42]

Make sure you keep the IP hidden.

 

[chet]

Here's a pic

It's my fantasy hockey draft sheet from last year so I know I had access to those rows at one point.

Thx

 

[rodg12]

Here's a pic

It's my fantasy hockey draft sheet from last year so I know I had access to those rows at one point.

Thx

Could there be a filter that's stopping them from displaying?

I would lean that way since the numbers are showing up blue.

 

[EYLive]

Did you freeze the panes/rows?

 

[rodg12]

Here's a pic

It's my fantasy hockey draft sheet from last year so I know I had access to those rows at one point.

Thx

Going to Data and Clicking 'Clear' right next to the big Filter button will remove all filters if you don't want to find the individual one turned on and just wanna see everything.

 

[gianmarco]

Did you move the rows to an offshore account for tax purposes?

 

[Nathan R. Jessep]

Could there be a filter that's stopping them from displaying?

I would lean that way since the numbers are showing up blue.

Yep. Clear filters and that'll do it. The arrows at the top of each column tells you filters are enabled. 

 

[Psychopav]

Maybe you didn't hide them.  Maybe you resized them and just can't see 'em.

Try highlighting from the row just above to the row just below and double clicking on the bottom line under the last highlighted row number to autosize all of them, or clicking on any individual row line and dragging it down to size them all bigger.

Sorry, I'm at work and can't see your pic so maybe this is not your problem.  But figured I'd throw it out there just in case.

 

[chet]

Clearing the filters worked.  Thanks!!!

 

[AAABatteries]

Seriously?  How he hell did you get rich?

 

[chet]

Seriously?  How he hell did you get rich?

By having other people do my spreadsheets.

 

[Ned]

Seriously?  How he hell did you get rich?