Home

Restricting Find/Replace to single column

%3CLINGO-SUB%20id%3D%22lingo-sub-811619%22%20slang%3D%22en-US%22%3ERestricting%20Find%2FReplace%20to%20single%20column%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-811619%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%20I%20wish%20to%20run%20Find%2FReplace%20on%20a%20single%20column%20of%20a%20woeksheet.%20At%20the%20moment%2C%20Find%2FRepace%20replaces%20every%20occurance%20of%20the%20word%20I%20wish%20to%20replace%20on%20the%20entire%20workbook.%20I%20want%20it%20to%20only%20affect%20a%20single%20column.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-811619%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-811759%22%20slang%3D%22en-US%22%3ERe%3A%20Restricting%20Find%2FReplace%20to%20single%20column%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-811759%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F394720%22%20target%3D%22_blank%22%3E%40RacingTog%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3ESelect%20this%20column%2C%20Ctrl%2BH%20and%20Replace%20All.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-814160%22%20slang%3D%22en-US%22%3ERe%3A%20Restricting%20Find%2FReplace%20to%20single%20column%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-814160%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F521%22%20target%3D%22_blank%22%3E%40Sergei%20Baklan%3C%2FA%3E%26nbsp%3BIt%20doesn't%20work%20Sergi%2C%20it%20still%20replaces%20the%20same%20%22find%22%20in%20all%20the%20cells%20in%20the%20workbook.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-814671%22%20slang%3D%22en-US%22%3ERe%3A%20Restricting%20Find%2FReplace%20to%20single%20column%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-814671%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F394720%22%20target%3D%22_blank%22%3E%40RacingTog%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3Ethis%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20462px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F127779i81E8990E3F5299E5%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%22image.png%22%20title%3D%22image.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3Egives%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20366px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F127780i8217C508B3EE1C20%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%22image.png%22%20title%3D%22image.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-814175%22%20slang%3D%22en-US%22%3ERe%3A%20Restricting%20Find%2FReplace%20to%20single%20column%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-814175%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F394720%22%20target%3D%22_blank%22%3E%40RacingTog%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAre%20you%20sure%20that%20you%20are%20selecting%20the%20whole%20column%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIf%20you%20want%20to%20replace%20values%20in%20a%20specific%20column%2C%20you%20need%20to%20select%20the%20whole%20column%20and%20to%20select%20the%20whole%20column%2C%20click%20on%20the%20column%20header%20(i.e.%20click%20on%20column%20letter)%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EOr%20if%20you%20want%20to%20replace%20values%20in%20a%20selected%20range%2C%20select%20all%20the%20cells%20where%20you%20want%20to%20replace%20a%20value%20and%20then%20invoke%20the%20replace%20window%20by%20pressing%20Ctrl%2BH.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EBut%20if%20only%20one%20cell%20is%20selected%20on%20the%20sheet%2C%20Replace%20All%20will%20replace%20all%20the%20values%20from%20all%20the%20cells%20on%20the%20sheet.%3C%2FP%3E%3C%2FLINGO-BODY%3E
RacingTog
New Contributor

Hi, I wish to run Find/Replace on a single column of a woeksheet. At the moment, Find/Repace replaces every occurance of the word I wish to replace on the entire workbook. I want it to only affect a single column.

4 Replies

@RacingTog 

Select this column, Ctrl+H and Replace All.

@Sergei Baklan It doesn't work Sergi, it still replaces the same "find" in all the cells in the workbook.

@RacingTog 

 

Are you sure that you are selecting the whole column?

 

If you want to replace values in a specific column, you need to select the whole column and to select the whole column, click on the column header (i.e. click on column letter)

 

Or if you want to replace values in a selected range, select all the cells where you want to replace a value and then invoke the replace window by pressing Ctrl+H.

 

But if only one cell is selected on the sheet, Replace All will replace all the values from all the cells on the sheet.

Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
22 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
flashing a white screen while open new tab
cntvertex in Discussions on
13 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies