ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   only one sheet tab shows up (https://www.excelbanter.com/excel-discussion-misc-queries/188258-only-one-sheet-tab-shows-up.html)

TuNombreAqui

only one sheet tab shows up
 
Recently Excel has begun showing one giant sheet tab, and not all of it
either. I found a thread from a few years ago, tired everything that was
suggested (tool/options/show sheet tabs, and resizing the horizontal scroll
bar) and nothing works. Does anyone know what may have happened, and how I
can get back to showing a nice little "Sheet1" etc? Any help will be much
appreciated.

Gord Dibben

only one sheet tab shows up
 
Right-click on Desktop and PropertiesAppearanceAdvancedItemScrollBar.

What's the setting there?

Usually around 18 or so.

You should be noticing the large size in other places also but this is all I can
think of.


Gord Dibben MS Excel MVP

On Tue, 20 May 2008 16:31:38 -0700, TuNombreAqui
wrote:

Recently Excel has begun showing one giant sheet tab, and not all of it
either. I found a thread from a few years ago, tired everything that was
suggested (tool/options/show sheet tabs, and resizing the horizontal scroll
bar) and nothing works. Does anyone know what may have happened, and how I
can get back to showing a nice little "Sheet1" etc? Any help will be much
appreciated.



TuNombreAqui

only one sheet tab shows up
 


"Gord Dibben" wrote:

Right-click on Desktop and PropertiesAppearanceAdvancedItemScrollBar.

What's the setting there?

Usually around 18 or so.

You should be noticing the large size in other places also but this is all I can
think of.


Gord Dibben MS Excel MVP

On Tue, 20 May 2008 16:31:38 -0700, TuNombreAqui
wrote:

Recently Excel has begun showing one giant sheet tab, and not all of it
either. I found a thread from a few years ago, tired everything that was
suggested (tool/options/show sheet tabs, and resizing the horizontal scroll
bar) and nothing works. Does anyone know what may have happened, and how I
can get back to showing a nice little "Sheet1" etc? Any help will be much
appreciated.




That worked. It was on 13. You rock!

Gord Dibben

only one sheet tab shows up
 
Good to hear you're sorted out.

Good guess on my part.

Curious though.....with my computer resolution 13 would be quite small.

Either 13 is a typo or your resolution is quite different from mine at 1024 x
768


Gord

On Wed, 21 May 2008 12:17:03 -0700, TuNombreAqui
wrote:



"Gord Dibben" wrote:

Right-click on Desktop and PropertiesAppearanceAdvancedItemScrollBar.

What's the setting there?

Usually around 18 or so.

You should be noticing the large size in other places also but this is all I can
think of.


Gord Dibben MS Excel MVP

On Tue, 20 May 2008 16:31:38 -0700, TuNombreAqui
wrote:

Recently Excel has begun showing one giant sheet tab, and not all of it
either. I found a thread from a few years ago, tired everything that was
suggested (tool/options/show sheet tabs, and resizing the horizontal scroll
bar) and nothing works. Does anyone know what may have happened, and how I
can get back to showing a nice little "Sheet1" etc? Any help will be much
appreciated.




That worked. It was on 13. You rock!




All times are GMT +1. The time now is 10:44 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com