entering a # each row adds 1 to the previous cell. Turn off?

G

Guest

When entering numbers in my spreadsheets each row adds another number. i.e.,
2004 becomes 2005, then 2006. A telephone # becomes 811-6001, 6002, 6003.
How do I turn that off so when I pull the corner down to copy it stays the
same?
 
P

Peo Sjoblom

You can right click and pull the corner and when you release the mouse
you'll get an option of copy cells or hold down ctrl and pull down with left
mouse

--
Regards,

Peo Sjoblom

(No private emails please)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top