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


Active Member

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?



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:


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

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:


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

  • Get External Data (long shot question!)
    This is likely a long shot but I am wondering if it is at all possible for Excel to somehow 'change' the contents of a URL that is being linked to...
  • Importing multiple excel files into one spreadsheet
    Hi, I'm trying to import multiple excel files (with the same format into a single spreadsheet) so that each day's file is listed underneath the...
  • Cell Formatting
    Good Morning, I need to format a few different cells in the following manners: A1 has to always add a colon (:) after whatever is typed in by a...
  • How to copy multiple rows using If
    Hi all, I'm very new to VBA and have written this simple code to copy certain cells if a certain cell within that row contains any data. I need...
  • Workbook_Change stopped working !
    I am working on an app to speed up & automate processing of Credit Cards statements. After data is input from a CSV file, it is presented to the...
  • VBA If statement
    Dear All, I have two dates, where I'd like a message box to pop, if the dates are between this criteria. [CODE] sDate1 = #10/1/2019#...