Onsite pages and related off-site material

This list was created using some SPF/PC macros and was originally sorted using an old version of Netscape (pre 4.0), which supported sorting bookmarks.  The date timestamps created using Netscape in the process were then removed.  The content here includes bookmarks found in excel.htm and my other Excel pages as of 1999-02-05.  Additions since then made manually.

If there is something  better for sorting <DL> lists let me know. (must be FREE) David McRitchie

The sort order can be verified using a VBA program by Stratos Malasiotis, 2000-07-13 in message .  The actual purpose is to find all the links on a webpage. (mailto:DMcRitchie%20%6Dsn.com).

The listing below contains links to my pages, and topics on my pages.  Offsite links are included as they are found on individual pages in the related areas as well as few additional links; however, if you are looking for links to other sites John Walkenbach maintains the best Spreadsheet site around and has the best if not the most comprehensive Excel Links page.  I prefer people to come to my site to see my material for it's content (mostly the simple stuff) rather than be known simply as a site for links.  MS KB references not referenced on my pages were seen in newsgroup postings.

When Google Usenet Archives are visited, looking at the entire thread for additional information may be helpful. 

#, How to find ###### in a cell

[--http://groups.google.com/groups?oi=djq&ic=1&selm=an_489629650--] (John Green 14Jun1999)

=GetFormat(cell) -- Display format used in anothercell

[--formula.htm#getformat--]

=GetFormula(cell) -- Display formula used in anothercell

[--formula.htm#getformula--]

A1ONLY

[--a1only.txt--] A macro to copy the current sheet and retain only rows that have a perceived value in Column A.  Creates a copy of worksheet and deletes rows with no perceived value in column A.

Academic Affairs SharedForms Server

[--http://www.humboldt.edu/~oaa/oaaforms.html--]

Accessibility Options / Working with Disabilities

[--shortx2k.htm#accessibility--]

AccountingForms

[--http://accounting.ucdavis.edu/docs/forms/forms.htm--]

acroynyms

[--http://www.ucc.ie/cgi-bin/acronym?BTW--]
such as BTW - By The Way.

Addin

[--formula.htm#addin--] links to additional information

Additional Date/Time related shortcuts

[--datetime.htm--]

Adjusting coding when named cells are used

[--insrtrow.htm--]

Age in Years, Months, Days

[--datetime.htm--]

AltaVista Personal Search or Discovery

[--http://www.altavista.com--]

Alternate-Row Shading

[--http://www.pcworld.com/current_issue/article/0,1212,9061+3+0,00.html--] in XL97 and above using filters

Alternate-Row Shading using a macro

[--http://groups.google.com/groups?oi=djq&ic=1&selm=an_293263161&fmt=raw--]

AutoFilter, Display AutoFilter Criteria in Excel

[--http://www.pcworld.com/shared/printable_articles/0,1440,9061,00.html--]
Steve Bullen's code to show the criteria actually in use when Autofilter is in Effect.  Article in PC World also has information on use of RANK when tied, and use of alternating stripes via conditional formatting

AutoFilter, Find Excel 2000 Data Quickly With AutoFilter

[--http://office.microsoft.com/assistance/2000/P40209.aspx--]

AutoSave, fix for XL2000 not saving settings, Q231117

[--http://support.microsoft.com/default.aspx?scid=kb;en-us;Q231117--]

Baarns Consulting

[--http://www.baarns.com/--]

Backup your Files

[--backup.htm--], see related area of topic for tips on Data Recovery

Bank Reconciliation by Check Numbers

[--insrtrow.htm--]

BEEP, multiple beeps

[--http://groups.google.com/groups?oi=djq&ic=1&selm=an_486845873--] also see Test Wave

[--code/testwave.txt--] in my code area of .wav files.

Birthday and other Date Calculations

[--datecalc.htm--]

BTW, By The Way

[--http://www.ucc.ie/cgi-bin/acronym?BTW--]

Build Table of Contents (BuildTOC) to sheets in your Workbook

[--buildtoc.htm--]
Use a sheet named $$TOC for a Table of Contents complete with hyperlinks.  Includes similar material to build a list of hyperlinks for Subroutines and Functions.

Built-in Constants in Visual Basic for Applications" (WC0993)

[--http://support.microsoft.com/default.aspx?scid=kb;en-us;q112671--],
xlconstants, Q112671, -- also note use of PF2 in the Visual Basic Editor

Calculate worksheet or workbook (F9 items)

[--shortx95.htm#calc--]

Cell Comment indicatior triangle, change color of, Stratos Malasiotis <ieaaf@csv.warwick.ac.uk>

Cell Comments

[--ccomment.htm--]

Change Case (a posted reply)

[--http://groups.google.com/groups?oi=djq&ic=1&selm=an_382221704--]
Also see Proper

[--proper.htm--].

changing date and/or time in footer, without a macro

[--pathname.htm--]

Checkbook, Easy Checkbook for Excel

[--http://www2.pcworld.com/fileworld/file_description/0,1216,5371,00.html--]
in PC World.  Also see mine in insrtrow.htm

[--insrtrow.htm--].

Chip Pearson's Excel Pages

[--http://www.CPearson.com/excel.htm--]

Class Modules

[--http://www.microsoft.com/officedev/index/classmod.htm--]
Links to Chapters from MS publications and papersd

Code Cleaner, VBA

[--http://www.appspro.com/utilities/utilities.asp--] -- Rob Bovey.
Cleaning a project involves saving all of its VBComponents out to text files, deleting the components, then importing the components back from the text files.  Versions for XL95 and XL97/2000.  Stripping comments is optional in XL97/2000 version.

Color Palette -- the 56 Excel Colors

[--colors.htm--]

Color Stripes, Range, Conditional Formatting,

[--colorrng.htm--] Banding, Greenbar stripes (also see autofilter)
An example of coloring lines when the value in Column D (4th column) is negative. Some information on ranges. A quick look at conditional formatting available with XL97 and later.

Color-MatchingBlues [http://search.zdnet.com/pcmag/issues/1507/pcmg0103.htm]

[--http://search.zdnet.com/pcmag/issues/1507/pcmg0103.htm--]

Color Palette -- the 56 Excel Colors

[--colors.htm--]

column heading rows

[--logoshd.htm--]
can be used in place of headers and can be colored

Comments, printing cell comments

[--http://groups.google.com/groups?oi=djq&ic=1&selm=an_548083890--], Nick Hodge 1999-11-13

Compare two workbooks
Compare, Bill Manville &. Myrna Larsen see Compare at http://www.cpearson.com/excel/downloads

[--http://www.cpearson.com/excel/downloads.htm--]

Compare two worksheets utilizing a 3rd to mark differences

[--http://groups.google.com/groups?oi=djq&ic=1&selm=an_331894615--]
=IF([Book1]Sheet1!A1=[Book2]Sheet1!A1,"","X") -- Chris Nelson 1999-03-08 -- Jim Rech 1999-02-22
Compare, Robert Bruce see compare at http://www.analytical-dynamics.co.uk/default.aspx?section=utilities&page=home

[--http://www.analytical-dynamics.co.uk/default.aspx?section=utilities&page=home--]

Conditional Formatting

[--http://www.j-walk.com/ss/excel/eee/index.htm--]
David Hager's "Excel Experts E-Letter Archives

[--http://www.j-walk.com/ss/excel/eee/index.htm--]" letters 3, 8, and 14.
(some techniques for those still on XL95 can be found at John Walkenbach's tip 25

[--http://www.j-walk.com/ss/excel/tips/tip25.htm--]).

Convert an Excel range to an HTML Table --Charles Balch

[--http://balch.org/charlie/hdoc/exceltohtml.html--]

Convert negative numbers with a trailing minus sign

[--insrtrow.htm#fixrightminus--]

Converting Dates to Text

[--datetime.htm--]

Converting Formula to/from absolute

[--formula.htm#absolute--]
PF4 will change relative to the absolute (A1, $A$1, A$1, $A1).

Converting Text Data

[--strings.htm--]

Converting Text Dates to Dates

[--datetime.htm--]

Converting Units -- decimal feet to feet and inches

[--http://groups.google.com/groups?oi=djq&ic=1&selm=an_468598218--]

Cool "Secrets" About Microsoft Excel (MS KB)

[--http://support.microsoft.com/support/excel/content/cooltips/cool.asp--] -- Cool Tips

Copy color palettes between workbooks

[--colors.htm--]

Count, number of formulas, number of conditional formulas

[--http://groups.google.com/groups?oi=djq&ic=1&selm=an_5480399915--]Walkenbach/Hager

COUNT, Tip 52:Cell Counting Techniques

[--http://www.j-walk.com/ss/excel/tips/tip52.htm--]
range using: DCOUNT, COUNT, COUNTA, COUNTBLANK, COUNTIF, and includes one

Counting Years,Months and Days

[--http://www.j-walk.com/ss/excel/tips/tip55.htm--]

Tip 55 - John Walkenbach - also gives an idea of what an array formula
is and how to implement.  Also see Tip 43 Multifunctional Functions.
i.e. -- count of cells that contain a number between 3 and 10
   =COUNTIF(data,">=3")-COUNTIF(data,">10")

Creation of Shortcut keys spreadsheet

[--join.htm#shortcut--]

CRLF, elimination using a macro

[--join.htm#ReplaceCRLF--]

D:/Excel/Examples/Samples.xls

[--file:///D|/Excel/Examples/Samples.xls--]
see your MS Office 95 CD-ROM

Data Recovery, "How to Troubleshoot Damaged Workbooks"

[--http://support.microsoft.com/support/excel/content/excelfolders/default.asp--]
also see related information in backup

[--backup.htm--].

Date & Time

[--datetime.htm--]

Date and Time serials

[--datetime.htm--]

Date Calculation

[--datecalc.htm--]

Date formatting, windowing and Y2K

[--y2k.htm--]

date time - DATEDIF (Chip Pearson) Q129277

[--http://www.CPearson.com/excel/datedif.htm--]
and see John Walkenbach's XDATEDIF for one without the problems built into Excel dates, developer download for XL97 and above.

Dates Prior to 1900 and George Washington's birthday

[--datetime.htm#gwash--]

Date And Time (David McRitchie)

[--datetime.htm--]

Date And Time Entry (Chip Pearson)

[--datetime.htm--]
for XL97 describes how to enter time or dates without separators -- i.e. 1234 for time entry 12:34.

DATETIME (Chip Pearson)

[--http://www.CPearson.com/excel/datetime.htm--]

David McRitchie

[--http://www.mvps.org/dmcritchie/excel.htm--] -- My Excel Site

DejaNews Power Search

[--http://www.dejanews.com/help/help_ps.shtml--]

Delete Empty Cells and Cells with Only Spaces

[--delempty.htm--]

Delete Empty Cells in Range

[--delempty.htm--]

DeleteBlankRows() (Chip Pearson)

[--http://www.cpearson.com/excel/deleting.htm#DeleteBlankRows--]
on Chip's pages.  If cell in the selected range (one column)
is empty (ISBLANK) then the entire row will be deleted.  Select a single cell, a range in the cell, or the entire column.  Only the usedrange will be processed.

DeleteDuplicateRows() (Chip Pearson)

[--http://www.cpearson.com/excel/deleting.htm#DeleteDuplicateRows--]
Chip has made a specialty of Identifying and Deleting Duplicates, and matters concerning Date & Time.

Deleting/Inserting Lines, is easier if OFFSET(row,col) is used

[--insrtrow.htm--]
Relates to INSRTROW macro which facilitates inserting lines while retaining formulas. 

Determining the Number of Printed Pages (J.Walk tip 65)

[--http://www.j-walk.com/ss/excel/tips/tip65.htm--]

Determiningthe Data Type of a Cell (J.Walk tip 62)

[--http://www.j-walk.com/ss/excel/tips/tip62.htm--]

Developer FAQ, Baarns.com

[--http://www.baarns.com/DevOnly/pages/maindfaq.asp--]

Dialog, list of built-in dialog arguments

[--http://groups.google.com/groups?oi=djq&ic=1&selm=an_572097747--] -- Patrick Molloy

Dispersion Pattern Analysis

[--http://indecol.mtroyal.ab.ca/biol1210/disp.htm--]

Display Sheet Statistics *Tom Ogilvy*

[--../../dmcritchie/formula.htm#MsgSheetStats--]

DOS assignments of the 16 colors (0-15)

[--colors.htm--]

download files

[--http://biz.idbsu.edu/is/is102/DOWNFILE.HTM--]
homework examples from a previous semester (idbsu.edu)

downloads MS Office updates

[--http://officeupdate.microsoft.com/index.htm--]

Drop-Down List of Possible Input Values (Excel), Create a

[--http://www.pcworld.com/heres_how/article/0,1400,7805+1+1,00.html--],
Oct 1998, John Walkenbach's column in PC World

[--http://www.j-walk.com/ss/pcworld/index.htm--] (no macros involved).

Duplicate Entries

[--http://www.CPearson.com/excel/duplicat.htm--] (Chip Pearson)

Duplicate, delete if entire row equals another

[--http://groups.google.com/groups?oi=djq&ic=1&selm=an_290846061--]
Re: Find and delete duplicate rows macro requested please --- Jerry Hunt

Duplicate Row, remove using Advanced Filter

[--http://groups.google.com/groups?oi=djq&ic=1&selm=an_442452503--]
Re: Locate Duplicate Rows? -- Ogilvy, Thomas -- also works in XL95

Dynamic Data Exchange (DDE) and NetDDE FAQ

[--http://www.angelfire.com/biz/rhaminisys/ddeinfo.html--]

E:/Excel/Examples/Samples.xls

[--E:/Excel/Examples/Samples.xls--]

Easter Eggs, by Gil Bates PC-World, April 9, 1998

[--http://www2.pcworld.com/news/daily/data/0498/980409172950.html--]
Also see eeggs

[--www.eeggs.com--] and check out Easter Eggs at John Walkenbach's Excel site

[--http://www.j-walk.com/ss/excel/--].

EBCDIC, BCD, ASCII, and Excel Sorting considerations

[--sorting.htm--]

Elapsed Time and Count-Down Timer

[--datetime.htm--]

ElapsedTimeon DejaNews thread

[--http://x10.dejanews.com/dnquery.xp?search=thread&svcclass=dnserver&threaded=1&ST=PS&CONTEXT=907990625.1281818799&HIT_CONTEXT=907990625.1281818799&HIT_NUM=14&recnum=%3cu1uLX9s89GA.209@uppssnewspub04.moswest.msn.net%3e%231/1--]

Engineers, Internet Software Guide for Engineers

[--http://www.geocities.com/CapeCanaveral/Launchpad/9631/excel.html--]
Watch out for ad popups (see my excel.htm if this link is not found)

EnumerateAddIns()

[--http://groups.google.com/groups?oi=djq&ic=1&selm=an_407801389--] List the add-ins into an "AddinsSheet" in your workbook.

EnumerateSheets

[--http://groups.google.com/groups?oi=djq&ic=1&selm=an_489871760--] macro to list sheets found in workbook, requires two columns. See BuildTOC

[--buildtoc.htm--] macro for one with hyperlinks in XL2000.

Escape characters  in formats use a backslash, in Find/Replace use a tilde.
to search for * or ? or ~, you enter it as ~*, ~? and ~~, respectively.

Euro currency symbol - euro FAQ (MS KB)

[--http://www.microsoft.com/typography/faq/faq12.htm--]
and

[--http://www.microsoft.com/windows/euro.asp#printing--]
Also see my home page

[--excel.htm--].

Excel (J.Walkenbach's site)

[--http://www.j-walk.com/ss/excel/--]

Excel 97 SupportSites? response by ...

[--http://groups.google.com/groups?oi=djq&ic=1&selm=an_400866288--]
(Google Usenet Archives)

Excel and VBA portions of Internet Software Guide for Engineers

[--http://www.100folhas.pt/software/excel.html--]

Excel and VBApages -- Frank Isaac

[--http://isaacsf.home.mindspring.com/vba/fr_vba.htm--]

Excel DeveloperTip Archives

[--http://www.j-walk.com/ss/excel/tips/index.htm--]
(J.Walkenbach)

Excel FAQs -- list of FAQ by John Walkenbach

[--http://www.j-walk.com/ss/excel/faqs/index.htm--]

Excel Newsgroups and Searching Newsgroups

[--xlnews.htm--]

Excel site (John Walkenbach's -- Excel Spreadsheets pages)

[--http://www.j-walk.com/ss/excel/--]

Excel Tips -- John Walkenbach

[--http://j-walk.com/ss/excel/tips/--]

Excel to HTML links

[--excel.htm#xl2html--]

excel.htm

[--excel.htm--]

Excel95 Stuff at .edu sites

[--http://www.altavista.digital.com/cgi-bin/query?pg=aq&KL=en&what=web&kl=XX&q=url%3Aedu+%26+url%3Aexcel+++%26+%28xl95+%7C+excel95+%7C+95+%7C+%22excel+95%22%29&r=&d0=21%2Fmay%2F96&d1=&search.x=45&search.y=8--]
Google Usenet Archives Search

Extract the first two initials

[--strings.htm--]

FAQ information for Excel and Spreadsheets

[--faq.htm--]

Feet and Inches from feet

[--formula.htm#GetFormatExample--] on Formula page as an example under GetFormat

File Access with Visual Basic® for Applications

[--http://support.microsoft.com/support/Excel/Content/FileIO/FILEio.asp--]
How to process files with the file input/output (I/O) functions that Visual Basic for Applications provides. -- MS Support Article        

File Extensions

[--excel.htm#ext--]
Places to find them - excel.htm#ext

Filename in a Cell, Header, or Footer

[--pathname.htm--]

Fill Handle

[--join.htm#fillhandle--]
Fill handles are used to propagate data through contiguous rows and/or columns based on the current selection.

Fill in the Empty Cells

[--../dmcritchie/excel/fillempt.htm--]
this macro will fill in empty cells with the content of the cell above
it, providing the cell above is also within the selection range.

FillBlanks() -- like FILLEMPT but works in Excel5 version and up, Gary Barlow 1998-06-30

[--fillempt.htm--]

FillEmpty() - Fill empty cells with value of cellabove, XL95 and above

[--fillempt.htm--]

FillEmpty, Fill in empty cells

[--fillempt.htm--]

Find number of characters in a cell

[--strings.htm--]

Find the nth occurance of a word in a string, etc.

[--strings.htm--]

Find the nth word in a string

[--strings.htm--]

Find the number of words in a string

[--strings.htm--]

Find, VBA to search across multiple sheets?

[--http://groups.google.com/groups?oi=djq&ic=1&selm=an_349933057--]
also check two more listed in Find across multiple sheets

[--http://groups.google.com/groups?oi=djq&ic=1&selm=an_454625970--]

First Character checked as alphabetic character

[--strings.htm--]

FixRightMinus

[--insrtrow.htm#fixrightminus--], fix for numbers that have minus sign on right and are treated as text.

FontInfo(cell)

[--formula.htm#FontInfo--] displays FONT information for a referenced cell.

Fonts, Getting a List of Installed Fonts

[--http://www.j-walk.com/ss/excel/tips/tip79.htm--] -- John Walkenbach (tip 79)
A simple technique (for Excel 97 or later) to retrieve a list of installed font names. and an alternative to an API function on Stephen Bullen's site.

footers -- full filename including pathnamein Headers and Footers

[--pathname.htm#dfoot--]

Formlst.xla and Simtools.xla

[--http://www.kellogg.nwu.edu/faculty/myerson/ftp/addins.htm--] add-ins available from Northwestern Univ
for heavy statistical modeling, Monto Carlo simulation and Tornado simulation.  Includes formlst.xla to document formulas in use in a given range.

Format, display format used in another cell, and some custom format examples

[--formula.htm#getformat--]

Formatting for Date and Time

[--datetime.htm--]

Formula, Creating aList of Formulas

[--http://j-walk.com/ss/excel/tips/tip37.htm--]
(J.Walkenbach) uses less coding but is identical in function, to the GetFormulaInfo example from Microsoft.

Formula, Determining the Data Type of a Cell

[--http://www.j-walk.com/ss/excel/tips/tip62.htm--]
Tests include ISTEXT, ISLOGICAL, and ISERROR. In addition, VBA includes functions such as IsEmpty, IsDate, and IsNumeric.  Also see GetFormula

[--formula.htm#getformula--] and GetFormulaInfo

[--formula.htm#getformula--].

Formula, Display Formula in a MsgBox

[--formula.htm#msgformula--]

FORMULA, display, in use in another cell

[--formula.htm#getformula--]

Free Excel Downloads(Rob Bovey) old site

[--http://www.appspro.com/utilities/utilities.asp--]

Freeze Panes

[--freeze.htm--] for viewing and Repeating descriptive Rows/Columns for printing.
Also see Headcols

[--headcols.htm--]

Frequently Asked Questions (FAQ)

[--faq.htm--]

ftp://rtfm.mit.edu/pub/usenet/comp.apps.spreadsheets/faq

[--ftp://rtfm.mit.edu/pub/usenet/comp.apps.spreadsheets/faq--]

Function Names, Origin of Excel Worksheet ...

[--http://www2.odn.ne.jp/excel/functioninenglish.html--] Descriptive summary of functions and how they were named

FWIW, For What It's Worth (acronym)

[--http://www.ucc.ie/cgi-bin/acronym?FWIW--]

FYI, For Your Information (acronym)

[--http://www.ucc.ie/cgi-bin/acronym?FYI--]

GetFormat(cell), display the format used in another cell

[--formula.htm#getformat--]

GetFormula(cell), display the formula found in another cell

[--formula.htm#getformula--]

GetFormulaInfo

[--formula.htm#getformulainfo--]

Gradebook,Creating a

[--http://triton.dsu.edu/uswest97/msoffice/excel.htm--]

Grades --USING EXCEL 5.0 TO KEEP GRADES UCSB Psychology Department TA Training

[--http://www.psych.ucsb.edu/~taap/resources/excel.html--]
Program (Santa Barbara, CA)

Gradesheet,Creating a,  with MS Excel by Peter Friesen, Plattsburgh State Univ

[--http://www1.plattsburgh.edu/it/helpfile/excel/gradexc.htm--]

Graphics in Headers or Footers

[--headcols.htm--]

Hans Herber

[--http://www.herber.de/--] [Translate German to English

[--http://translator.go.com/cb/trans_entry?input_type=url&lp=ge_en&url=http://www.herber.de/--]]

HasFormula

[--formula.htm#hasformula--]
A similar VBA function combining features of GetFormula can be found on John Walkenbach's site “Determining the Data Type of a Cell (tip 62)

[--http://www.j-walk.com/ss/excel/tips/tip62.htm--]”

Header or Footer, adding pathname tip 22 (J.Walkbach)

[--http://www.j-walk.com/ss/excel/tips/tip22.htm--]

Header, Make first row available for logos

[--logoshd.htm--]

Header, You can dedicate the first row(s) to yourheader

[--logoshd.htm--]

Headings for Columns

[--headcols.htm--]

Help with gradecalc formula, response R.V. Mendoza's

[--http://groups.google.com/groups?oi=djq&ic=1&selm=an_392497983--]

HELP within Excel

[--excel.htm#xlhelp--]

Hex Color Chart

[--http://www.mta.ca/comment/wwwcon/hexchart.html--]
for the HTML Resource Guide. [http://www.mta.ca/comment/wwwcon/hexchart.html], also see Color

Hiding gridlines with borders or white pattern fill

[--logoshd.htm--]

Hints for NewPosters - Chip Pearson

[--http://www.CPearson.com/excel/newposte.htm--]

Historical Stock Quotes

[--http://investor.msn.com/charts/charting.asp--]
One ticker at a time.  Daily quotes for 12 months.

holidays- Chip Pearson's site

[--http://www.CPearson.com/excel/holidays.htm--]

HTH, Hope This Helps (acronym)

[--http://www.uX5cc.ie/cgi-bin/acronym?HTH--]

HTML downloads

[--goldfarb.htm--]

HTML in Excel 97 -- Microsoft Excel 97 on the Web

[--http://support.microsoft.com/support/Excel/Content/Excel97/xlweb.asp#_Toc370646034--], XL97 to and from HTML (MS KB article)

HTML, ** EXCEL conversion to HTML

[--xl2html.htm--]
XL2HTML macro and other material of interest.

http://www.CPearson.com/excel/newposte.htm -- Chip Pearson's site

[--http://www.CPearson.com/excel/newposte.htm--]

http://www.mvps.org/dmcritchie/excel/excel.htm

[--excel.htm--]

http://www.oaltd.co.uk

[--http://www.oaltd.co.uk--]
Steve Bullen's site (http://www.oaltd.co.uk

[--http://www.oaltd.co.uk--])

http://www.faqs.org/faqs/spreadsheets/faq/

[--http://www.faqs.org/faqs/spreadsheets/faq/--]

http://www.j-walk.com/ss/

[--http://www.j-walk.com/ss/--]

http://www.microsoft.com/typography/fontpack/default.htm

[--http://www.microsoft.com/typography/fontpack/default.htm--]

Hyperlinks in cells, and building a TOC

[--buildtoc.htm#hyp--]

Including a Date in a footer

[--pathname.htm#dfoot--]

Insert a Row using a Macro to maintain formulas

[--insrtrow.htm--]

Insert Row using a Macro

[--insrtrow.htm--]

Insert the logo onto the spreadsheet

[--logoshd.htm--]

Inserting cell data into header/footer

[--pathname.htm--]

Install a button to invoke macro

[--insrtrow.htm--]

Install a Macro

[--formula.htm#install--]

Install the Custom Button

[--pathname.htm--]

Internal Format of Excel files

[--http://mspress.microsoft.com/books/1062.htm--] -- full details about the file format of Microsoft Excel -- Excel Developer's Kit

Internet SoftwareGuide for Engineers

[--http://www.100folhas.pt/software/excel.html--]

INTERPRET

[--wsfunct.htm--] check the INDIRECT and OFFSET Worksheet Functions (INTERPRET is in the REXX language)

Invoices,

[--http://www4.zdnet.com/pccomp/oc/projects/0397p1/0397p1.html--]
Contains information to tweak the Invoice template (MS Word invoice.dot) in MS Office 97 value Pack.&mbsp; Also see Harald Staff's use of a text file to store numbers in msgid: <01c00138$4c905e60$31228fa4@UK679621.gbcoopers.com>

John Walkenbach

[--http://www.j-walk.com/ss/about/index.htm--]

John Walkenbach in PC World

[--http://www.j-walk.com/ss/pcworld/index.htm--]

Join() columns - opposite ofText to Data

[--join.htm#join--]

Julian Date conversions

[--http://groups.google.com/groups?oi=djq&ic=1&selm=an_488468851--] (Myrna Larson)

Language

[--language.htm--], working with languages other than English
in Excel and in Web pages.  (Short summary at bottom

[--#language--])

Large and Small

[--formula.htm#large--] Worksheet function to find the nth largest or smallest value in a range.

Last Saved Date

[--datetime.htm--]

Lastname()

[--#lastname--]
Put lastname before firstname, unless cell in the range already has a comma.

Latitude & Longitude Calculations (Chip Pearson)

[--http://www.CPearson.com/excel.htm--]

Laurent Longre

[--http://longre.free.fr/--] http://longre.free.fr/   [translate French to English

[--http://translator.go.com/cb/trans_entry?input_type=url&lp=fr_en&url=http://longre.free.fr/--]]
-- Entire site in French

Laurent Longre

[--http://longre.free.fr/english/--] http://longre.free.fr/english/
English subset only has -- Morefunc.xll, 33 add-in worksheet functions

Leading capital(a posted reply) remainder of sentence in lowercase.

[--http://groups.google.com/groups?oi=djq&ic=1&selm=an_382999836--]

Leading dot or other character, precede with asterisk
as in "*.@", see Help, Repeating Characters in Format.

Learning Microsoft Excel

[--http://www.exnet.iastate.edu/Pages/Excel/homepage.html--]
(Iowa State Univ)

Links

[--http://www.metrics.com/links.htm--]
at metrics

links -- J.Walkenbach

[--http://www.j-walk.com/ss/excel/xllinks.htm--]

Links to some Frequently Asked Questions (FAQ)

[--excel.htm#faq--]

Logo or graphic into a header or footer

[--logoshd.htm--]
Information is included for creating a test logo (Picture)

Lowercase

[--proper.htm#lower--]

Mail Merge, using MS Word to print mailing labels with postal bar codes

[--mailmerg.htm--]

MarkCells() - marks cellswith address when invoked

[--join.htm#markcells--]

Microsoft Excel

[--http://demog.berkeley.edu/~gene/193/excel.htm--]

Microsoft Excel -- What's New

[--http://www.microsoft.com/exceldev--]

Microsoft Excel for Windows Frequently Asked Questions(KB article)

[--http://support.microsoft.com/support/excel/content/faq/default.asp?PR=ALL&T1=7d&FR=0&A=T&T=B&S=F& &am--]

Microsoft Excel97 and Visual Basic for Applications list --Ricardo Carvalho

[--http://www.100folhas.pt/software/benoliel.html--]

Microsoft Support site - Excel

[--http://support.microsoft.com/support/excel/--]

Microsoft Technical Support -- Knowledge Base

[--http://support.microsoft.com/support/c.asp?FR=0--]
Registration is required to access the MS KB, cookies on, Java on, not easy to work with, not always working, sometimes unusable with the "wrong" browsers; sometimes things move around; but you somehow manage (and sometimes you don't).

Microsoft Technical Support- Ref Guide****

[--http://www.microsoft.com/support/supportnet/refguide/default.htm--]

MicrosoftOffice97/Visual Basic Programmer's Guide ****

[--http://www.microsoft.com/officedev/articles/Opg/toc/pgtoc.htm--]

MIME elimination

[--http://support.microsoft.com/default.aspx?scid=kb;en-us;q138053--]
MS KB elimination of E-mail and Newsgroup HTML and RTF attachments; also see my comments item#9

[--posting.htm#9--] in Posting comments.

Miscellaneous Things unrelated to Excel (but found on my Excel home page)

[--excel.htm#misc--]

Money 98 to Excel Filter, PC World Online: Fileworld:

[--http://www2.pcworld.com/fileworld/file_description/0,1216,5137,00.html--]
Win 95, XL 97 Freeware written by Microsoft.

MS KB -- Search the Microsoft Knowledge Base

[--http://support.microsoft.com/support/search/c.asp?SPR=--] of technical support information.
Microsoft has a nasty habit making their websites responsive only to Internet Explorer.  Pages with an .ASP extension are particularly troublesome.  If you cannot use the above you might try one of the following:

SEARCH -- microsoft.com Search Wizard

[--http://search.microsoft.com/us/default.asp--]
Replacement for the good KB Search form.

Microsoft Technical Support--Support Options

[--http://support.microsoft.com/support/c.asp?FR=0--]

Microsoft Technical Support- Ref Guide

[--http://www.microsoft.com/support/supportnet/refguide/default.htm--] (not found)

Support Online from Microsoft Technical Support -- Advance Search

[--http://support.microsoft.com/support/--]

Personal Online Support Highlights

[--http://support.microsoft.com/support/default.asp--], access to MS KB and Browseable lists (FAQ, and articles).

Advance Search

[--http://search.support.microsoft.com/kb/c.asp--] Maxwell free zone, but still has $%%%#$#@ frames.

MSP

[--http://www.asia.microsoft.com/visualtools/strategy/MicrosoftSupport.htm--]
Microsoft Solutions Provider

Multiplication Table

[--join.htm#MultTab--]

Multipurpose Internet Mail Extensions (MIME)

[--http://www.oac.uci.edu/indiv/ehood/MIME/MIME.html--]

MVP

[--http://www.microsoft.com/supportnet/supportpartners/mvps/brochuregeneral.htm--]
Most Valuable Professional.

My Excel Pages -- David McRitchie

[--excel.htm--]

NAddr2SS

[--naddr2ss.txt--]
Convert 1-UP Name and Address labels to multiple column spreadsheet table.

Names in workbook

[--http://groups.google.com/groups?oi=djq&ic=1&selm=an_413945488--], difference between book-level & sheet-level names

Netiquette

[--http://www.yahoo.com/Computers_and_Internet/Internet/Information_and_Documentation/Beginner_s_Guides/Netiquette/--]
page on Yahoo

Newsgroups, Excel

[--xlnews.htm--]

Number of days in a Month

[--datetime.htm--]

Numbers to words (as in check protection wording)

[--strings.htm#numberstowords--]

OBTW, Oh By The Way (acronym)

[--http://www.ucc.ie/cgi-bin/acronym?BTW--]

Office 97/VisualBasic Programmer's Guide

[--http://www.microsoft.com/officedev/articles/opg/--]

OFFSET, Worksheet function, example in INSRTROW

[--insrtrow.htm--]

Ole P. Erlandsen's

[--http://edc.bizhosting.com--] pages. Utilities, Addin pages.  English version and Norwegian webpages.

Online Lessons

[--http://www.ag.ndsu.nodak.edu/lessons/--]
Excel -- North Dakota State Univ.

Ordinal numbers, and Ordinal numbers in dates

[--datetime.htm#ordinal--] as in 1st, 2nd, 3rd, and 11th May, 1999

OTHO, On the Other Hand (acronym)

[--http://www.ucc.ie/cgi-bin/acronym?OTOH--]

Outlook Express 5.0

[--oe5.htm--], some tips on using OE5

Pathname in headings, footers, and cells

[--pathname.htm--]

Payne Consulting (Rob Bovey used to be here)

[--http://www.payneconsulting.com/--]. Rob Bovey is now at Application Professionals

[--http://www.appspro.com/utilities/utilities.asp--]

PC World current issue

[--http://www.pcworld.com/current_issue/--]

PC World Spreadsheets column

[--http://www.pcworld.com/software/spreadsheet/--]

Pearson, Chip

[--http://www.CPearson.com/excel.htm--]
see Chip Pearson

Pivot Tables, Introduction To

[--http://www.cpearson.com/excel/pivots.htm--] -- Harold Staff

Pivot Tables, Memory errors in (Q1576486)

[--http://support.microsoft.com/default.aspx?scid=kb;en-us;Q157486--]
Not enough memory to completely display PivotTable.

Pivot tables--Put a New Spin on Your Data by Donna Payne

[--http://www.payneconsulting.com/pivotarticle/pivot.htm--]

PivotTable Reports 101 for Excel 2000

[--http://officeupdate.microsoft.com/2000/downloadDetails/XCrtPiv.htm--], download a Tutorial
A complete tutorial, including animations, for creating a PivotTable report and modifying it

Placing a current date or time constant that will not change later

[--datetime.htm--]

Placing a current date or time that will update on recalculation

[--datetime.htm--]

Populating a Table based on number of rows and columns

[--join.htm#MultTab--]

Posting to Excel Newsgroups - with my additional comments

[--posting.htm--]

Posting to Spreadsheet Newsgroups

[--faq.htm--]

Printed Colors Different than on Screen: Blue is Purple, etc.

[--http://support.microsoft.com/default.aspx?scid=kb;en-us;q97600--]
Problem is RGB colors (light) are additive.  CMYK colors
(pigments) are subtractive. This is not a problem with your printer driver or with Microsoft Windows

Printing Multiple Ranges on One Page (posted Jun 3, 1999)

[--http://groups.google.com/groups?oi=djq&ic=1&selm=an_485419612--]

Programming

[--http://support.microsoft.com/support/excel/programming.asp--]
Microsoft® Excel for Windows®

Propagation using the Fill Handles

[--join.htm--]

PROPER

[--proper.htm#proper--]

Proper, and other Text changes

[--proper.htm--]

Properties for DOS Session under WinNT

[--../rexx/spf03.htm#bw2--]

Q000000 -- Search the Microsoft Knowledge Base of technical support information

[--http://support.microsoft.com/support/search/c.asp?SPR=--]
The Microsoft articles below are arranged in alpha order not numerical order, so Q0... is really Q...
You can also get articles by sending an E-mail with the article number as the subject to mshelp@microsoft.com

[--mailto:mshelp@microsoft.com--]

Q048606 -- Excel: Comparison of Values Does Not Return Correct Result

[--http://support.microsoft.com/default.aspx?scid=kb;en-us;q48606--]
Excel does an exact match on floating point binary numbers (read about Rounding errors)
Also see Q48606, Q78113, Q42980

Q072578 -- XL:Converting Hours in Decimal Form to HH:MM:SS Format

[--http://support.microsoft.com/default.aspx?scid=kb;en-us;q72578--]

Q078113 -- Excel: Floating-Point Arithmetic May Give Inaccurate Results

[--http://support.microsoft.com/default.aspx?scid=kb;en-us;Q78113--]

Q081026 -- XL:Calculating Days Remaining in a Time Period

[--http://support.microsoft.com/default.aspx?scid=kb;en-us;q81026--]

Q081694 -- XL:Formula to Calculate Number of Days in Month

[--http://support.microsoft.com/default.aspx?scid=kb;en-us;Q81694--]

Q089228 -- Excel: AutoFill Rules for Creating a Series

[--http://support.microsoft.com/default.aspx?scid=kb;en-us;q89228--]

Q094870 -- XL:Changing the Date or Time Format in a Header or Footer

[--http://support.microsoft.com/default.aspx?scid=kb;en-us;q94870--]

Q099349 -- XL:Working with Time Periods That Exceed 24 Hours

[--http://support.microsoft.com/default.aspx?scid=kb;en-us;q99349--]

Q105069 -- XL: Macros to Sort Tabs in the Active Workbook

[--http://support.microsoft.com/default.aspx?scid=kb;en-us;q105069--]

Q107564 -- XL: Not All Worksheet Functions Supported as Application (in VBA)

[--http://support.microsoft.com/default.aspx?scid=kb;en-us;q107564--]

Q108278 -- XL: Macros to Return Windows and System Directories Paths

[--http://support.microsoft.com/default.aspx?scid=kb;en-us;q108278--]

Q108425 -- XL: How to Create Add-in Application Name and Description

[--http://support.microsoft.com/default.aspx?scid=kb;en-us;q108425--]

Q112361 -- XL: Negative Date/Time Value Displayed as Pound Signs (###)

[--http://support.microsoft.com/default.aspx?scid=kb;en-us;q112361--]

Q112671 -- "Built-in Constants in Visual Basic for Applications" (WC0993)

[--http://support.microsoft.com/default.aspx?scid=kb;en-us;Q112671--] (xlconstants)

Q112632 -- XL: Setting Status Bar Text and ToolTips for Toolbar Buttons

[--http://support.microsoft.com/default.aspx?scid=kb;en-us;q112632--]

Q116281 -- XL: Visual Basic Procedures for Julian Date Calculations

[--http://support.microsoft.com/default.aspx?scid=kb;en-us;q116281--] DO NOT USE as it stands Mar 1999 instead see Myrna Larson's posting

[--http://groups.google.com/groups?oi=djq&ic=1&selm=an_488468851--]

Q120596 -- XL: Importing Text Files Larger Than 16384 Rows

[--http://support.microsoft.com/default.aspx?scid=kb;en-us;q120596--] Breaks files longer than sheet limit into more sheets. (Microsoft Excel 97 has a limit of 65,536 rows)

Q123183 -- XL: Procedure to Export Text File with Comma AND Quote Delimiter

[--http://support.microsoft.com/default.aspx?scid=kb;en-us;Q123183--] -- coding for subroutine / CSV .csv .txt

Q124105 -- XL: Find Command Doesn't Work Across Worksheets in Group

[--http://support.microsoft.com/default.aspx?scid=kb;en-us;q124105--].  Sample FindData() macro included.

Q126895 -- XL: Macro to Change the ToolTip Name for Custom Toolbar

[--http://support.microsoft.com/default.aspx?scid=kb;en-us;q126895--]

Q129277 ++ see missing DATEDIF() documentation at Chip Pearson's site, or in Excel 2000 HELP

[--http://www.CPearson.com/excel/datedif.htm--]

Q129277 -- XL: Undocumented Worksheet Function DATEDIF

[--http://support.microsoft.com/default.aspx?scid=kb;en-us;q129277--]

Q131554 -- XL: Formatted Text (.prn) Limited to 240 Characters Per Line

[--http://support.microsoft.com/default.aspx?scid=kb;en-us;Q131554--], provides a macro solution.

Q134617 -- XL: Resetting the Last Cell Fixes Memory/Printing Problems

[--http://support.microsoft.com/default.aspx?scid=kb;en-us;q134617--]

Q138053 -- XFOR: Preventing WINMAIL.DAT Sent to Internet Users

[--http://support.microsoft.com/default.aspx?scid=kb;en-us;q138053--]
which explains what WINMAIL.DAT is and how to disable the attachment to E-mail messages.

Q141288 -- XL: How to Use a Custom Function in Another Workbook

[--http://support.microsoft.com/default.aspx?scid=kb;en-us;q141288--]

Q141688 -- XL: Visual Basic Macros to Add or Delete a Custom Menu

[--http://support.microsoft.com/default.aspx?scid=kb;en-us;q141688?FR=0--]

Q142117 -- XL: Summary of Methods to Recover Data from Corrupted Files

[--http://support.microsoft.com/default.aspx?scid=kb;en-us;q142117--]

Q142122 -- XL: Macro to Search for Cell Formats: Font, Border, and Interior

[--http://support.microsoft.com/default.aspx?scid=kb;en-us;q142122--]

Q142126 -- XL: Looping Through Worksheets

[--http://support.microsoft.com/default.aspx?scid=kb;en-us;q142126--]

Q142136 -- XL: Inserting and Formatting Text in Headers and Footers

[--http://support.microsoft.com/default.aspx?scid=kb;en-us;q142136--]

Q142140 -- XL: How to Add the Workbook Path to the Footer

[--http://support.microsoft.com/default.aspx?scid=kb;en-us;q142140--] includes directions to install a macro

Q147273 -- XL: The Internet Assistant Wizard (Html.xla)

[--http://support.microsoft.com/default.aspx?scid=kb;en-us;q147273--] An addin for XL95 (Excel 7.0a)

Q149502 -- Resources for Programming with Visual Basic for Applications

[--http://support.microsoft.com/default.aspx?scid=kb;en-us;q149502--]

Q149689 -- XL: Visual Basic Macro Examples for Working With Arrays

[--http://support.microsoft.com/default.aspx?scid=kb;en-us;q149689--]

Q149777 -- XL: How to Play a Warning Sound If Critical Value Is Exceeded

[--http://support.microsoft.com/default.aspx?scid=kb;en-us;q149777--]

Q150363 -- XL: How to Use a VBA Macro to Sum Only Visible Cells

[--http://support.microsoft.com/default.aspx?scid=kb;en-us;Q150363--]

Q151490 -- XL: How to Create a Global User-Defined Function

[--http://support.microsoft.com/default.aspx?scid=kb;en-us;q151490--]

Q151503 -- XL: How to Call a Macro Repeatedly on a Fixed Time Interval

[--http://support.microsoft.com/default.aspx?scid=kb;en-us;q151503--]

Q156942 -- XL97: How to Create an Add-in File in Microsoft Excel 97

[--http://support.microsoft.com/default.aspx?scid=kb;en-us;Q156942--]

Q157202 -- XL97: Color Palette Looks Different in MS Excel 97

[--http://support.microsoft.com/default.aspx?scid=kb;en-us;q157202--]

Q157486 -- XL97: Limits of PivotTables in Microsoft Excel 97

[--http://support.microsoft.com/default.aspx?scid=kb;en-us;Q157486--]
Not enough memory to completely display PivotTable.

Q157763 -- OFF97: Memory Problems When Hyperlinking Between Programs

[--http://support.microsoft.com/default.aspx?scid=kb;en-us;q157763--]

Q158140 -- XL: How to Play Sounds Using Visual Basic for Applications

[--http://support.microsoft.com/default.aspx?scid=kb;en-us;q158140--]

Q159466 -- XL97: List of ID Numbers for Built-In Command Bar Controls

[--http://support.microsoft.com/default.aspx?scid=kb;en-us;Q159466--]

Q159474 -- Startup Switches for MS XL97

[--http://support.microsoft.com/default.aspx?scid=kb;en-us;q159474--] reregister Excel extensions

Q159619 -- XL97: Sample Macros to Control Menus and Submenus

[--http://support.microsoft.com/default.aspx?scid=kb;en-us;Q159619--]

Q161235 -- XL97: How to Use a Toolbar Settings File from a Network Share

Q161607 -- XL97: Macro to Change the Date/Time Format in a Header/Footer

[--http://support.microsoft.com/default.aspx?scid=kb;en-us;Q161235--]

Q163435 -- VBA: Programming Resources for Visual Basic for Applications

[--http://support.microsoft.com/default.aspx?scid=kb;en-us;q163435--]

Q163678 -- XL Err Msg: "Too Many Different Cell Formats"

[--http://support.microsoft.com/default.aspx?scid=kb;en-us;q163678--] Also see my too many formats

[--slowresp.htm#formats--] on my Slow Response page.

Q164406 -- XL: How Microsoft Excel Works with Two-Digit Year Numbers.

[--http://support.microsoft.com/default.aspx?scid=kb;en-us;q164406--]

Q166755 -- XL97: WE1183: "Customizing Menu Bars, Menus, and Menu Items"

[--http://support.microsoft.com/default.aspx?scid=kb;en-us;q166755?FR=0--]

Q168561 -- XL97: How to Programmatically Save a Worksheet as HTML

[--http://support.microsoft.com/default.aspx?scid=kb;en-us;q168561--]

Q168650 -- XL97: "Not Enough Memory" Error Adding Chart to Workbook

[--http://support.microsoft.com/default.aspx?scid=kb;en-us;q168650--]

Q172305 -- XL97: LastUpdated Argument of Htmlconvert Is Not Functional

[--http://support.microsoft.com/default.aspx?scid=kb;en-us;q172305--]

Q181370 -- XL: Microsoft Excel Incorrectly Assumes 1900 Is a Leap Year

[--http://support.microsoft.com/default.aspx?scid=kb;en-us;q181370--]

Q183626 -- XL:How the DateSerial Function Works with Year Arguments

[--http://support.microsoft.com/default.aspx?scid=kb;en-us;q183626--]

Q188449 -- XL97: Delete Links Wizard Available (also see Rob Bovey)

[--http://support.microsoft.com/default.aspx?scid=kb;en-us;q188449--]

Q231117 -- XL:AutoSave, fix for XL2000 not saving settings

[--http://support.microsoft.com/default.aspx?scid=kb;en-us;Q231117--]

Q233073 -- XL2000: How to Prevent the Automatic Creation of Hyperlinks

[--http://support.microsoft.com/default.aspx?scid=kb;en-us;Q233073--]
also see my BuildTOC

[--buildtoc.htm--] for more hyperlink related information.

Q236299 -- XL2000: Error Message: "An error occurred while loading 'Sheet1111111111111..."

[--http://support.microsoft.com/default.aspx?scid=kb;en-us;Q236299--]

Read a Disk Directoryinto a Speadsheet

[--http://groups.google.com/groups?oi=djq&ic=1&selm=an_379201225--]

Real-Time Clock

[--datetime.htm--]

Realtime Clock

[--http://tycho.usno.navy.mil/cgi-bin/anim--]
US Naval Observatory

Rearranging Data in Columns

[--join.htm--]

Recalculate worksheet or workbook

[--shortx95.htm#calc--]
F9 and Shift+F9 and Ctrl+Alt+F9

Removing default Header and/or Footer

[--pathname.htm--]

Removing macros

[--http://groups.google.com/groups?oi=djq&ic=1&selm=an_530249281--] from a workbook, Jim Rech 28Oct1999 misc.

Reopening, Excel attempts to reopen when starting

[----]
filename.xls is already open.  Reopening will cause any changes you made to be discarded.  Do you want to reopen filename.xls? -- Solution provided by Jim Rech, involves registry change.

ReplaceCRLF using a macro

[--join.htm#ReplaceCRLF--]

REPT Worksheet Function, example

[--join.htm#REPT--]

ResetLast Cell Used

[--lastcell.htm--]

[--http://www.vbrad.com/pf.asp?p=Source/src_excel_namebox.htm--] Resize the Name Box -- Robert Gelb

response by TomOgilvy

[--http://groups.google.com/groups?oi=djq&ic=1&selm=an_401003741--]

Reverse Cells in Selection endfor end

[--join.htm#reversi--]

ReversI() - reverse orderof items in row, column

[--join.htm#reversi--]

Revised Real-Time Clock

[--datetime.htm--]

RFC 2795

[--http://www.hypermail.org/rfcs/rfc2795.html--]

RGB Hex Triplet ColorChart

[--http://www.phoenix.net/~jacobson/rgb.html--]

Right-click Menus, Customizing Your

[--http://www.officevba.com/features/1997/10/vba199710dr_f/vba199710dr_f.asp--],
David Ringstrom (OfficeVBA.com), Customization of both the "Cell" and "Ply" commandbar menus, (sample code)

[--http://www.officevba.com/features/1997/10/vba199710dr_f/vba199710dr_f.zip--]  Also see Toolbars

[--toolbars.htm--] page.

Rob Bovey

[--http://www.appspro.com/utilities/utilities.asp--] at Application Professionals

Rules of Conduct

[--http://support.microsoft.com/support/news/rules.asp?PR=EXL&T1=7d&FR=0&A=T&T=B&S=F&--]

Samples from CD-ROM yourdrive

[--E:/OFFCDR1/EXCEL/EXAMPLES/SAMPLES.XLS--]

SAVE problems in Excel

[--save.htm--]

Search the InterNet

[--websrch.htm--]

Select cells with either formulas or contants

[--formula.htm#selectCells--]

Separate Last word (term)from remainder of cell

[--join.htm#seplastterm--]

SepTerm() - separate termsafter the first

[--join.htm#septerm--]

Serial# of Computer

[--http://groups.google.com/groups?oi=djq&ic=1&selm=an_592218663--], (Re: Limit xla file to run on one computer)

Sheets, Worksheet VBA Coding

[--sheets.htm--]

Shortcut keys spreadsheet, Creation of

[--join.htm#shortcut--]

Shortcut keys spreadsheet, Creation and Example

[--shortx95.htm#calc--]

Show FORMULA of another cell in Excel

[--formula.htm#getformula--]

Slow Response and Memory Problems in Excel

[--slowresp.htm--], Speeding up Excel, Enhancing Performance

SnakeCols - flow columns to fewerpages

[--snakecol.htm--]

Sorting, notes on

[--sorting.htm--]

Sorting Sheets in Workbook

[--http://groups.google.com/groups?oi=djq&ic=1&selm=an_489871760--] macros to sort and list sheets found in workbook, also see Q105069

[--http://support.microsoft.com/default.aspx?scid=kb;en-us;q105069--]. (also see Enumerateaddins)

Sounds, changing and removal use Settings, Control Panel, Sound; i.e. Windows Explorer

spreadsheet, Excel, John Walkenbach

[--http://www.j-walk.com/ss/excel/--]

Spreadsheets FAQ at FAQS.org

[--http://www.faqs.org/faqs/spreadsheets/faq/--]

Status Bar

[--statusbar.htm#statusbar--] a convenient place to find SUM of a range of cells

Stephen Bullen's ExcelPage

[--http://www.oaltd.co.uk/Excel/Default.htm--] -- http://www.oaltd.co.uk/Excel/Default.htm

Steve Bullen's site

[--http://www.oaltd.co.uk--] or http://www.oaltd.co.uk

[--http://www.oaltd.co.uk--]

String Manipulations

[--strings.htm--]

Strings

[--strings.htm--]

SUMIF

[--sumif.htm--]

SUMIF, Tip 74:Summing and Counting Using Multiple Criteria

[--http://www.j-walk.com/ss/excel/tips/tip74.htm--]
using SUMIF, COUNTIF, SUM that should solve most counting and summing problems.

  Summarizing Data, and Auto Filter

[--sumdata.htm--]
Some examples for Auto Filter (Data menu), Conditional Formatting (Format menu), Pivot Table (Data Menu), Subtotals (Data menu)

Symbols in HTML and Excel (also see table above on that page)

[--../rexx/htm/symbols.htm#msexcel--]

System Date/Time into a Cell

[--datetime.htm--]

Templates

[--http://cba.winthrop.edu/sykesd/Templates/default.htm--]
includes a template for a class roster. (David A Sykes)

Templates (.XLT)

[--toolbars.htm--]

Testing Things on This WebPage

[--join.htm#markcells--]

Text Functions

[--strings.htm--]

The Land GrantTraining Alliance

[--http://www.ag.ndsu.nodak.edu/lessons/alliance.htm--]

TIA, Thanks in Advance (acronym)

[--http://www.ucc.ie/cgi-bin/acronym?TIA--]

Time is recorded as fractional Days

[--datetime.htm--]
Timesheet, see John Wallenbach's site

Time, What Time Is It? USNaval Observatory time reporting

[--http://tycho.usno.navy.mil/what.html--]

Tip 52: Cell CountingTechniques

[--http://www.j-walk.com/ss/excel/tips/tip52.htm--]
COUNT, COUNTA, COUNTBLANK, COUNTIF, and includes one array formula example.

Tip 74: Summing and Counting Using Multiple Criteria

[--http://www.j-walk.com/ss/excel/tips/tip74.htm--]
using SUMIF, COUNTIF, SUM that should solve most counting and summing problem

Tips SUMIF and others

[--http://home.navisoft.com/excelhelp/tip.htm--]
at http://home.navisoft.com/excelhelp/tip.htm

Tips&Resources from Microsoft

[--http://support.microsoft.com/support/excel/defaultresources.asp?PR=EXL&T1=7d&FR=0&A=T&T=B&S=F& & &a--]

Tips, MicrosoftExcel 97 -- Tips 'n Stuff

[--http://chipsnet.com/users/ksdurbin/excel.html--]

Tips,ExcelTips on Ziff-Davis site

[--http://search.zdnet.com/cgi-bin/texis/zdhelp/zdhelp/search.html?Utext=excel--]

Tips,Top Tips and Tricks (MS KB)

[--http://support.microsoft.com/support/excel/content/tips/toptips.asp--]

TipsandResources MS KB Excel

[--http://support.microsoft.com/support/excel/content/defaultresources.asp--]

Tipsfor Excel found on AltaVista

[--http://www.altavista.digital.com/cgi-bin/query?pg=aq&KL=en&what=web&kl=XX&q=url%3Aexcel+%26+Tips&r=&d0=21%2FMar%2F97&d1=&search.x=57&search.y=10 &--]

Title bar, How to put the full pathname on the titlebar

[--pathname.htm--]

toolbar, recovery

[--toolbars.htm#emergency--]

Toolbars and Custom Buttons Excel 7.0a for Windows95

[--toolbars.htm--]

Toolbars and Custom Buttons in XL95

[--toolbars.htm--]

Toolbars to Microsoft Excel Workbooks and Templates, Attach Custom

[--http://www.microsoft.com/exceldev/articles/toolbatt.htm--]

toolbars, and buttons

[--toolbars.htm--]

Toolbar - faceids

[--http://www.j-walk.com/ss/excel/tips/tip67.htm--] Available at John Walkenbach's site
Button Faces.  Scroll about 2/3 down and look for "Button Faces." (56k); This
file is for Excel 5/95 from Douglas A. Jankuski -- two toolbars become
available "100 Button Faces" and "Custom Toolfaces" while the Excel file
is up.  You can add them to your own toolbars at that point. 
Also check out his

Toolbar - faceids

[--http://www.oaltd.co.uk/MVP/Default.htm--]List of menu items, tool bar buttons, faceids, used in a workbook can be documented by the CBlist addin by John Green.

Translate, Go Translator

[--http://translator.go.com/--]
English translations to/from Spanish, French, German, Italian, Portuguese

Troubleshooting Microsoft Excel 2000

[--http://support.microsoft.com/support/Office/InProdHlp/contents/Excel/tocxlmain9hhc33.asp--]

Tushar Mehta

[--http://tushar-mehta.com/--] website, a frequent poster to the Excel Newsgroups.

Typography http://www.microsoft.com/typography/fontpack/default.htm

[--http://www.microsoft.com/typography/fontpack/default.htm--]

Univ of Iowa, VBA and Excel

[--http://www.bo.uiowa.edu/~ap-po/npovi/--]

Uppercase

[--proper.htm#upper--]

UseFormula

[--formula.htm#useformula--]

Usenet References

[--http://www.landfield.com/usenet/--]
information on What is, Resources, Moderation, FAQs, Netiquette, Usenet Software, etc.

USENET,A Primer on How to Work With the USENET Community

[--http://www.uea.ac.uk/cpc/comms/newswork.htm--]
thread is to try keep posting sizes down.

Using a Custom Button to activate a footer

[--pathname.htm--]

VBA and Excel at Univ ofIowa

[--http://www.bo.uiowa.edu/~ap-po/npovi/--]

VBA Progress Bar

[--http://groups.google.com/groups?oi=djq&ic=1&selm=an_490397177--] also see
Control the LED Display in the StatusBar [http://www.j-walk.com/ss/excel/files/developer.htm]

VBA, OfficeVBA.com, Ken Getz etc.

[--http://www.j-walk.com/ss/excel/files/developer.htm--]

Version of Excel

[--http://groups.google.com/groups?oi=djq&ic=1&selm=an_568933935--]
=INFO("version_excel") or in VBA as application.version, or
ExcelVersion = "Excel version " & Application.Version & ", build " & Application.Build

Viewer for Excel, "Excel 97/2000 Spreadsheet File Viewer"

[--http://office.microsoft.com/2000/downloaddetails/xlviewer.htm--]

WE1277: XL7:Visual Basic Equivalents for Lotus Macro Commands

[--http://support.microsoft.com/default.aspx?scid=kb;en-us;Q148240--]

What's New

[--whatsnew.htm--]

What's New (David McRitchie)

[--whatsnew.htm--]

What's New (Chip Pearson)

[--http://www.CPearson.com/whatsnew.htm--]

Woody's Office Watch

[--http://www.wopr.com/wow/wowarch.htm--]

Windows
Start, Excel shortcuts in folder accessible from START (frequently used files).

WORD, some information for WORD Users

[--http://x64.deja.com/=dnc/qs.xp?ST=PS&QRY=&subjects=&groups=*excel*&authors=DMcRitchie%20%6Dsn.com&fromdate=06%2F08%2F00&todate=06%2F08%2F00&defaultOp=AND&DBS=1&OP=dnquery.xp&LNG=ALL&svcclass=dnserver&showsort=date&maxhits=100&format=terse&uniq=960481934.2087124996--]

WordCount

[--wordcnt.htm--]

Worksheet Functions and VBA, HELP (onsite)

[--wsfunct.htm--]

Worksheet Name Tabs, Sorting Sheets in Workbook

[--http://groups.google.com/groups?oi=djq&ic=1&selm=an_489871760--]
macros to sort and list sheets found in workbook,
also see Q105069

[--http://support.microsoft.com/default.aspx?scid=kb;en-us;q105069--].  Also see related topics BuildTOC -- Build Table of Contents

[--buildtoc.htm--], Enumerateaddins, Enumeratesheets, and Q142126 -- XL: Looping Through Worksheets

[--http://support.microsoft.com/default.aspx?scid=kb;en-us;q142126--].  Particularly for those who have XL2000 see BuildTOC (Build Table of Contents)

[--buildtoc--] emcompassing all of the above, and similar listings for Subroutines and Functions.

Worksheet VBA Coding

[--sheets.htm--]

Wotsits Format file extension, supplyextension to obtain software manufacturer's site

[--http://www.wotsit.org/--]

XL to HTML related http://faculty.uvi.edu/cbalch/cis.htm

[--http://faculty.uvi.edu/cbalch/cis.htm--]

XL2HTML -- Excel to HTML conversions and links ***

[--xl2html.htm--]

XL2HTML simple convert

[--http://www.herber.de/mailing/020598v.txt--]
(under 30 lines of code).  I used this simple convert for several of my examples.  The simple conversion will process a preselected range, uses an InputBox to be able to change the output file.  It will also place <tb>&nbsp;</tb> when needed for empty cells

XL2HTML-Konverter for XL5/7

[--http://www.herber.de/free/hwhkonv.zip--]

XL2HTML-Konverter for XL5/7in german language -- hwkkonv.zip

[--http://www.herber.de/free/hwhkonv.zip--]
simple conversion to HTML without fonts, alignment etc.

xlconstants, Q112671, Built-in Constants in Visual Basic for Applications" (WC0993)

[--http://support.microsoft.com/default.aspx?scid=kb;en-us;q112671--]
also note use of PF2 in the Visual Basic Editor

Yahoo Search

[--http://www.yahoo.com/search.htm--]

This is an example of Laurent Longre http://longre.free.fr/   [translate French to English] -- hard to believe you are looking at a machine generated translation, watch out for coding.

More information, if any, will be included on my language.htm page.

Visit [my Excel home page]   [Index page]   [Excel Onsite Search]   [top of this page]

Please send your comments concerning this web page to: David McRitchie send email comments

Copyright © 1997 - 2004,  F. David McRitchie,  All Rights Reserved