If you are using the JAWS Virtual Ribbon menus, the Define Name split button is on the lower ribbon in the Defined Names group of the Formulas tab.įocus is in the Name edit box.

Press ALT+M to move to the Formulas tab of the ribbon, followed by M for Define Name.This is the intersection for the column and row headers for the budget range. First, press CTRL+G and type A7, and then press ENTER to move there.The intersection of the row and column headers is in cell A7. The range for the budget sample is A5:G23. In the practice document there is one range of cells to use for this exercise. If the file opens in compatibility mode, press ALT+F, then I, and finally E to turn off compatibility mode. If you create workbooks, you can make them much more accessible for JAWS and MAGic users by defining the row and column headers during the document creation process.ĮXERCISE: Open the practice file BudgetSample.xlsx Opens in MS Excel and follow along with the instructor as you practice creating column and row headers in an Excel workbook. Furthermore, anyone can build these row and column names into a workbook without even installing or using JAWS or MAGic. If the titles are defined in this fashion, the information is stored right in the workbook rather than in a JSI file and can be used to speak the title information to anyone using JAWS 6.1 and later or MAGic 12.0 or later. JAWS and MAGic look for certain specific names to identify which cells contain row and column titles. Microsoft Excel has a built-in function that can be used to give names to a cell or range of cells.

Creating Column and Row Titles that Read Automatically Using Excel's Built-In Naming Function (Created by the Document Author or End User) In this webinar we will use this newer method. Also, if you fail to put the JSI file in the correct folder on the computer hard drive where JAWS or MAGic can find it, headers will not read automatically.Īs you can imagine, the preferred method of creating titles that read automatically for all JAWS and MAGic users without having to worry about transferring a JSI file to the proper location on the computer for each workbook or for each version of JAWS and MAGic, is to use the Define Name feature of Excel. If that JSI file is not present, for example when a new version of JAWS or MAGic is installed, then JAWS or MAGic will not automatically recognize any column and row headers as titles. Titles created using JAWS Quick Settings dialog box - These titles are saved in a workbook-specific JSI file located in your personal settings folder, a separate file that is created and has to accompany the workbook everywhere it goes.In addition, the workbook can be shared easily among different users without having to re-create the headers or transfer an ancillary JSI (JAWS Script Initialization) file along with the workbook. The name is stored within the Excel workbook itself and is therefore independent of different versions of JAWS and MAGic. This uses a built-in feature in Excel and does not even require having JAWS or MAGic on the computer to create headers that automatically work for JAWS and MAGic users. They are created by the author or user of the workbook so that any subsequent use of the workbook does not require that you or anyone else need to define them. This is the newest method of creating headers for column and row titles. Titles created using the Define Name feature of Excel - These titles are part of the Excel file itself.JAWS® screen reader and MAGic® screen magnification programs are capable of recognizing column and row headers as titles under two types of conditions: When this is done, the headers for the rows and columns remain on the screen as the user scrolls horizontally or vertically through the workbook. Sighted users often lock the row and column headers into place by using the Freeze Panes option from the Window menu in earlier versions of Excel, or the View tab of the ribbon in later versions of Excel. Those who use Microsoft® Excel® on a regular basis know how quickly one can get lost in a workbook without the use of row and column headers. NOTE: For those of you participating in the live Webinar, the following link will open the documentation in a new browser window Opens in a new window. Column and Row Headers in Excel with JAWS and MAGic Column and Row Headers in Microsoft Excel with JAWS and MAGic

Make columns into rows in excel for mac