Find and replace

Excel Facts

How can you automate Excel?
Press Alt+F11 from Windows Excel to open the Visual Basic for Applications (VBA) editor.
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
253
JeffGrant
JeffGrant
JeffGrant
  • Question
Find & Replace is searching whole workbook instead of just the sheet
Replies
7
Views
133
bobsan42
bobsan42
R
  • Question
Replace with Carriage Return Not Working
Replies
6
Views
184
Alex Blakenburg
A
J
  • Question
VBA code to find replace formula
Replies
7
Views
159
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
197
Knockoutpie
Knockoutpie

Forum statistics

Threads
1,214,985
Messages
6,122,606
Members
449,089
Latest member
Motoracer88

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