Write an Excel Function/Formula for an entire column of Excel

Hey guys,
I need to know how a excel function/formula can be used for an entire column of excel.

Like in this file Test.xlsx (9.0 KB) I’ve used a formula for AA2 row, which is to be used for that entire column.


@NiranjanKN Hi,
use send hotkey and select, ctrl+space

did this thread help you resolve this

Cheers @NiranjanKN

In this file I don’t know the range of the rows.
I tried this

But, sometimes it just takes the column header name and pastes it to the entire column.


Hey guys,
Got a solution for it.
Test1.zip (15.2 KB)


This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.