View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
DeeDeeCee DeeDeeCee is offline
external usenet poster
 
Posts: 17
Default Putting a Snippet of Text in a Cell

This question may by very basic, I don't know.

I'd like to tally a column of cells to arrive at a total. I know how to do
that with the autosum feature. So far, so good.

BUT... because of the layout of my table, I don't have room to put the word
"total" in the cell just to the left, which I would like for quickly
identifying the cell that has the total. Is there a feature where I can
format the cell to include the word "Total:" in it, and then put the numeric
total right after it with the auto-sum feature (so that when entries in the
column change, the total adjusts)?

Thanks in advance. DDC