Prev: Excel auto accumulation formulas
Next: horizontal scroll bar
From: Quixote on 11 May 2010 07:28
How do I get multiple worksheet table to show at the bottom of my Vista
laptop display? The do appear at bottom of my XP desktop display.
Thanks.
From: JLatham on 11 May 2010 07:59
Check Tools --> Options and on the [View] tab make sure that the "Sheet tabs"
option at the lower right has a check in the box next to it.

"Quixote" wrote:

> How do I get multiple worksheet table to show at the bottom of my Vista
> laptop display? The do appear at bottom of my XP desktop display.
> Thanks.
From: Dave Peterson on 11 May 2010 08:06
They could be just barely off the screen:
Window|Arrange|tiled
and resize the way you like.

You could have hidden the tabs:
Tools|options|View tab|check Sheet Tabs

You could have dragged the horizontal scroll bar over the tabs.
You can try to grab the left-edge of the scrollbar and drag to the right.
Or you could use a line of code (which may be easier).
Open excel
Open your workbook (with the problem)
hit alt-f11 to get to the VBE (where macros live)
hit ctrl-g to see the immediate window

type this
ActiveWindow.TabRatio = 0.5
and hit enter



Quixote wrote:

> How do I get multiple worksheet table to show at the bottom of my Vista
> laptop display? The do appear at bottom of my XP desktop display.
> Thanks.

--

Dave Peterson
From: Steve Dunn on 11 May 2010 16:33
Right click on the taskbar (the area at the bottom of your screen) and click
Properties. Deselect "Group similar taskbar buttons"


"Quixote" <Quixote(a)discussions.microsoft.com> wrote in message
news:4CCD4717-BA27-42B8-8C9C-ECC669DA8D07(a)microsoft.com...
> How do I get multiple worksheet table to show at the bottom of my Vista
> laptop display? The do appear at bottom of my XP desktop display.
> Thanks.

 | 
Pages: 1
Prev: Excel auto accumulation formulas
Next: horizontal scroll bar