Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Thread Tools Display Modes
Old 08-18-2017, 06:42 AM is offline Excell spreadsheet hidden rows Windows 7 64bit Excell spreadsheet hidden rows Office 2013
Excell spreadsheet hidden rows
Join Date: Aug 2017
Posts: 1 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
Old 08-18-2017, 02:36 PM
jeffreybrown jeffreybrown is online now Excell spreadsheet hidden rows Windows Vista Excell spreadsheet hidden rows Office 2007
Join Date: Apr 2016
Posts: 599
jeffreybrown will become famous soon enoughjeffreybrown will become famous soon enough

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

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. 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. is not affiliated with Microsoft