Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #7  
Old 01-08-2014, 03:02 PM
SteveWcg SteveWcg is offline Excel Auto-fill Issues Windows 7 64bit Excel Auto-fill Issues Office 2013
Novice
 
Join Date: Jun 2013
Location: Sydney Australia
Posts: 22
SteveWcg is on a distinguished road
Default

Quote:
Originally Posted by officeboy09 View Post
After you entered the range A1:A30, and then press Enter, the chosen range is highlighted, but only A1 is selected and displayed in the Name box.
Yes A1 is selected and displayed after typing a1:a30 in name box, Ta Pecoflyer that's something new for me, as that's where you type the formula. Then CTRL-Enter fills the formula to the selected cells.

Not sure how that would work for an autofill that isn't a formula, ie fill A1=1 A2=2 to a30

Quote:
Originally Posted by officeboy09 View Post
My 2nd statement means only the date formats that are marked * can auto-switch from one month to the next.
I don't know what version of excel you're on but *Dates are used to translate to a new locale.
Typing 1/1 or 31-Jan or 1/1/14 and then 2/1 (as per original) will autofill when the handle is dragged or you use CTRL-downarrow.

I've only ever seen the problem with filling dates in any format when you've pasted or imported the dates and Excel is confused about the format. Format cells and selecting dd/mm or dd/mmm/yy ofn doesn't work. Best way I've found to get Excel unconfused is to
1. select the text to be filled and then paste values or
2. select the Use Text wizard option when you paste.
3. Sometimes the Error box allows changing to dates but that's usually for numbers stored as text.
Reply With Quote
 



Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel Auto-fill Issues Auto Fill-in, Editable Word Templates? creb1099 Word VBA 2 10-18-2013 10:19 AM
auto fill a word doc from another program hcubed Office 0 06-19-2013 09:42 PM
Excel Auto-fill Issues Auto Color Fill Question Kinar Excel 3 05-14-2013 07:46 AM
Question about auto-fill form Dsp581 Word 3 04-04-2013 11:27 PM
Prompts to auto-fill name of contacts crystaldb Office 4 05-21-2011 06:16 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 09:46 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft