Find and replace

Excel Facts

How to fill five years of quarters?
Type 1Q-2023 in a cell. Grab the fill handle and drag down or right. After 4Q-2023, Excel will jump to 1Q-2024. Dash can be any character.
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
247
JeffGrant
JeffGrant
JeffGrant
  • Question
Find & Replace is searching whole workbook instead of just the sheet
Replies
7
Views
120
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
168
Knockoutpie
Knockoutpie

Forum statistics

Threads
1,214,653
Messages
6,120,750
Members
448,989
Latest member
mariah3

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