Opening worksheets in seperate excel tabs

[sh0t2bts]

at home I have each excel workbook open in a new tab on the start bar but at
work I have to select windows and then the required workbook, can you tell
me how I can change the settings so that each workbook open with it's own
tab on the start bar??

Many Thanks

Mark

[theDude]

Go to menu Tools -> Options, then select the View tab and select the 'Windows in Taskbar' checkbox and click OK.

Hope this helps,
theDude

[Wayne hof]

I think you may be using diferant versions of excel (or windows) at home &
work.
Happens to me to.

"sh0t2bts" wrote:

> at home I have each excel workbook open in a new tab on the start bar but at
> work I have to select windows and then the required workbook, can you tell
> me how I can change the settings so that each workbook open with it's own
> tab on the start bar??
>
> Many Thanks
>
> Mark
>
>
>

[Ken Wright]

Try Tools / Options / View / Check 'Windows in taskbar' option.

Failing that if you are using XP as an OS then I think there is an option in
Taskbar properties to group icons from the same program - Uncheck it.

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03

----------------------------------------------------------------------------
It's easier to beg forgiveness than ask permission :-)
----------------------------------------------------------------------------

"sh0t2bts" <[email protected]> wrote in message
news:[email protected]...
> at home I have each excel workbook open in a new tab on the start bar but
at
> work I have to select windows and then the required workbook, can you tell
> me how I can change the settings so that each workbook open with it's own
> tab on the start bar??
>
> Many Thanks
>
> Mark
>
>

[Gord Dibben]

Mark

Tools>Options>View checkmark "Windows in Taskbar"


Gord Dibben Excel MVP

On Thu, 6 Jan 2005 19:21:01 -0000, "sh0t2bts" <[email protected]> wrote:

>at home I have each excel workbook open in a new tab on the start bar but at
>work I have to select windows and then the required workbook, can you tell
>me how I can change the settings so that each workbook open with it's own
>tab on the start bar??
>
>Many Thanks
>
>Mark
>

[wmjenner]

In XP right click on an empty area of the taskbar, then select Properties and uncheck the box "Group similar taskbar items".