fill all row cells with double click

[Luís Miguel Ramires Vieira Reis RAM]

hi,

sometimes i have problems filling completely a row with a double
click,
because sometimes i double click and it doesnt fill all row cells,
only fills two cells, or i must drag until the end to fill completely
the row.

do u know why?

is there a solution?


thanks

 

[Max]

Happens when the adjacent col contains blank cells
The copy/filldown action will stop at the 1st blank cell

To copy down large ranges where the adjacent col may not be fully
populated, you could do it like this:

Click inside the namebox*, type the range, eg: C2:C8000
Press ENTER, to select the range
*the box with the dropdown just to the left of the formula bar

Then paste your formula for C2 into C2's formula bar,
press CTRL+ENTER, to enter the formula at one go into the entire range
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:20,500 Files:362 Subscribers:64
xdemechanik

 

[Luís Miguel Ramires Vieira Reis RAM]

Happens when the adjacent col contains blank cells
The copy/filldown action will stop at the 1st blank cell

To copy down large ranges where the adjacent col may not be fully
populated, you could do it like this:

Click inside the namebox*, type the range, eg:   C2:C8000
Press ENTER, to select the range
*the box with the dropdown just to the left of the formula bar

Then paste your formula for C2 into C2's formula bar,
press CTRL+ENTER, to enter the formula at one go into the entire range
--
Max
Singaporehttp://savefile.com/projects/236895
Downloads:20,500 Files:362 Subscribers:64
xdemechanik
---
"Luís Miguel Ramires Vieira Reis RAM" <[email protected]>
wrote in message






- Mostrar texto citado -

big thanks

 

[Max]

Welcome
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:20,500 Files:362 Subscribers:64
xdemechanik