MrExcel Publishing
Your One Stop for Excel Tips & Solutions

alternatives to the autofill handle?


Posted by laura jean on February 05, 2002 2:27 PM

is there some magic key combo that allows you to select the beginning and ending cells of a Fill selection, instead of clicking and dragging over long ranges? (similar to entering an array formula and cntl+shft+enter)


Posted by Jack in the UK on February 05, 2002 2:30 PM

Try this

Hi--

New sheet, put 1 in A1, right click on the fill handle, and drag to whatever let go a box pops up.. select fill series and bingo.

use this all the time and there are other options, that will work in many situations fill handle fails... try it and try te others options.

doubt many know that one.. good luck

HTH
Jack

Posted by faster on February 05, 2002 2:46 PM

Re: Try this

Good one Jack. Double click the fill handle if filling
a series that is defined by a column next to it.

Posted by laura jean on February 05, 2002 3:11 PM

Brilliant!!!

Those are great tips! I am using this to fill
a column with references to a row (i.e., I want
column A2:A12 to refer to A1:J1). Know a quick
trick for that one???

Posted by Jack in the UK on February 05, 2002 3:28 PM

OL 2nd question try this, copy A1 to J1 and select A2 cell now paste special and click transpose bottom right is and press OK that should do it [NT]

Posted by laura jean on February 05, 2002 3:36 PM

sorry! i neglected to mention that a1:j1 are relative cell references, not numbers (my-duh!)