Why a function does not populate across when clicking the + icon?

excelos

Active Member
Hello,

I have a function but when I click the + icon it does not populate across the whole column.

Any idea how to fix this please?

Thanks
 

MARK858

Well-known Member
When you say the + icon do you mean clicking the bottom right hand corner? and you go down a column not across, is this what you mean? or do you mean going across multiple columns?
 
Last edited:

MARK858

Well-known Member
Do you have a continuous column of data in a column next to the column you are autofilling (i.e no blank cells)? and are all the cells below the formula you are autofilling blank?
 
Last edited:

Michael M

Well-known Member
Ther isn't an autoclick for this ( don't know why?), but you can use....
Click the bottom right corner and drag to the right
OR

Using copy/paste
Select the first cell, copy with CTRL+C, extend selection to the end with CTRL+SHIFT+RIGHT, then paste with CTRL+V
 
Last edited:

MARK858

Well-known Member
The OP is filling down(see the Yes,yes,no) so there is a double click on the right hand bottom corner if an adjacent column is populated with no blank cells.
 

Some videos you may like

This Week's Hot Topics

Top