Quote:
Originally Posted by SteveWcg
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.
01-14-2014, 05:52 PM
Similar Threads
Auto Fill-in, Editable Word Templates?
Windows XP 
Office 2003
Threaded Mode