Shortcut for "Overwrite all cells in this column with this formula"

**IronCladRooster** · 07-31-2015, 12:50 PM

Does anyone know of a keyboard shortcut to select the "overwrite all cells in column with this formula" icon after punching in a formula in to an Excel table? With copy and paste you can click control after pasting to sort through all the paste special options, but this doesn't seem to be the case with this icon.

**Steve7913** · 07-31-2015, 01:48 PM

try this...

1 - copy the cell with your formula in it
2 - Hold "Shift" + "Ctrl" and press the "Down" arrow (this should highlight the column
3 - Paste your formula

**ahc0037** · 01-27-2017, 10:18 AM

Did you ever figure this out? I would like to know the shortcut as well.

Shortcut for "Overwrite all cells in this column with this formula"

LinkBack

Thread Tools

Rate This Thread

Display

Shortcut for "Overwrite all cells in this column with this formula"

Re: Shortcut for "Overwrite all cells in this column with this formula"

Re: Shortcut for "Overwrite all cells in this column with this formula"

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] Replace all BLANK cells in column with header title "Balance" to "0"

Macro to copy cells from workbook,where column C is = "num1" AND Column D ="num2"

[SOLVED] How to USE """"" cells count """"" change font color

[SOLVED] If there is any text in column "A$" on "sheet1" then move cell to column "A$" on "sheet2"

[SOLVED] Find "X" in range of cells and return various values based on the column "X" is found in.

[SOLVED] Formula needed to display "Pass" or "Fail" if a column contains any values other than "yes

[SOLVED] Macro with "save as" --- Need excel to overwrite a file without a prompt to overwrite

Excel 2003 should have "multiply multiple cells" macro / shortcut

Bookmarks

Bookmarks

Posting Permissions