Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 08-18-2017, 06:42 AM
alanadams611@gmail.com alanadams611@gmail.com is offline Excell spreadsheet hidden rows Windows 7 64bit Excell spreadsheet hidden rows Office 2013
Novice
Excell spreadsheet hidden rows
 
Join Date: Aug 2017
Posts: 1
alanadams611@gmail.com is on a distinguished road
Default Excell spreadsheet hidden rows

I use a large spreadsheet about 45 columns and 300 rows. Something is causing the row heights of blocks of rows to be set at zero, which basically hides the rows. The only way you know they are there is the small double line in the row number column. I have tried to "unhide the rows, have tried to highlight the row above and the row below and set the row height to a larger number - nothing works. The only way I have found to fix the problem is position the cursor on the bottom double line and pull the row down larger. This works but is time consuming if 100-200 rows are hidden. I have fixed it several times, and later when I open the workbook, it has happened again.
Reply With Quote
  #2  
Old 08-18-2017, 02:36 PM
jeffreybrown jeffreybrown is online now Excell spreadsheet hidden rows Windows Vista Excell spreadsheet hidden rows Office 2007
Expert
 
Join Date: Apr 2016
Posts: 599
jeffreybrown will become famous soon enoughjeffreybrown will become famous soon enough
Default

First, I would look to see if there is any code in the workbook.

If you don't know anything about VBA, take a look at this link

Second, you can select Ctrl + A which will select the entire spreadsheet, then right click on the row headings and select row height. Add in a row height such as 15 and select OK.

Third, copy and paste all of your data to a new spreadsheet as text a format as needed. Maybe the spreadsheet is corrupted in some way.

Without us seeing the offending worksheet, it's hard to know exactly what to advise as I can duplicate the problem.

Hope this helps...
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excell spreadsheet hidden rows AVERAGEIF function excluding hidden rows michael_1962 Excel 1 05-17-2015 11:31 PM
Excell spreadsheet hidden rows VBA to keep hidden rows hidden when filtering tectonicseer Excel Programming 1 07-27-2014 11:54 AM
Excell spreadsheet hidden rows how to view hidden rows gsrikanth Excel 10 01-27-2012 05:29 AM
Excell spreadsheet hidden rows hidden rows gsrikanth Excel 5 01-19-2012 02:40 PM
CAUTION!! Sorting a spreadsheet with hidden columns will trash your data. psmaster@earthlink.net Excel 0 11-24-2009 11:54 AM


All times are GMT -7. The time now is 07:23 AM.


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