View Single Post
  #8   Report Post  
Posted to microsoft.public.excel.newusers
pookie954 pookie954 is offline
external usenet poster
 
Posts: 4
Default How do I add a 1 to all phone #s(cells) in a column?


Thank you. This worked perfectly! Problem solved.
"jackgopher" wrote:


QUOTE: "Thanks Cimjet. Could you elaborate on "copy down?"


After writing the formula, select the cell containing it.
You will see a small square in the bottom right corner of that selected
cell. Put the mouse cursor over it, and drag it downwards.



_________________
'Excel 2007 tutorial' (http://www.microsoft-office-excel.com)




--
jackgopher