Accessibility for visually impaired individuals: incrementing
Solved
zaza
-
isa -
isa -
Hello,
I would like to know if there is a keyboard shortcut to access incrementing without the fill handle (for non-sighted individuals: no mouse)
Thank you!
Configuration: Windows / Chrome 56.0.2924.87
I would like to know if there is a keyboard shortcut to access incrementing without the fill handle (for non-sighted individuals: no mouse)
Thank you!
Configuration: Windows / Chrome 56.0.2924.87
5 réponses
Hello
A blind person, by definition, cannot see what is happening around them, and all information visible on a screen is conveyed to them through a special keyboard equipped with braille keys. This keyboard has two functions: one for typing text like a regular keyboard, and the other is to relay the description of what is displayed on a screen to the keys. Since the person cannot visualize an image, a specific program describes the content of the screen line by line, and they only need to move their hands over the keyboard to "see" what is displayed on the screen. Therefore, a table cannot have the same structure as on a screen, and what you are asking does not seem feasible to me. But technology has made much progress; perhaps more advanced keyboards exist. I think it would be wiser to turn to an association of blind or visually impaired people who can direct you to a specialized computer scientist better able to provide you with an answer.
Best regards
A blind person, by definition, cannot see what is happening around them, and all information visible on a screen is conveyed to them through a special keyboard equipped with braille keys. This keyboard has two functions: one for typing text like a regular keyboard, and the other is to relay the description of what is displayed on a screen to the keys. Since the person cannot visualize an image, a specific program describes the content of the screen line by line, and they only need to move their hands over the keyboard to "see" what is displayed on the screen. Therefore, a table cannot have the same structure as on a screen, and what you are asking does not seem feasible to me. But technology has made much progress; perhaps more advanced keyboards exist. I think it would be wiser to turn to an association of blind or visually impaired people who can direct you to a specialized computer scientist better able to provide you with an answer.
Best regards
Thank you for your response.
It should be noted that my colleague uses both a Braille keyboard and the computer keyboard. Additionally, she works on spreadsheets and uses common keyboard shortcuts. However, there is only this functionality that does not have it. Hence my question.
Thank you and I will continue my research.
It should be noted that my colleague uses both a Braille keyboard and the computer keyboard. Additionally, she works on spreadsheets and uses common keyboard shortcuts. However, there is only this functionality that does not have it. Hence my question.
Thank you and I will continue my research.
Hello
I don't know if this can be useful or not, but to "fill" a formula table without dragging the cell, you can:
best regards
I don't know if this can be useful or not, but to "fill" a formula table without dragging the cell, you can:
- type the address of the field to be processed in the box to the left of the formula bar (where the address of the selection appears, for example type A2:A100)
- enter the formula that corresponds to the first cell
- press enter while holding down the ctrl key to fill the range all at once
best regards
Hello,
No known shortcut for me either.
I propose a macro that emulates incremental copying.
I can’t guarantee a complete emulation (do extensive testing) but I tried to get as close as possible.
Take into account the column on the left and right to extend.
Okay for inputs and formulas.
I set Ctrl+r as the shortcut, we can change it.
If the concept is acceptable, we could consider extending to other actions that give her problems.
I’ve added a voice feedback that announces the destination range or “no copy” if it couldn’t take place (the lady speaks English and very quickly but we can remove that...)
It should be saved as an add-in macro (*.xlam) to have it available automatically as soon as Excel starts.
https://mon-partage.fr/f/nEfK1bKC/
eric
--
By continually trying, we eventually succeed.
So the more it fails, the more likely it is to work. (the Shadoks)
In addition to the thank you (yes, it happens!!!), remember to mark as resolved. Thank you.
No known shortcut for me either.
I propose a macro that emulates incremental copying.
I can’t guarantee a complete emulation (do extensive testing) but I tried to get as close as possible.
Take into account the column on the left and right to extend.
Okay for inputs and formulas.
I set Ctrl+r as the shortcut, we can change it.
If the concept is acceptable, we could consider extending to other actions that give her problems.
I’ve added a voice feedback that announces the destination range or “no copy” if it couldn’t take place (the lady speaks English and very quickly but we can remove that...)
It should be saved as an add-in macro (*.xlam) to have it available automatically as soon as Excel starts.
https://mon-partage.fr/f/nEfK1bKC/
eric
--
By continually trying, we eventually succeed.
So the more it fails, the more likely it is to work. (the Shadoks)
In addition to the thank you (yes, it happens!!!), remember to mark as resolved. Thank you.
Hello,
Thank you very much for this macro.
The test is done by selecting column B and it only works if column A is filled.
However, would it be possible to make the macro on the same column A, for example?
Let me explain; in column B I have other information and it is column A that we want to increment.
Thank you in advance for your help.
Thank you very much for this macro.
The test is done by selecting column B and it only works if column A is filled.
However, would it be possible to make the macro on the same column A, for example?
Let me explain; in column B I have other information and it is column A that we want to increment.
Thank you in advance for your help.
Hello,
it was just an example, you can call the macro from any cell in any sheet of any workbook.
If there is an issue, please drop the workbook with a description of the actions to take and the anomaly.
eric
PS: the source to copy can be a single cell but also a range, just like in the 'real world'.
it was just an example, you can call the macro from any cell in any sheet of any workbook.
If there is an issue, please drop the workbook with a description of the actions to take and the anomaly.
eric
PS: the source to copy can be a single cell but also a range, just like in the 'real world'.