An open community 
of Macintosh users,
for Macintosh users.

FineTunedMac Dashboard widget now available! Download Here

Previous Thread
Next Thread
Print Thread
Resizing Excel spreadsheet
#57947 02/16/21 11:24 PM
Joined: Aug 2009
Likes: 5
ryck Online OP
OP Online

Joined: Aug 2009
Likes: 5
Upon re-opening an Excel spreadsheet (Office 2011 V 14.7.7), the document has expanded past the bottom of the screen and I cannot access the bottom part of the sheet. i.e. totally unable to navigate to different sheets in the document. I've looked around and haven't found a solution that works. Any thoughts?


ryck

iMac (Retina 5K, 27", 2017), 3.4 GHz Intel Core i5, 8GB RAM, 2400 MHz DDR4
OS Mojave 10.14.6
Canon Pixma TR 8520 Printer
Epson Perfection V500 Photo Scanner
Time Machine on 1TB LaCie USB-C
Carbon Copy Clone on 500GB OWC Mercury OTG Pro
Re: Resizing Excel spreadsheet
ryck #57949 02/16/21 11:45 PM
Joined: Aug 2009
Likes: 4
Moderator
Offline
Moderator

Joined: Aug 2009
Likes: 4
Try toggling through Full Screen and back to see if that restores your ability to navigate to the bottom of the spreadsheet.....


Freedom is never free....thank a Service member today.
Re: Resizing Excel spreadsheet
ryck #57950 02/16/21 11:58 PM
Joined: Aug 2009
Likes: 6
Moderator
Online
Moderator

Joined: Aug 2009
Likes: 6
My experience with Excel is woefully out of date, but as I recall from my days in Microsoft Tech Support my first thought would be there has been a change in the typeface or point size that is creating the problem. Even the same typeface and size from a different font factory could do it. Has anything that might effect the font changed on your system changed since the last time you opened that file? On the assumption Excel is using the default application font, you could try reducing the Application font size. My go to app for that is Marcel Bresink's freeware app Tinkertool but there are a number of others both free and not free.



"Sacred cows make the best hamburger"

- Mark Twain
Re: Resizing Excel spreadsheet
MacManiac #57952 02/17/21 08:57 AM
Joined: Aug 2009
Likes: 5
ryck Online OP
OP Online

Joined: Aug 2009
Likes: 5
Originally Posted by MacManiac
Try toggling through Full Screen and back to see if that restores your ability to navigate to the bottom of the spreadsheet.....
How do I do that? I can't find anything in the toolbar that would seem to allow me to do that....can't even locate anything called Full Screen.


ryck

iMac (Retina 5K, 27", 2017), 3.4 GHz Intel Core i5, 8GB RAM, 2400 MHz DDR4
OS Mojave 10.14.6
Canon Pixma TR 8520 Printer
Epson Perfection V500 Photo Scanner
Time Machine on 1TB LaCie USB-C
Carbon Copy Clone on 500GB OWC Mercury OTG Pro
Re: Resizing Excel spreadsheet
joemikeb #57953 02/17/21 09:05 AM
Joined: Aug 2009
Likes: 5
ryck Online OP
OP Online

Joined: Aug 2009
Likes: 5
Originally Posted by joemikeb
Has anything that might effect the font changed on your system changed since the last time you opened that file?
Nothing that I am aware of, and certainly nothing deliberate…as I haven’t done anything with fonts for several months when I last ran Font Book.

Originally Posted by joemikeb
On the assumption Excel is using the default application font, you could try reducing the Application font size.
Nope…doesn’t make any difference. It seems that the bottom of the workbook just wants to be off screen. Using “Go To”, I went to the very last row and still could see the bar that allows me to go from sheet to sheet.

Note: This sudden issue is just with this workbook. I opened some others and they are all just fine.

Last edited by ryck; 02/17/21 09:06 AM.

ryck

iMac (Retina 5K, 27", 2017), 3.4 GHz Intel Core i5, 8GB RAM, 2400 MHz DDR4
OS Mojave 10.14.6
Canon Pixma TR 8520 Printer
Epson Perfection V500 Photo Scanner
Time Machine on 1TB LaCie USB-C
Carbon Copy Clone on 500GB OWC Mercury OTG Pro
Re: Resizing Excel spreadsheet
ryck #57954 02/17/21 10:26 AM
Joined: Aug 2009
Likes: 5
Online

Joined: Aug 2009
Likes: 5
Maybe try doing a command-A to select your entire workbook, followed by command-C to copy it, and then command-V to paste it into a newly created workbook?

I think I had the same problem once, and that may be how I fixed it.

Also, have you tried deleting the empty lines at the bottom of your workbook?


The new Great Equalizer is the SEND button.

In Memory of Harv: Those who can make you believe absurdities can make you commit atrocities. ~Voltaire
Re: Resizing Excel spreadsheet
artie505 #57955 02/17/21 12:58 PM
Joined: Aug 2009
Likes: 4
Online

Joined: Aug 2009
Likes: 4
I haven't tried this, but it's worth making this suggestion: Adjust the screen resolution to a greater value. That will make all the print smaller but it may also reveal the bottom of your Excel window. After you are done, you can reset the resolution. To do this, go to System Preferences > Displays and select the Display tab. Select the Scaled radio button and go from there.


Jon

macOS 11.6.1, iMac Retina 5K 27-inch, late 2014, 3.5 GHz Intel Core i5, 1 TB fusion drive, 16 GB RAM, Epson SureColor P600, Photoshop CC, Lightroom CC, MS Office 365
Re: Resizing Excel spreadsheet
jchuzi #57956 02/17/21 03:20 PM
Joined: Aug 2009
Likes: 5
ryck Online OP
OP Online

Joined: Aug 2009
Likes: 5
Originally Posted by jchuzi
I haven't tried this, but it's worth making this suggestion: Adjust the screen resolution to a greater value. That will make all the print smaller but it may also reveal the bottom of your Excel window. After you are done, you can reset the resolution.
Thank you....that did it. Interestingly, it took two attempts. The first time, it didn't expose the bottom bar but simply restored the original problem. However, as it made the resolution change (following the short interval of black screen), there was a very quick flash of the workbook in its entirety so I thought it was worth a second try and I repeated the sequence. It was a case of "second time lucky".

Last edited by ryck; 02/17/21 03:22 PM.

ryck

iMac (Retina 5K, 27", 2017), 3.4 GHz Intel Core i5, 8GB RAM, 2400 MHz DDR4
OS Mojave 10.14.6
Canon Pixma TR 8520 Printer
Epson Perfection V500 Photo Scanner
Time Machine on 1TB LaCie USB-C
Carbon Copy Clone on 500GB OWC Mercury OTG Pro
Re: Resizing Excel spreadsheet
ryck #57957 02/17/21 04:13 PM
Joined: Aug 2009
Likes: 4
Online

Joined: Aug 2009
Likes: 4
You're very welcome. I'm glad that it worked for you.


Jon

macOS 11.6.1, iMac Retina 5K 27-inch, late 2014, 3.5 GHz Intel Core i5, 1 TB fusion drive, 16 GB RAM, Epson SureColor P600, Photoshop CC, Lightroom CC, MS Office 365
Re: Resizing Excel spreadsheet
ryck #57971 02/18/21 06:53 PM
Joined: Aug 2009
Likes: 4
Moderator
Offline
Moderator

Joined: Aug 2009
Likes: 4
An after the fact reply for info....congratulations on finding your way out of the dilemma.

If you hover your cursor over the little Green dot in the upper left corner of the Excel window, you should get a tool-tip contextual info that will tell you about entering Full Screen mode....and OBTW, to exit Full Screen mode simply hit the Escape key. To show the header portion of the Window (which seemingly goes away while in Full Screen mode), simply run your cursor up to the top limit of your screen and the header will pop down into view....this would also allow you to exit Full Screen mode by toggling the little Green dot a second time.


Freedom is never free....thank a Service member today.
Re: Resizing Excel spreadsheet
MacManiac #57981 02/18/21 11:12 PM
Joined: Aug 2009
Likes: 5
ryck Online OP
OP Online

Joined: Aug 2009
Likes: 5
Originally Posted by MacManiac
An after the fact reply for info....congratulations on finding your way out of the dilemma.
Thanks….I was doing some serious sweating for a while there.

Originally Posted by MacManiac
If you hover your cursor over the little Green dot in the upper left corner of the Excel window, you should get a tool-tip contextual info that will tell you about entering Full Screen mode….
No info on my Excel (14.7.7). Hovering over the green dot produces two opposing arrows and clicking on it expands the sheet dramatically.


ryck

iMac (Retina 5K, 27", 2017), 3.4 GHz Intel Core i5, 8GB RAM, 2400 MHz DDR4
OS Mojave 10.14.6
Canon Pixma TR 8520 Printer
Epson Perfection V500 Photo Scanner
Time Machine on 1TB LaCie USB-C
Carbon Copy Clone on 500GB OWC Mercury OTG Pro
Re: Resizing Excel spreadsheet
ryck #57983 02/18/21 11:32 PM
Joined: Aug 2009
Likes: 4
Online

Joined: Aug 2009
Likes: 4
I believe that the green dot options to which Macmaniac is referring only occur in Catalina and Big Sur (and I'm not sure about Catalina, but I definitely see them in Big Sur).


Jon

macOS 11.6.1, iMac Retina 5K 27-inch, late 2014, 3.5 GHz Intel Core i5, 1 TB fusion drive, 16 GB RAM, Epson SureColor P600, Photoshop CC, Lightroom CC, MS Office 365
Re: Resizing Excel spreadsheet
jchuzi #57986 02/19/21 01:16 AM
Joined: Aug 2009
Likes: 5
Online

Joined: Aug 2009
Likes: 5
Originally Posted by jchuzi
I believe that the green dot options to which Macmaniac is referring only occur in Catalina and Big Sur (and I'm not sure about Catalina, but I definitely see them in Big Sur).
I've got no way to test that, but I can say that I see the options in Excel 2016 (in Big Sur), but ryck is running only 2011.


The new Great Equalizer is the SEND button.

In Memory of Harv: Those who can make you believe absurdities can make you commit atrocities. ~Voltaire
Re: Resizing Excel spreadsheet
jchuzi #58002 02/19/21 06:46 PM
Joined: Aug 2009
Likes: 3
Offline

Joined: Aug 2009
Likes: 3
Originally Posted by jchuzi
I believe that the green dot options to which Macmaniac is referring only occur in Catalina and Big Sur (and I'm not sure about Catalina, but I definitely see them in Big Sur).

In Catalina hovering over the green dot gives three options: full screen, tile window to the left of screen or tile window to the right of screen. Cool. grin


On a Mac since 1984.
Currently: 27" iMacs, Macbook Air, macOS 10.15.x,; iPhones, iPods and iPads galore!

Moderated by  alternaut, dianne, dkmarsh 

Link Copied to Clipboard
Powered by UBB.threads™ PHP Forum Software 7.7.4
(Release build 20200307)
Responsive Width:

PHP: 7.3.24 Page Time: 0.024s Queries: 42 (0.014s) Memory: 0.7729 MB (Peak: 0.8745 MB) Data Comp: Zlib Server Time: 2021-10-26 14:03:58 UTC
Valid HTML 5 and Valid CSS