| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Find and Replace one row only
I am using Excel 2007.
How can I carry out a Find and Replace on the one row that I have highlighted? The only options I can find are to Find and Replace everything in the sheet or the workbook. Is there not a way of carrying out this on just the selected cells or rows? Nick |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Find and Replace one row only
Just select the range and then Ctrl+H (for replace)
-- Regards, Ashsih Mathur Microsoft Excel MVP www.ashishmathur.com "Nick Wakeham" wrote in message ... I am using Excel 2007. How can I carry out a Find and Replace on the one row that I have highlighted? The only options I can find are to Find and Replace everything in the sheet or the workbook. Is there not a way of carrying out this on just the selected cells or rows? Nick |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Find and Replace one row only
Thanks for that - I am just being thick!
"Ashish Mathur" wrote in message ... Just select the range and then Ctrl+H (for replace) -- Regards, Ashsih Mathur Microsoft Excel MVP www.ashishmathur.com "Nick Wakeham" wrote in message ... I am using Excel 2007. How can I carry out a Find and Replace on the one row that I have highlighted? The only options I can find are to Find and Replace everything in the sheet or the workbook. Is there not a way of carrying out this on just the selected cells or rows? Nick |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Find & Replace: find part cell, replace whole cell | Excel Worksheet Functions | |||
| Find and Replace - Replace with Blank Space | Excel Discussion (Misc queries) | |||
| where to put results of find operation in find and replace functio | Excel Worksheet Functions | |||
| find and replace - replace data in rows to separated by commas | Excel Worksheet Functions | |||
| find replace cursor default to find box | Excel Discussion (Misc queries) | |||
Linear Mode
