Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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? |
#2
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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" wrote in message ... 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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
change cell shading whenever contents different from previous cell | Excel Discussion (Misc queries) | |||
Copy cell format to cell on another worksht and update automatical | Excel Worksheet Functions | |||
Excel-can't turn off multiple cell selection or add text/numbers | Excel Discussion (Misc queries) | |||
How would I fill blank cells with the data from a previous cell? | Excel Discussion (Misc queries) | |||
input value in a cell when the previous cell is greater than 0 | New Users to Excel |