A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Excel » Setting up and Configuration
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Setting up Excel to search by columns instead of by rows, by defau



 
 
Thread Tools Display Modes
  #1  
Old April 27th, 2008, 02:32 PM posted to microsoft.public.excel.setup
Keith Howard[_2_]
external usenet poster
 
Posts: 24
Default Setting up Excel to search by columns instead of by rows, by defau

Each time I open Excel, I have to configure the Ctrl+F search dialog box to
search by columns instead of by rows. Is there a way to do this permanently,
so that I do not have to set this up each time I load Excel? (By the way, I
would also like to search by Values instead of by Formulas.)

Thanks.

Keith Howard
  #2  
Old April 27th, 2008, 02:51 PM posted to microsoft.public.excel.setup
Dave Peterson
external usenet poster
 
Posts: 19,791
Default Setting up Excel to search by columns instead of by rows, by defau

You can't change it permanently.

Saved from a previous post:

Excel tries to help by remembering the last settings you used--except for the
first search in that session.

You can use that to your advantage.

You could make a dummy workbook and put it in your xlStart folder. Have a
macro in that workbook that does a find (and sets all the stuff the way you
like). Then closes and gets out of the way.


Option Explicit
Sub auto_open()

'change the settings the way you like
Worksheets("sheet1").Cells.Find What:="", After:=ActiveCell, _
LookIn:=xlValues, _
LookAt:=xlPart, SearchOrder:=xlByColumns, _
SearchDirection:=xlNext, MatchCase:=False

ThisWorkbook.Close savechanges:=False

End Sub

The workbook opens, does a find (to fix your settings) and then closes to get
out of the way.

If you're new to macros, you may want to read David McRitchie's intro at:
http://www.mvps.org/dmcritchie/excel/getstarted.htm

But if you do an Edit|Find and change anything, then those changed settings will
be remembered.

Keith Howard wrote:

Each time I open Excel, I have to configure the Ctrl+F search dialog box to
search by columns instead of by rows. Is there a way to do this permanently,
so that I do not have to set this up each time I load Excel? (By the way, I
would also like to search by Values instead of by Formulas.)

Thanks.

Keith Howard


--

Dave Peterson
  #3  
Old April 27th, 2008, 07:50 PM posted to microsoft.public.excel.setup
Keith Howard[_2_]
external usenet poster
 
Posts: 24
Default Setting up Excel to search by columns instead of by rows, by d

Thanks Dave.

It's not ideal that MS does not give the user such customisability, but your
workaround solved my problem.

Regards,

Keith Howard

"Dave Peterson" wrote:

You can't change it permanently.

Saved from a previous post:

Excel tries to help by remembering the last settings you used--except for the
first search in that session.

You can use that to your advantage.

You could make a dummy workbook and put it in your xlStart folder. Have a
macro in that workbook that does a find (and sets all the stuff the way you
like). Then closes and gets out of the way.


Option Explicit
Sub auto_open()

'change the settings the way you like
Worksheets("sheet1").Cells.Find What:="", After:=ActiveCell, _
LookIn:=xlValues, _
LookAt:=xlPart, SearchOrder:=xlByColumns, _
SearchDirection:=xlNext, MatchCase:=False

ThisWorkbook.Close savechanges:=False

End Sub

The workbook opens, does a find (to fix your settings) and then closes to get
out of the way.

If you're new to macros, you may want to read David McRitchie's intro at:
http://www.mvps.org/dmcritchie/excel/getstarted.htm

But if you do an Edit|Find and change anything, then those changed settings will
be remembered.

Keith Howard wrote:

Each time I open Excel, I have to configure the Ctrl+F search dialog box to
search by columns instead of by rows. Is there a way to do this permanently,
so that I do not have to set this up each time I load Excel? (By the way, I
would also like to search by Values instead of by Formulas.)

Thanks.

Keith Howard


--

Dave Peterson

 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 04:19 PM.


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