Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old December 5th 08, 11:06 PM posted to microsoft.public.excel.misc
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
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  
Old December 6th 08, 01:17 AM posted to microsoft.public.excel.misc
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
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  
Old December 6th 08, 01:37 AM posted to microsoft.public.excel.misc
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
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  
Old December 6th 08, 01:41 AM posted to microsoft.public.excel.misc
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
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  
Old December 8th 08, 11:54 PM posted to microsoft.public.excel.misc
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
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 3rd 08 11:44 PM
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 02:45 PM
Excel: Add replace within selection functionality Marcel XL Excel Discussion (Misc queries) 1 March 3rd 06 01: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 05:50 AM.

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

About Us

"It's about Microsoft Excel"

 

Copyright © 2017