LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Susan C.
 
Posts: n/a
Default stop automatic increment of dates

Using Excel 2003, from Office XP, SP1
I usually want to use autofill w/o making it a series. I finally turned it
off for most numbers, although I can't remember where the options box is
located. However, I can't get the dates to stay put, except to show
"autofill options" & select "copy cells."
I really wish these autocomplete & autofill series options were "opt-in"
rather than "search for the option in every menu, clear the box, then see if
it does what you want it to." Or rather, doesn't do what I never wanted it
to do in the first place.

Quick way to autofill w/no changes?
Thanks for your help,
Susan
 
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
Stop Automatic Reduction of Fractions Annie Excel Discussion (Misc queries) 3 September 13th 05 09:46 AM
Help with automatic dates foxx60 New Users to Excel 1 August 19th 05 06:01 PM
Increment dates kswinth Excel Discussion (Misc queries) 2 June 30th 05 12:01 AM
Automatic updating of Conditional Formats using dates MAD Excel Worksheet Functions 5 May 3rd 05 04:44 AM
Stop Excel Rounding Dates leinad512 Excel Discussion (Misc queries) 1 April 20th 05 04:19 PM


All times are GMT +1. The time now is 07:17 PM.

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"