Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 371
Default how do I find and replace within a selection in Excel 2007?

I'm used to doing this without a thought in earlier versions of Excel, but I
was recently upgraded to 2007, and I can't for the life of me figure it out.
every time I do a replace all with a group of cells selected, it replaces all
in the entire worksheet.
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 35,218
Default how do I find and replace within a selection in Excel 2007?

I bet you're clicking the "Find All" button first (to verify what cells should
be changed before the actual change).

When you do that, you're changing the selection to just a single cell. Move
that dialog box if you can't see the current selection.

You'll want to stop verifying or you'll want to reselect the range to change
before you do the actual replace.

geoff wrote:

I'm used to doing this without a thought in earlier versions of Excel, but I
was recently upgraded to 2007, and I can't for the life of me figure it out.
every time I do a replace all with a group of cells selected, it replaces all
in the entire worksheet.


--

Dave Peterson
  #3   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 371
Default how do I find and replace within a selection in Excel 2007?

Thanks, Dave. That wasn't exactly the problem, but it made me realize what
was. I would select the cells, then ctrl-H to find and replace. when that
dialog came up, the options were visible and "Within: workbook" was selected,
as that's how I usually search these giant spreadsheets. When I changed that
to "Sheet" it worked. This is a change from the previous version I was
using, so not exactly obvious, at least not to me.

and, as an aside, I find it incredibly annoying that MS would take what
should be the bedrock of all work-related software and make random, pointless
changes like that. and don't get me started with the menus. Seriously, in
one of the two pieces of software that everyone in the office-working world
uses, why on earth would you change every single menu, remove the Format
menu, remove Insert rows from the insert tab, etc. list goes on and on.
Moronic! Anyway, sorry for the rant, and thanks for the tip.

"Dave Peterson" wrote:

I bet you're clicking the "Find All" button first (to verify what cells should
be changed before the actual change).

When you do that, you're changing the selection to just a single cell. Move
that dialog box if you can't see the current selection.

You'll want to stop verifying or you'll want to reselect the range to change
before you do the actual replace.

geoff wrote:

I'm used to doing this without a thought in earlier versions of Excel, but I
was recently upgraded to 2007, and I can't for the life of me figure it out.
every time I do a replace all with a group of cells selected, it replaces all
in the entire worksheet.


--

Dave Peterson

  #4   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 35,218
Default how do I find and replace within a selection in Excel 2007?

Well, I hope you're feeling better with that off your chest <vbg.

geoff wrote:

Thanks, Dave. That wasn't exactly the problem, but it made me realize what
was. I would select the cells, then ctrl-H to find and replace. when that
dialog came up, the options were visible and "Within: workbook" was selected,
as that's how I usually search these giant spreadsheets. When I changed that
to "Sheet" it worked. This is a change from the previous version I was
using, so not exactly obvious, at least not to me.

and, as an aside, I find it incredibly annoying that MS would take what
should be the bedrock of all work-related software and make random, pointless
changes like that. and don't get me started with the menus. Seriously, in
one of the two pieces of software that everyone in the office-working world
uses, why on earth would you change every single menu, remove the Format
menu, remove Insert rows from the insert tab, etc. list goes on and on.
Moronic! Anyway, sorry for the rant, and thanks for the tip.

"Dave Peterson" wrote:

I bet you're clicking the "Find All" button first (to verify what cells should
be changed before the actual change).

When you do that, you're changing the selection to just a single cell. Move
that dialog box if you can't see the current selection.

You'll want to stop verifying or you'll want to reselect the range to change
before you do the actual replace.

geoff wrote:

I'm used to doing this without a thought in earlier versions of Excel, but I
was recently upgraded to 2007, and I can't for the life of me figure it out.
every time I do a replace all with a group of cells selected, it replaces all
in the entire worksheet.


--

Dave Peterson


--

Dave Peterson
  #5   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 371
Default how do I find and replace within a selection in Excel 2007?

actually, I do, thanks :-)

"Dave Peterson" wrote:

Well, I hope you're feeling better with that off your chest <vbg.

geoff wrote:

Thanks, Dave. That wasn't exactly the problem, but it made me realize what
was. I would select the cells, then ctrl-H to find and replace. when that
dialog came up, the options were visible and "Within: workbook" was selected,
as that's how I usually search these giant spreadsheets. When I changed that
to "Sheet" it worked. This is a change from the previous version I was
using, so not exactly obvious, at least not to me.

and, as an aside, I find it incredibly annoying that MS would take what
should be the bedrock of all work-related software and make random, pointless
changes like that. and don't get me started with the menus. Seriously, in
one of the two pieces of software that everyone in the office-working world
uses, why on earth would you change every single menu, remove the Format
menu, remove Insert rows from the insert tab, etc. list goes on and on.
Moronic! Anyway, sorry for the rant, and thanks for the tip.

"Dave Peterson" wrote:

I bet you're clicking the "Find All" button first (to verify what cells should
be changed before the actual change).

When you do that, you're changing the selection to just a single cell. Move
that dialog box if you can't see the current selection.

You'll want to stop verifying or you'll want to reselect the range to change
before you do the actual replace.

geoff wrote:

I'm used to doing this without a thought in earlier versions of Excel, but I
was recently upgraded to 2007, and I can't for the life of me figure it out.
every time I do a replace all with a group of cells selected, it replaces all
in the entire worksheet.

--

Dave Peterson


--

Dave Peterson

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Global find and replace in Excel 2007 Woodman Excel Discussion (Misc queries) 1 November 4th 08 12:44 AM
Find & Replace in Excel 2007 RM Excel Discussion (Misc queries) 3 July 3rd 08 12:20 AM
how do i find edit, replace in excel 2007 willyhoops.com Excel Discussion (Misc queries) 2 February 1st 07 03:45 PM
Excel: Add replace within selection functionality Marcel XL Excel Discussion (Misc queries) 1 March 3rd 06 02:51 PM
Find and REPLACE within a selection, or column- not entire sheet/. smithers2002 Excel Worksheet Functions 4 April 21st 05 04:45 PM


All times are GMT +1. The time now is 11:00 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"