Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
dbog
 
Posts: n/a
Default entering a # each row adds 1 to the previous cell. Turn off?

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   Report Post  
Posted to microsoft.public.excel.misc
Peo Sjoblom
 
Posts: n/a
Default entering a # each row adds 1 to the previous cell. Turn off?

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
change cell shading whenever contents different from previous cell zooeyhallne Excel Discussion (Misc queries) 3 June 6th 05 09:59 PM
Copy cell format to cell on another worksht and update automatical kevinm Excel Worksheet Functions 21 May 19th 05 11:07 AM
Excel-can't turn off multiple cell selection or add text/numbers Bob Excel Discussion (Misc queries) 2 March 8th 05 05:47 PM
How would I fill blank cells with the data from a previous cell? Clive Darling Excel Discussion (Misc queries) 3 January 6th 05 01:10 AM
input value in a cell when the previous cell is greater than 0 vinod New Users to Excel 1 December 2nd 04 06:15 PM


All times are GMT +1. The time now is 12:44 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"