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

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance



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)


"dbog" <dbog@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message news:C2C73C1B-4DC0-479F-BC57-8AF77E499991@xxxxxxxxxxxxxxxx
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?

.


Quantcast