moderated Re: Excel rows and columns
First I have to get it to work in the first place. For some reason I can’t get automatic readings of row and column headings to work using this method at all.
I already have a template of this workbook set up and I usually just open it each time a new month starts and then use F12 to save it but giving it the name of the month.
For example, my template is Sales Summary and I then save it, for example, as Sales Summary June 2019.
I wouldn’t mind setting up the row and column title reading on each sheet separately if I could just get it to work.
From: firstname.lastname@example.org <email@example.com> On Behalf Of Russell Solowoniuk
Sent: Sunday, June 9, 2019 7:38 AM
Subject: Re: Excel rows and columns
I’m not able to set this up by defining a name on a worksheet and then copying that sheet multiple times. Even if I set the scope to the worksheet rather than the workbook, Jaws doesn’t read column or row headings on the next sheets.
What you want can be done easily manually by first creating copies of your first sheet 31 times, one sheet for each day of the month. Then, place your cursor in the cell of the first sheet where you want to define the name, press the applications key, up arrow to “Define name…” and press enter. Type “Title” if you wish both column and row headings to be read by Jaws and press enter. Now, move to sheet two and do the same, except this time type “Title2” as the name. Continue doing this on subsequent sheets, each time increasing the number after “Title”. Note that there is no space between “Title” and the number.
Not sure if this helps or if you wanted a more automatic method, but I can’t seem to do it any other way. I even tried grouping the sheets and then defining a name, but this doesn’t work.
I attached a little sample spreadsheet I made. I thought I followed your steps to set it up so Jaws will read the column and row titles, but I can’t get it to work, what am I doing wrong?
Pardon my error, that last technique is the "when I only want it during this session" method with JAWS. This is how to set them in the spreadsheet itself such that JAWS will recognize their existence and announce them whenever you open a specific spreadsheet:
Assigning a Title Row (Column Titles) and/or Title Column (Row Titles) in Excel
You can assign column and row titles in Excel. These are nice because they always work with Excel and are saved to the workbook. There's no risk of losing a setting in your screen reader.
To add column and row title names:
i. Open the Formula ribbon (ALT-M)
ii. Activate the “Define Name” command (M)
iii. Within the drop-down list, activate “Define Name”
iv. The “New Name” dialog opens
Focus is placed in the name field. Within the name field, you can name the focused cell or selected range of cells. In this case, we’re naming the column or row title:
i. Start the range name with the label that tells Excel you’re creating a title range
ii. Add a name for the range
iii. Optional - Add the last cell in the range preceded by two periods
The next field in the dialog sets the scope for the name. this is a combo box. Use UP and DOWN ARROW to choose from between:
You can add a comment for the named cell or region, this is strictly for your personal reference and doesn’t affect the echo of the column or row title name
The last field references the cell name or range of selected cells you’re naming. You can leave this field alone.
Activate the OK button to save the name and close the dialog.
Save the workbook and the titles are permanently saved and will work on any computer.
If you have titles set to echo in JAWS, the titles will echo and you won’t lose the settings.
Brian - Windows 10 Pro, 64-Bit, Version 1809, Build 17763
Here is a test to find out whether your mission in life is complete. If you’re alive, it isn’t.
~ Lauren Bacall