Thread: [Solved] Excel Auto-fill Issues
View Single Post
 
Old 01-08-2014, 01:00 AM
officeboy09 officeboy09 is offline Windows XP Office 2003
Advanced Beginner
  
Join Date: Oct 2013
Location: Australia
Posts: 40
officeboy09 is on a distinguished road
Default
Quote:
Originally Posted by Pecoflyer View Post
After you entered the range in the name box next to the formula bar, did the chosen range highlight?
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.

My 2nd statement means only the date formats that are marked * can auto-switch from one month to the next.
Reply With Quote