Find and replace

Excel Facts

Get help while writing formula
Click the italics "fx" icon to the left of the formula bar to open the Functions Arguments dialog. Help is displayed for each argument.
Sort by date Sort by votes
Hi Brian

Select the row or col only

from cell ctrl + space selects entire col that the active cell is in

from cell shift + space selects entire row that the active cell is in

Now just file / replace and fill as reqd.

This will ONLY make changes in the selection.

Take care friend.
 
Upvote 0
You must log in or register to reply here.

Similar threads

JeffGrant
  • Solved
Looking for a Better Find & Replace Solution
Replies
2
Views
245
JeffGrant
JeffGrant
JeffGrant
  • Question
Find & Replace is searching whole workbook instead of just the sheet
Replies
7
Views
118
bobsan42
bobsan42
R
  • Question
Replace with Carriage Return Not Working
Replies
6
Views
157
Alex Blakenburg
A
J
  • Question
VBA code to find replace formula
Replies
7
Views
145
jamesmitchell
J
Knockoutpie
  • Solved
If column BI contains "N" then replace values in the row from column G:BE using the cell in column BF as find criteria and BH as replacement criteria
Replies
2
Views
166
Knockoutpie
Knockoutpie

Forum statistics

Threads
1,214,636
Messages
6,120,668
Members
448,977
Latest member
moonlight6

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top