Multiple Worksheet Display

  • Thread starter Thread starter Music Non Stop
  • Start date Start date
M

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
 
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)
 
Hi,

Tools, Options, View tab, Windows in taskbar.

Regards,

Jan Karel Pieterse
Excel TA/MVP
 
Thanks ! Works a treat. Much appreciated.

Phil

Jan Karel Pieterse said:
Hi,

Tools, Options, View tab, Windows in taskbar.

Regards,

Jan Karel Pieterse
Excel TA/MVP
Click to expand...
 
Back
Top