Thread: [Solved] Excel Auto-fill Issues
View Single Post
 
Old 01-14-2014, 05:52 PM
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 SteveWcg View Post
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
Yes, after typing a1:a30 in name box, and press "enter" or "ctrl enter" straight away would select the whole range (a1:a30) typed in the name box. But then, the name box is auto-filled with only a1, and whatever value you type in the formula bar, excel only input that value into a1 and not the whole range.

My version is MS Office Excel 2003 SP3.
Reply With Quote