Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 12-13-2018, 10:47 AM
DMU62 DMU62 is offline Rows hidden! Mac OS X Rows hidden! Office for Mac 2011
Novice
Rows hidden!
 
Join Date: Oct 2016
Location: PA
Posts: 17
DMU62 is on a distinguished road
Default Rows hidden!

I use Microsoft Excel very little. I work for a small business and we keep a basic list of customers.


One day I opened my Excel sheet and rows were missing! I don't know HOW they became hidden and the "unhide" is not working. I did some googling and found out how to drag down the rows to show what's hidden but this is tedious!
Why did this happen? Why isn't "unhide" working for me?
Reply With Quote
  #2  
Old 12-13-2018, 11:35 AM
ArviLaanemets ArviLaanemets is offline Rows hidden! Windows 8 Rows hidden! Office 2016
Expert
 
Join Date: May 2017
Posts: 869
ArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud of
Question

Quote:
Originally Posted by DMU62 View Post
...found out how to drag down the rows...
What do you mean with this


A blind shot - check the state of Freeze Panes for sheet!
Reply With Quote
  #3  
Old 12-13-2018, 11:41 AM
DMU62 DMU62 is offline Rows hidden! Mac OS X Rows hidden! Office for Mac 2011
Novice
Rows hidden!
 
Join Date: Oct 2016
Location: PA
Posts: 17
DMU62 is on a distinguished road
Default

I found in a google search that if you hover your pointer over the lines between the numbers until you see a double line, then you can pull down and see a hidden row. Only one row at a time though. I would have hundreds if I did it that way.

I don't know what you mean buy checking the state of freeze panes. How do I do that?

The numbers down the left side are blue. I don't know why or how?
Reply With Quote
  #4  
Old 12-13-2018, 03:06 PM
ArviLaanemets ArviLaanemets is offline Rows hidden! Windows 8 Rows hidden! Office 2016
Expert
 
Join Date: May 2017
Posts: 869
ArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud of
Default

Quote:
Originally Posted by DMU62 View Post
The numbers down the left side are blue. I don't know why or how?
Usually this means, you have set autofilter to some column.
Reply With Quote
  #5  
Old 12-14-2018, 12:31 AM
Pecoflyer's Avatar
Pecoflyer Pecoflyer is offline Rows hidden! Windows 7 64bit Rows hidden! Office 2010 64bit
Expert
 
Join Date: Nov 2011
Location: Brussels Belgium
Posts: 2,766
Pecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant future
Default

If memory serves, click Ctrl+A then apply the technique you described in post #3
All done in one go
__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post
Reply With Quote
  #6  
Old 12-14-2018, 07:43 AM
DMU62 DMU62 is offline Rows hidden! Mac OS X Rows hidden! Office for Mac 2011
Novice
Rows hidden!
 
Join Date: Oct 2016
Location: PA
Posts: 17
DMU62 is on a distinguished road
Default

Thank you all for your quick replies!

I tried everything, and the only thing I was successful at was (from my google search) pulling each line down manually.
I saved the file that way and it's fine, however, those numbers on the left are still blue. I checked and there is no filter set. I also noticed that in the similar files from previous years the same thing had happened, as if all similar files were affected all at once.
Today they are fine. I have no idea why.

Could macros have something to do with it? We have received files from other companies and as I open the file I'm asked if I want to enable macros. I might have done that! Could that have been the cause?
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excell spreadsheet hidden rows alanadams611@gmail.com Excel 1 08-18-2017 02:36 PM
MODE function excluding hidden rows michael_1962 Excel 1 05-21-2015 10:09 PM
Rows hidden! VBA to keep hidden rows hidden when filtering tectonicseer Excel Programming 1 07-27-2014 11:54 AM
Rows hidden! how to view hidden rows gsrikanth Excel 10 01-27-2012 05:29 AM
Rows hidden! hidden rows gsrikanth Excel 5 01-19-2012 02:40 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 02:33 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft