Forum Discussion

Copper Contributor

Feb 05, 2023

Excel

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

Bronze Contributor

Feb 05, 2023

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

Then hit CTRL+G and click on Special.

Select Constants and then hit ok.

All data cells should be selected.

Resources