Excel

Copper Contributor

Hi,

How can I select all Data cells selected using Ctrl. F and change the column -  all this together,

1 Reply

@Rahul0510 Select entire sheet by clicking top left small arrow indicator. See below screenshot.

Harun24HR_0-1675652264509.png

Then hit CTRL+G and click on Special.

Harun24HR_1-1675652330497.png

Select Constants and then hit ok.

Harun24HR_2-1675652384784.png

All data cells should be selected.