moderated Re: Excel rows and columns
Marty Hutchings
Or, Here is the quick and durty way to get JAWS to read the row
and columb titles.
1. Place the curser at the beginning of the row and at the top of the
columb that you want spoken.
2. To get Jaws to say the row titles, press and hold Insert, Alt,
Control and press R.
3. To get Jaws to say the columb titles, press and hold Insert, Alt,
Control and press C.
It is a bit like playing finger twister, but it works.
Love in
Christ
Marty For our struggle is not against flesh and blood, but against the rulers, against the powers, against the world forces of this darkness, against the spiritual forces of wickedness in the heavenly places. Therefore, take up the full armor of God, so that you will be able to resist in the evil day, and having done everything, to stand firm. Ephesians 6:12, 13
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
|
|