| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
To add a label name on several sheets
Hello, I have for example an Excel file which contains sheets jan, fev, mar, april, etc In each sheet, I have cells from 1 to 30 (31) days. I would like to select the cells from 1 to 30 and to give a name (label) €śPLANNING€ť. For that I use the function Insert/ Name / Add on the sheet January. However the label does not refer that only one sheet (January).. If I select the sheet February and that I make the same operation, that will modify the label €śPLANNING€ť and now it refers only to the sheet FEBRUARY. How to make to define a label PLANNING which refers to the sheet in progress and with the same name of label €śPLANNING€ť. Thank you for your assistance |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| To add a name of label on several sheets. | Excel Worksheet Functions | |||
| Autofilter Lists across Multiple Sheets, Maintain Correct Referenc | Excel Worksheet Functions | |||
| In 3 active sheets in wkbk, determine& display the # of sheets that have data | Excel Discussion (Misc queries) | |||
| calculating excel spreadsheet files for pensions and life insurance (including age calculation sheets) | Excel Worksheet Functions | |||
| Multiple sheets selected | Excel Discussion (Misc queries) | |||
Threaded Mode
