#1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 3
Default Find and replace

I use the "find" button quite often. The large box tends to get in the way.
Is there any way to add the find button to the toolbar where it stay out of
my way?
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 3,440
Default Find and replace

Use the shortcut for Find: CTRL+F or for Find and replace: CTRL+H

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"sportswidow" wrote in message
...
I use the "find" button quite often. The large box tends to get in the
way.
Is there any way to add the find button to the toolbar where it stay out
of
my way?


  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 3
Default Find and replace



"sportswidow" wrote:

I use the "find" button quite often. The large box tends to get in the way.
Is there any way to add the find button to the toolbar where it stay out of
my way?

I know how to use the "find" and "replace"--It is the fact that the box
which pops up in the middle of the spreadsheets gets in the way. I am
constantly moving it around. I thought if I could move that box onto a
toolbar (similiar to the font toolbar) it would save a lot of aggravation.
Any suggestions?
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 1,358
Default Find and replace

Really not much you can do.

However, a lot of people nowadays have humongous monitors, if you have
enough space to 'spare' on your monitor, you could run excel with a normal
(aka: resizable) window. Make enough space either above, below, to the left
or to the right (purely your choice) to have the FIND/REPLACE box in the open
space without covering your file. Then, for as long as you have excel open,
when you press CTRL+F, the find box will appear in the open space and not
cover up your spreadsheet.
--
** John C **
Please remember, if your question is answered, to check the YES box below.
It helps everyone.


"sportswidow" wrote:



"sportswidow" wrote:

I use the "find" button quite often. The large box tends to get in the way.
Is there any way to add the find button to the toolbar where it stay out of
my way?

I know how to use the "find" and "replace"--It is the fact that the box
which pops up in the middle of the spreadsheets gets in the way. I am
constantly moving it around. I thought if I could move that box onto a
toolbar (similiar to the font toolbar) it would save a lot of aggravation.
Any suggestions?

  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 3
Default Find and replace



"John C" wrote:

Really not much you can do.

However, a lot of people nowadays have humongous monitors, if you have
enough space to 'spare' on your monitor, you could run excel with a normal
(aka: resizable) window. Make enough space either above, below, to the left
or to the right (purely your choice) to have the FIND/REPLACE box in the open
space without covering your file. Then, for as long as you have excel open,
when you press CTRL+F, the find box will appear in the open space and not
cover up your spreadsheet.
--
** John C **
Please remember, if your question is answered, to check the YES box below.
It helps everyone.


"sportswidow" wrote:



"sportswidow" wrote:

I use the "find" button quite often. The large box tends to get in the way.
Is there any way to add the find button to the toolbar where it stay out of
my way?

I know how to use the "find" and "replace"--It is the fact that the box
which pops up in the middle of the spreadsheets gets in the way. I am
constantly moving it around. I thought if I could move that box onto a
toolbar (similiar to the font toolbar) it would save a lot of aggravation.
Any suggestions?


Thanks John
Now I know I can quit looking for answers--perhaps that is a feature they
can add?



  #6   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 1,358
Default Find and replace

It's possible. If you look at the find feature in web browsers, nowadays it
just pops up a little bar at the bottom of your browser, completely
unobtrusive.
--
** John C **
Please remember, if your question is answered, to check the YES box below.
It helps everyone.


"sportswidow" wrote:



"John C" wrote:

Really not much you can do.

However, a lot of people nowadays have humongous monitors, if you have
enough space to 'spare' on your monitor, you could run excel with a normal
(aka: resizable) window. Make enough space either above, below, to the left
or to the right (purely your choice) to have the FIND/REPLACE box in the open
space without covering your file. Then, for as long as you have excel open,
when you press CTRL+F, the find box will appear in the open space and not
cover up your spreadsheet.
--
** John C **
Please remember, if your question is answered, to check the YES box below.
It helps everyone.


"sportswidow" wrote:



"sportswidow" wrote:

I use the "find" button quite often. The large box tends to get in the way.
Is there any way to add the find button to the toolbar where it stay out of
my way?
I know how to use the "find" and "replace"--It is the fact that the box
which pops up in the middle of the spreadsheets gets in the way. I am
constantly moving it around. I thought if I could move that box onto a
toolbar (similiar to the font toolbar) it would save a lot of aggravation.
Any suggestions?


Thanks John
Now I know I can quit looking for answers--perhaps that is a feature they
can add?

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
Find & Replace: find part cell, replace whole cell katy Excel Worksheet Functions 3 April 3rd 23 01:20 PM
Find and Replace - Replace with Blank Space Studebaker Excel Discussion (Misc queries) 4 April 3rd 23 10:55 AM
where to put results of find operation in find and replace functio DEP Excel Worksheet Functions 5 November 15th 06 07:52 PM
find and replace - replace data in rows to separated by commas msdker Excel Worksheet Functions 1 April 15th 06 01:00 AM
find replace cursor default to find box luffa Excel Discussion (Misc queries) 0 February 3rd 05 12:11 AM


All times are GMT +1. The time now is 12:35 AM.

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"