Shortcut Keys in XL95 (Excel Version 7)

Rather than just telling you to create a Shortcut keys sheet in an Excel file I decided to show you what mine looks like.  You should create your own, of course.

Creation of Shortcut keys spreadsheet

Shortcuts are entirely optional.  In XL95 a shortcut key can be assigned to a macro using: Tools --> Macro --> (select a macro) --> Options.  Excel will Warn you if you attempt to utilize a short cut key already in use -- it will change the form of assignment for instance.  You will have to remember them or write them down somewhere.  I highly recommend creating a sheet for your MS Excel installed shortcut keys so that you can use FIND to find a shortcut yourself.   You could even add your own at the bottom.  Also recommend creating another sheet for function keys.

Create your table of builtin shortcut keys as follows:

• HELP --> Index --> Shortcut keys --> built-in keyboard shortcuts
• copy and paste each category into a ShortCutKeys spreadsheet
• Put topics in Red 12 point bold font, the rest Black 10 point Normal (all Arial)

An alternative to a shortcut key is a Toolbar menu item, which in XL95 is entered on the same window as where a shortcut key is assigned. (see above)

I have assigned a short-cut key [Ctrl+k] or a tool bar menu item [* XL2HTML - simple conversion*] to some of the macros I wrote or use.

Calculate and recalculation

Application.Calculate	calculates all open workbooks.
Range.Calculate	calculates the specified range
F9	Calculates all sheets in all open workbooks.
Ctrl+F9	(Minimize the worksheet)
Shift+F9	Calculate the active worksheet.
Ctrl+Alt+F9	Recalculates all cells on all worksheets in all open workbooks.

The common thread running through all but Ctrl+Alt+F9 of the above is that the recalculation occurs *only* on the cells that the Excel calculation engine thinks are dirty.

Since the calculation engine occasionally gets this wrong, we also have
Ctrl+Alt+F9 which forces a recalculation of *everything* in all open workbooks whether or not Excel *thinks* recalculations are needed.

Recalculate all open cells, worksheets, and workbooks
To recalculate all cells on all worksheets in all open workbooks, press CTRL+ALT+F9

Note   Recalculation of all formulas may take considerable time.  To recalculate only the current worksheet, press SHIFT+F9

Warning:  This is one way to learn that the A1 or other cell reference in the formula =CELL("filename",A1) really is needed.  Without the cell reference, recalculate will cause the active worksheet to appear instead of the name of the worksheet where the formula resides.  Another problem with displaying the active sheet instead of the sheet with the formula would be using
    SheetName = ActiveSheet.Name instead of
    SheetName = Application.Caller.Parent.Name
Reference to article posted by John Green.

If you have XL97 and do not have SR-2, checkout   XL97 recalculation problem in the MS KB.

The following is from a posting by Tom Ogilvy (Jun 1, 1999) for code to simulate Ctrl+Alt+F9

Sub tester3()
Application.SendKeys "^%{F9}"
End Sub

Back when the recalc problem was so prevelant, some people mapped this
to the F9 key use
Application.onkey "{F9}","xlmisc68.xls!Tester3"

John Walkenbach then reported that in XL2000 the Ctrl+Alt+F9 gets recorded as:
    Application.CalculateFull

For information on XL97 Recalculation patch for SR-1 see
  http://support.microsoft.com/default.aspx?scid=kb;en-us;Q174868
problem was corrected in XL97 SR-2.

Q224183 - XL2000: Certain Functions Calculate Differently in Early Versions of Excel
  http://support.microsoft.com/default.aspx?scid=kb;en-us;Q224183
Summary: When you use certain functions, you may receive a different value depending on the version of Microsoft Excel that you are using.

CalculateFull Method Example
  http://msdn.microsoft.com/library/officedev/off2000/xlmthcalculatefullx.htm
Summary: MSDN Library - Office Developer Documentation - Office 2000. Excerpt: CalculateFull Method Example This example compares the version of Microsoft Excel with the version of Excel that the workbook was last calculated in.

Auto_Open set to guarantee Calculation is turned on

I had trouble with Recalculation being turned off that I put code into Auto_Open to fix it.  Turned out that it was an Addin that I wasn't even using that was causing this.

    Sub auto_open()
      If Application.Calculation <> -4105 Then
         '-4105 automatic, -4135 manual, 2 semi-automatic
         MsgBox Application.Calculation & "  " & _
            ActiveWorkbook.FullName
         Application.Calculation = xlAutomatic
         MsgBox Application.Calculation
      End IF
    End Sub

Related Information

Working with disabilities:  Some documentation found in the Microsoft Knowledge DataBase (MS KB) for Windows 2000 looking for disabilities & mouse turns up some items of interest.

• Description of Windows 2000 Magnifier and Utility Manager Tools
• Microsoft Accessibility Home, information on working with disability, including visual disabilities (impaired, impairment, sight).
  Accessibility:   [Features]  [Index]  [Newsletter]  [Search]
• Keyboard Assistance Shortcuts for Win95, Win98, WinNT, choose the Word (.doc) version.
• Also see Excel Help (or the Help in any Office Product), answer wizard:  Accessibility for people with disabilities.

Additional sites on disability and workplace environment

• IBM Accessibility Center --
     [Search tips] - "Phrases" plus(+) minus(-),
     [Laws]  [Learning Disabilities]
• Macintosh (Apple) Disability Solutions

How to install/use a macro can be found on my formula page.

Origin of Excel Worksheet Function Names Descriptive summary of functions and how they were named.  - by janma, (the rest of his Excel site, "Excel Skill Training Hall", is in Japanese).

Additional Related Items

Keyboard Shortcuts for Windows

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