AutoFill

coneyglaze · Apr 19th, 2002, 10:08 PM

What are the rules that apply to using the autofill of double clicking the handle of an active cell indicator's once the pointer has turned to cross hairs?

KnAsTa · Apr 19th, 2002, 10:16 PM

The autofill when double clicked will only go as far down the page as the column next to it has. If there is nothing in the column next to it, then it will not move.

Chris Davison · Apr 20th, 2002, 05:41 AM

I don't suppose anyone has any tricks that makes it fill upwards too ?

oh, and left and right if possible...

ta
Chris

Audiojoe · Apr 20th, 2002, 05:48 AM

Yeah try this. Right click the cell and select Copy, then hold shift and double click the top of the cell. This takes you right to the top, then just paste. Works for left too

Audiojoe

But through it all when there was doubt, I ate it up and spit it out

[ This Message was edited by: Audiojoe on 2002-04-20 04:49 ]

Chris Davison · Apr 20th, 2002, 06:05 AM

yeah, I usually navigate that way a lot..... it's fab

I was hoping for a "mouse only" thing though like the double click downfill

(it irritates me when I have to go : mouse / keyboard / mouse / keyboard, ya know ?)

In hope,
Chris

Jack in the UK · Apr 20th, 2002, 04:22 PM

mice eat cheese Chris

try CTRL+G (goto) wack in the cell ref as you can see it to mouse it you can call it!

As Audiojoe points out, nice to share that one.

my mouse is called MOUSE by the way nicknamed mouse.

gareth · May 16th, 2002, 05:29 AM

Surely guys

The autofilter function can be used for numerous call-ups.Instead of looking upwards or using ctrl-g
Why not just do a custom search on the subject.

Apr 20th, 2002, 04:22 PM	#6
Jack in the UK Board Regular Join Date: Feb 2002 Posts: 3,065	mice eat cheese Chris try CTRL+G (goto) wack in the cell ref as you can see it to mouse it you can call it! As Audiojoe points out, nice to share that one. my mouse is called MOUSE by the way nicknamed mouse. __________________ Free Excel based Web Toolbar available here. Jack in the UK J & R Excel Solutions "making Excel work for you"

May 16th, 2002, 05:29 AM	#7
gareth Board Regular Join Date: Apr 2002 Location: Cape Town,South Africa Posts: 234	Surely guys The autofilter function can be used for numerous call-ups.Instead of looking upwards or using ctrl-g Why not just do a custom search on the subject. __________________ Regards Gareth Visit The Excel Maniacs :<>: Have a Chat! :<>: Free Stuff!

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Apr 19th, 2002, 10:08 PM	#1
coneyglaze New Member Join Date: Apr 2002 Location: Fort Worth Posts: 13	What are the rules that apply to using the autofill of double clicking the handle of an active cell indicator's once the pointer has turned to cross hairs?

Apr 19th, 2002, 10:16 PM	#2
KnAsTa Board Regular Join Date: Apr 2002 Location: Australia Posts: 52	The autofill when double clicked will only go as far down the page as the column next to it has. If there is nothing in the column next to it, then it will not move.

Apr 20th, 2002, 05:41 AM	#3
Chris Davison MrExcel MVP Join Date: Feb 2002 Location: Millbank, London, UK Posts: 1,790	I don't suppose anyone has any tricks that makes it fill upwards too ? oh, and left and right if possible... ta Chris

Apr 20th, 2002, 05:48 AM	#4
Audiojoe Board Regular Join Date: Feb 2002 Location: Where the wild roses grow Posts: 285	Yeah try this. Right click the cell and select Copy, then hold shift and double click the top of the cell. This takes you right to the top, then just paste. Works for left too Audiojoe But through it all when there was doubt, I ate it up and spit it out [ This Message was edited by: Audiojoe on 2002-04-20 04:49 ]

Apr 20th, 2002, 06:05 AM	#5
Chris Davison MrExcel MVP Join Date: Feb 2002 Location: Millbank, London, UK Posts: 1,790	yeah, I usually navigate that way a lot..... it's fab I was hoping for a "mouse only" thing though like the double click downfill (it irritates me when I have to go : mouse / keyboard / mouse / keyboard, ya know ?) In hope, Chris