Find and replace

Brian from Maui · Mar 11th, 2002, 12:37 PM

Aloha,

Is there a way to find and replace by rows or columns only?

Brian

Jack in the UK · Mar 11th, 2002, 12:52 PM

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.

Brian from Maui · Mar 11th, 2002, 01:05 PM

Aloha Jack

Big MAHALO!!

Being doing it the wrong way!

Brian

Brian from Maui · Mar 11th, 2002, 01:47 PM

Jack,

How about specific columns or rows

Brian

Mar 11th, 2002, 12:52 PM	#2
Jack in the UK Board Regular Join Date: Feb 2002 Posts: 3,064	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. __________________ Free Excel based Web Toolbar available here. Jack in the UK J & R Excel Solutions "making Excel work for you"

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Mar 11th, 2002, 12:37 PM	#1
Brian from Maui Board Regular Join Date: Feb 2002 Posts: 7,743	Aloha, Is there a way to find and replace by rows or columns only? Brian

Mar 11th, 2002, 01:05 PM	#3
Brian from Maui Board Regular Join Date: Feb 2002 Posts: 7,743	Aloha Jack Big MAHALO!! Being doing it the wrong way! Brian

Mar 11th, 2002, 01:47 PM	#4
Brian from Maui Board Regular Join Date: Feb 2002 Posts: 7,743	Jack, How about specific columns or rows Brian