Multiple Worksheet Display

[Music Non Stop]

Hi there

For some reason, when I have more than 1 worksheet open in Excel, they no
longer show as seperate worksheets in the menu bar at the bottom of the
screen. I used to be able to click on the worksheet I wanted to in the menu
bar however no I always have to click on the Window pull down menu and
select the worksheet I want.

Can anyone help get it back to what it used to be? It is very inconvenient
when I am constantly clicking between open worksheets and I don't know why
all of a sudden it doesn't display them as they used to.

Thanks
Phil

 

[Bob Phillips]

Phil,

Go to Tools>Options and on the View tab and check the 'Windows in Taskbar'
checkbox.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

 

[Jan Karel Pieterse]

Hi,

Tools, Options, View tab, Windows in taskbar.

Regards,

Jan Karel Pieterse
Excel TA/MVP

 

[Music Non Stop]

Thanks ! Works a treat. Much appreciated.

Phil

Hi,

Tools, Options, View tab, Windows in taskbar.

Regards,

Jan Karel Pieterse
Excel TA/MVP