Windows 7 Forums

Welcome to Windows 7 Forums. Our forum is dedicated to helping you find support and solutions for any problems regarding your Windows 7 PC be it Dell, HP, Acer, Asus or a custom build. We also provide an extensive Windows 7 tutorial section that covers a wide range of tips and tricks.


Windows 7: extra large bottom row in excel 2010

12 Nov 2014   #1
phoenixmark

win7 professional 64 bit
 
 
extra large bottom row in excel 2010

I've noticed this on only one of my excel spreadsheets. Sometimes, not always, when I open this file, the bottom row on one of the pages takes up the whole monitor viewing area. If there is- for example- 400 lines of data, the next line down won't have a number on the left. If I highlight this overly tall line and delete it, line 401 is now below line 400. I can't seem to be able to duplicate it at will, it just is there when I open this file. Again, sometimes, but not always, maybe once every 5-6 times I open the file. Thanks.
Mark


My System SpecsSystem Spec
.
12 Nov 2014   #2
Ranger4

Windows 7 Home Premium 64 bit sp1
 
 

Can you scroll down to the bottom of this row & possibly drag up the bottom line so it's the same as the others.
Or you could right click on it & adjust the row height to the same as the others.

Make sure you save the spreadsheet after adjusting the row height.
My System SpecsSystem Spec
13 Nov 2014   #3
phoenixmark

win7 professional 64 bit
 
 

I'll try that the next time it happens. Thanks.
My System SpecsSystem Spec
.

07 Dec 2014   #4
phoenixmark

win7 professional 64 bit
 
 

I noticed it again today. The blank line fills up the whole monitor screen. I can see the top of the blank line, but when I scroll down the next line with datathis blank line is not shown. This blank line has no number assigned to it on the far left column. I never do see the bottom of the blank line. If I delete the blank line, the remaining lines with data move up. There are sometimmes more than one of these overly tall blank lines. I'll try to do a screen shot of what it looks like and see if I can post it here.
My System SpecsSystem Spec
07 Dec 2014   #5
Ranger4

Windows 7 Home Premium 64 bit sp1
 
 

This MS website might help you.

How to reset the last cell in Excel
My System SpecsSystem Spec
11 Dec 2014   #6
phoenixmark

win7 professional 64 bit
 
 

I tried what you suggested and so far all is well. Thanks for the help.

Mark
My System SpecsSystem Spec
11 Dec 2014   #7
Ranger4

Windows 7 Home Premium 64 bit sp1
 
 

Thanks for getting back, glad to be of some help.
My System SpecsSystem Spec
14 Dec 2014   #8
phoenixmark

win7 professional 64 bit
 
 

I noticed it again today. I've posted a screen shot. line 2630 is the last line that has data. The next numbered line is 2632. I added the 9,8,7,.... to see which line gets blank and it was line 2631. If I highlight the large blank line and delete it, the number 1 I put there is no longer there.


Attached Files
File Type: docx excel bottom row.docx (203.8 KB, 5 views)
My System SpecsSystem Spec
14 Dec 2014   #9
Ranger4

Windows 7 Home Premium 64 bit sp1
 
 

Have you tried repairing Office 2010. To do that, open Control Panel, select Programs & Features, scroll down to Microsoft Office 2010, Right Click on it & select Change, this should open a couple of repair options to try.

Did you try all the options in the MS website that I linked in post 5.
My System SpecsSystem Spec
20 Dec 2014   #10
phoenixmark

win7 professional 64 bit
 
 

Sorry for the long delay in replying. Method 1 is too confusing for me. I did Method 2 and it still, at times, shows the extra large last row.
My System SpecsSystem Spec
Reply

 extra large bottom row in excel 2010




Thread Tools Search this Thread
Search this Thread:

Advanced Search




Similar help and support threads
Thread Forum
Large & extra large icons blank
First post here on the SevenForums! I'm only saving the tough ones for you guys! Here's the problem: My client's computer was infected with a virus obtained via Facebook. I removed this and multiple other infections (and I'm pretty thorough with my scanning). She gets it back, starts working...
General Discussion
Some Extra Large Icons appear Extra Small
Hello all, I have been having a seriously frustrating time trying to fix icons displaying in my games folder way too small. Every icon is a custom x256 by x256 icon, and I have seen them all work properly at one point. However, for some reason these icons now appear in their 32x by 32x bit...
Customization
Bigger than 'Extra large Icons' ?
Hi there, I was just wondering is there anyway to edit the size of the icons more than the 'Extra large Icons' maybe a tool or some manual way ? Thanks.
Customization
Extra large icons & gadgets on start up.
Hi there, my problem is when I start up in the morning my icons and gadgets are extra large and I mean large, I solve this by right clicking on desktop, click screen resolution (which is also extra large) then click detect. This opens a normal size window and I am good to go. The display is set at...
Graphic Cards
Large, Extra Large Icons won't load
When viewing large and extra large photo previews, the jpeg thumbnails will not load. Is this a 64 bit issue? Any Ideas?
General Discussion
How to view EXTRA LARGE ICONS as default?
Hi guys! Every time:cry: I access a folder I have to go: VIEW- EXTRA LARGE ICONS to change how thumbnails are shown on windows explorer. How can I make VIEW as EXTRA LARGE ICONS a DEFAULT mode?? Many thanks!
Customization


Our Sites

Site Links

About Us

Find Us

Windows 7 Forums is an independent web site and has not been authorized, sponsored, or otherwise approved by Microsoft Corporation. "Windows 7" and related materials are trademarks of Microsoft Corp.

Designer Media Ltd

All times are GMT -5. The time now is 13:58.

Twitter Facebook Google+



Windows 7 Forums

Seven Forums Android App Seven Forums IOS App