Brian from Maui
MrExcel MVP
- Joined
- Feb 16, 2002
- Messages
- 8,459
Aloha,
Is there a way to find and replace by rows or columns only?
Brian
Is there a way to find and replace by rows or columns only?
Brian
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
Find and replace
- Thread starter Brian from Maui
- Start date
Excel Facts
Select a hidden cell
Somehide hide payroll data in column G? Press F5. Type G1. Enter. Look in formula bar while you arrow down through G.
Jack in the UK
Well-known Member
- Joined
- Feb 16, 2002
- Messages
- 3,215
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.
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
Brian from Maui
MrExcel MVP
- Joined
- Feb 16, 2002
- Messages
- 8,459
Aloha Jack
Big MAHALO!!
Being doing it the wrong way!
Brian
Big MAHALO!!
Being doing it the wrong way!
Brian
Upvote
0
Brian from Maui
MrExcel MVP
- Joined
- Feb 16, 2002
- Messages
- 8,459
Jack,
How about specific columns or rows
Brian
How about specific columns or rows
Brian
Upvote
0
Similar threads
- Question
