Prev: how do i write on the background of a spreadsheet
Next: Top value
From: Anton on 3 Jun 2010 06:22


"Jason" wrote:

> "Peter Gross" wrote:
>
> > In complex Excel spreadsheets, the current single line for worksheet tabs is
> > restrictive.
>
> I have a worksheet with over 60 tabs. A summary worksheet pulls data from
> all of the other worksheets. I solved my navigation problem by putting a
> hyperlink for each of the other tabs on the summary page. On all the other
> worksheet , there is a hyperlink back to the summary worksheet.
>

This do the trick when navigating data sheets, how ever when working this
summary work sheet and writing formulas containting cells from multiple
worksheets there is just no easy way to use that method for entering 'name of
tab 87'!C2 for instance.

I'd still love to be able to use multiple rows of work sheet tabs or to
shrink the font and/ or turn the tab names 90 degrees for easy access when
working formulas.
From: Steve Dunn on 3 Jun 2010 07:42
Have you tried right-clicking on the group of arrows to the left of the
tabs?


"Anton" <Anton(a)discussions.microsoft.com> wrote in message
news:CD7FD79C-DA6F-4052-8F36-D70B4188E9F5(a)microsoft.com...
>
>
> "Jason" wrote:
>
>> "Peter Gross" wrote:
>>
>> > In complex Excel spreadsheets, the current single line for worksheet
>> > tabs is
>> > restrictive.
>>
>> I have a worksheet with over 60 tabs. A summary worksheet pulls data from
>> all of the other worksheets. I solved my navigation problem by putting a
>> hyperlink for each of the other tabs on the summary page. On all the
>> other
>> worksheet , there is a hyperlink back to the summary worksheet.
>>
>
> This do the trick when navigating data sheets, how ever when working this
> summary work sheet and writing formulas containting cells from multiple
> worksheets there is just no easy way to use that method for entering 'name
> of
> tab 87'!C2 for instance.
>
> I'd still love to be able to use multiple rows of work sheet tabs or to
> shrink the font and/ or turn the tab names 90 degrees for easy access when
> working formulas.

 | 
Pages: 1
Prev: how do i write on the background of a spreadsheet
Next: Top value