| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do you get text to print in subtotal line?
I am trying to use subtotal on my spreadsheet and I cannot get the text to
show up on the subtotal line. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How do you get text to print in subtotal line?
Usually the title is put in a separate cell to the left of the formula. But
if really want the title in the same cell as the value you can give the cell this custom format: "Subtotal " #,##0.00 Tom |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How do you get text to print in subtotal line?
Thank you!
"TomPl" wrote: Usually the title is put in a separate cell to the left of the formula. But if really want the title in the same cell as the value you can give the cell this custom format: "Subtotal " #,##0.00 Tom |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Bold & add line after subtotal row | Excel Worksheet Functions | |||
| would like each subtotal line highlighted | Excel Discussion (Misc queries) | |||
| Subtotal: Totals line output | Excel Discussion (Misc queries) | |||
| How do you add a blank line automatically after the Subtotal line | Excel Worksheet Functions | |||
| Subtotal line selection | Excel Discussion (Misc queries) | |||
Linear Mode
