Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Ampersand in Header section in Excel 2003
Put in 2 ampersands. i.e. Smith && Jones LLP- Zymurgy35
- Post #2
- Forum: Microsoft: Office
-
excel column add specific
A way of doing this wihout code is to use the SUBTOTAL function. First you need to replace all the autoSUM formulas . To do this, use the find and replace option. Find "SUM(" and replace it with "SUBTOTAL(9,". Finally, add a SUBTOTAL formula below the end row as follows e.g...- Zymurgy35
- Post #3
- Forum: Microsoft: Office
