Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
HOW DO I FORMAT WORKSHEETS IN A WORKBOOK TO NUMBER IN A SEQUENCE?
I am trying to get my worksheets to either number a specific cell in each
worksheet in sequence or display the sheet name and I will rename the sheets in a sequence. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
HOW DO I FORMAT WORKSHEETS IN A WORKBOOK TO NUMBER IN A SEQUENCE?
Hi!
To get the sheet name: The file must already exist. In other words, it must have already been created and saved. Group all the sheets together that you want to do this to. Enter this formula in the cell where you want the name to appear: =MID(CELL("filename",A1),FIND("]",CELL("filename",A1))+1,255) Ungroup the sheets. Biff "Lee S" <Lee wrote in message ... I am trying to get my worksheets to either number a specific cell in each worksheet in sequence or display the sheet name and I will rename the sheets in a sequence. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Copy Worksheets from one Workbook to Another | Excel Worksheet Functions | |||
Some worksheets not viewable within a workbook on a particular PC | Excel Discussion (Misc queries) | |||
Change number format from text to number? | New Users to Excel | |||
" / " Changing Decimal number format to Fraction on Protected Cell | Excel Worksheet Functions | |||
How do I format a cell for a custom part number? | Excel Discussion (Misc queries) |