Archive of Mr Excel Message Board

Back to General Excel archive index
Back to archive home

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)

Try this

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

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

Re: Try this

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

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

Brilliant!!!

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

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???

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 Jack in the UK on February 05, 2002 3:28 PM

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

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

This archive is from the original message board at www.MrExcel.com.
All contents © 1998-2004 MrExcel.com.
Visit our online store to buy searchable CD's with thousands of VBA and Excel answers.
Microsoft Excel is a registered trademark of the Microsoft Corporation.
MrExcel is a registered trademark of Tickling Keys, Inc.