# Worksheet Name

#### gbradley

##### New Member
In Excel I can put the name of the worksheet that I am printing in the footer with the "&[Tab]".

Is there a way to put the name of a worksheet ito a cell or part of a cell.
e.g. if my worksheet is named "January Totals", can I have cell A4 be the sum of cells A1:A3 and the worksheet name?
10
10
20
40 January Totals
I'm using Microsoft Excel 97 SR-2 Win NT4.0
Thank-you

### Excel Facts

Excel Joke
Why can't spreadsheets drive cars? They crash too often!
Hi,

Following will add the range and pick up the worksheet-name:

=SUM(A1:A3) & "Totals :" & MID(CELL("filename"),FIND("]",CELL("filename",A1))+1,LEN(CELL("filename",A1))-FIND("]",CELL("filename",A1)))

Make sure that You save the workbook first

Kind regards,
Dennis

On 2002-08-28 09:57, gbradley wrote:
In Excel I can put the name of the worksheet that I am printing in the footer with the "&[Tab]".

Is there a way to put the name of a worksheet ito a cell or part of a cell.
e.g. if my worksheet is named "January Totals", can I have cell A4 be the sum of cells A1:A3 and the worksheet name?
10
10
20
40 January Totals
I'm using Microsoft Excel 97 SR-2 Win NT4.0
Thank-you

Part two first:

this formula will return the name of a worksheet to a cell>

=RIGHT(CELL("filename",A1),LEN(CELL("filename",A1))-FIND("]",CELL("filename",A1)))

Note: this will ONLY work in a saved work book.

so to get the answer you need>

=SUM(A1:A3)&" "&RIGHT(CELL("filename",A1),LEN(CELL("filename",A1))-FIND("]",CELL("filename",A1))).

Part one, there is add-in's out there that do just what you need, off hand I can remember the web addresses, Google should wield results for you.
Also, I tend to use the formula for that purpose as well as you have more control over how large a footer can be then (Doesn't work if you doing multiple pages, That why they're footers )

Thanks!
You guys rock!

Replies
1
Views
99
Replies
5
Views
228
Replies
3
Views
258
Replies
11
Views
844
Replies
20
Views
643

### Forum statistics

Threads
1,221,425
Messages
6,159,831
Members
451,592
Latest member
Mrformulaheadache

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

### Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

### Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back