Excel Spreadsheets Shortcuts and Instructions for Jaws Screen Reader

Excel Spreadsheets Shortcuts and Instructions for Jaws Screen Reader

Reading Cells.

List cells in current column.   Jaws Key Shift C.

Read Column Total.   Insert + Numpad Enter.

List cells in current row.   Jaws Key Shift R.

Read row total.   Insert + delete.

Say formula.   Control F2.

Say contents of focus rectangle.   Insert N.

Say cell format.   Insert F.

Say Column Title.  Jaws Key  Alt Shift C.

Say Row Title.   Jaws Key Alt Shift R.

Create Title in Name Manager. Make sure you are in cell where column and row titles cross (Like A1) Press Control + F3 to open name manager. tab to new and press enter. New name box will open. Type “Title1” with no spaces then tab to ok and press enter. You will be back in the name manager box. Tab to close and press enter. now when you navigate through the columns and rows they will speak the titles as you change from row to column. Email me for how to name just a column or a row!

Worksheets.

List worksheets.   Control Shift S.

Next Worksheet.   Control page down.

Previous worksheet.   Control page up.

Rename Worksheet.   Format Menu, Sheet, Rename, type new name, Enter.

Selecting cells.

Select column.   Control spacebar.

Select row.   shift + spacebar.

Select region.   Control Shift 8.

Movement keys.

Go to cell.   F5 key then enter cell reference.

Start of worksheet.   Control Home.

End of worksheet.   Control End.

Start of row.   Home.

Entering data.

Enter data and move to next cell.   Enter or Tab or arrow keys.

Start a new line in the same cell.   Alt + enter.

Enter todays date.   Control  plus semicolon.

Editing.

Edit existing cell.   F2.

Fill down.   Select cells to be filled then Control  + D.

Fill Right.   Select cells to be filled then Control + R.

Insert a row.   Select row below,  application key, select insert.

Insert a column.   Select column to left, application key, select insert.

Delete a column.   Select column, application, select delete.

Delete a row.   Select row, application key, select delete.

Formula.

Say formula.   Control F2.

Autosum.   Alt =.

Formula input model.   =.

Paste a function into a formula.   Shift + F3.

Fill down a formula.   Select cells first including formula then Ctrl D.

Fill across a formula.   Select cells first including formula then Ctrl R.

Fill a Series, date, sequence.   Select cells first including start of series, then menu option Edit, select Fill, select Series, then Alt F for Autofill option, press Enter.

Formatting.

Say cell format.   Insert F.

Format Cells Dialog box.   Control plus 1.

Apply currency with 2 decimal places.   Control Shift $.

Apply number format with2 decimal places.   Control Shift 1.

Apply outline border.   Control Shift 7.

Remove outline border.   Control Shift _.

Copy format.   Control Shift C.

Paste format.   Control Shift V.

Header and Footer in Excel.

Place cursor in either the left, center or right section and type any of the following codes.

Filename code.   &[File].

Sheet code.   &[Tab].

Date code.   &[Date].

Pathname code.   &[Path].

Page No code.   &[Page].

Total no of pages code.   &[Pages].

Creating a macro for repetitive commands in Excel using Jaws

A macro is either a shortcut for a series of commands which you may do on a regular basis.  For example you may regularly want to add your name as a footer on a spreadsheet page and make the print fit to one page and perhaps vertically and horizontally center it.  This involves a series of commands.  You can create a macro which will carry out all these commands with just one command which you can apply as a keyboard shortcut or an icon or a menu item.

Creating a macro

Most macros are relative therefore it is best to make sure your cells are in the correct cells before you start creating your macro, so that you do not record the steps of moving cells when you start recording the macro.  Also it is best to practice the steps that you plan to take when you are creating a macro as it records all steps including your mistakes.

As Jaws users already have so many keyboard shortcuts to remember it is advisable not to apply keyboard shortcuts to individual macros and instead use short macro names which can be accessed in the Macro dialog box using Alt F8 which is the same for Word and arrow down and select the individual macros.

• To create macros in Excel 365 using JAWS, follow these steps:
  1. Press Alt+F8 to open the Macro dialog box.
  2. Use the Tab key to move to the “Macro name” field. Type a name for your macro.
  3. Press Tab to move to the “Create” button, then press Enter. This opens the Visual Basic for Applications (VBA) editor.
  4. In the VBA editor, you can write or record your macro code. If you want to record actions instead of writing code, close the VBA editor and use the following steps:
     • Press Alt+L to open the Developer tab (if the Developer tab is not visible, you may need to enable it in Excel Options).
     • Press R to select “Record Macro.”
     • Follow the prompts to name your macro and assign a shortcut key if desired.
     • Perform the actions you want to record.
     • When finished, press Alt+L, then S to select “Stop Recording.”

  JAWS will announce dialog options and fields as you navigate.

  Playing back the Macro.

Make sure the cells you want to apply a command to are selected.

Press Alt F8, arrow down through the list of macros.  Press Enter to start the macro