How can I display the sheet name in the sheet itself? My sheets are named as territory numbers and I want cell A1 of each sheet to be something like
="Territory "&....
I know that this can be accomplished in the header/footer section but I'd prefer to have it in a cell if possible.
="Territory "&....
I know that this can be accomplished in the header/footer section but I'd prefer to have it in a cell if possible.