Link to Worksheets

Hello:

I have quite a few worksheets in my excel file. I want to create another
worksheet which will have link to the other spreadsheets. Is this possible.
If so how? This will save me time and i will not have to scroll left and
right looking for the correct spreadsheet.

Thank You
Prasun

='sheet name'!A1

etc

Is this what you mean?

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Prasun" <[email protected]> wrote in message
news:efinIq%[email protected]...
> Hello:
>
> I have quite a few worksheets in my excel file. I want to create another
> worksheet which will have link to the other spreadsheets. Is this
possible.
> If so how? This will save me time and i will not have to scroll left and
> right looking for the correct spreadsheet.
>
> Thank You
> Prasun
>
>

Another option is to right click on the little tab scroll arrows at the
bottom left of the screen. Gives you an easier to read list of sheets.

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

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

"Prasun" <[email protected]> wrote in message
news:efinIq%[email protected]...
> Hello:
>
> I have quite a few worksheets in my excel file. I want to create another
> worksheet which will have link to the other spreadsheets. Is this
possible.
> If so how? This will save me time and i will not have to scroll left and
> right looking for the correct spreadsheet.
>
> Thank You
> Prasun
>
>

Thanks You guys
That worked out


"Ken Wright" <[email protected]> wrote in message
news:%[email protected]...
> Another option is to right click on the little tab scroll arrows at the
> bottom left of the screen. Gives you an easier to read list of sheets.
>
> --
> Regards
> Ken....................... Microsoft MVP - Excel
> Sys Spec - Win XP Pro / XL 97/00/02/03
>
> ----------------------------------------------------------------------------
> It's easier to beg forgiveness than ask permission :-)
> ----------------------------------------------------------------------------
>
> "Prasun" <[email protected]> wrote in message
> news:efinIq%[email protected]...
>> Hello:
>>
>> I have quite a few worksheets in my excel file. I want to create another
>> worksheet which will have link to the other spreadsheets. Is this
> possible.
>> If so how? This will save me time and i will not have to scroll left
>> and
>> right looking for the correct spreadsheet.
>>
>> Thank You
>> Prasun
>>
>>
>
>