locked Renaming or moving sheets in Excel


Sandra Pilz
 

Hi,


When using JAWS or Narrator in Excel, once you have opened a file, you can press f6 to see the name of the current sheet, to see other sheets in the file , rename it or select another sheet. When using NVDA, pressing f6 does nothing.


Is there another way to get to the sheet list in NVDA?


I use Office 365 and NVDA 2020.4.


Regards


Sandra


Vaibhav Saraf
 

Hi,

To rename a sheet use - Alt + H, O, R - commands in specified sequence. A modal will open up, you can provide a new name and hit Enter.

To move or duplicate, use Alt + E, M - you can schoose to move current sheet ahead of any other sheet, or check the checkbox to create a copy at any specified spot.

Hope that helps.
Thanks,
Vaibhav


On Sat, 12 Jun 2021 at 15:32, Sandra Pilz <sandra914481@...> wrote:

Hi,


When using JAWS or Narrator in Excel, once you have opened a file, you can press f6 to see the name of the current sheet, to see other sheets in the file , rename it or select another sheet. When using NVDA, pressing f6 does nothing.


Is there another way to get to the sheet list in NVDA?


I use Office 365 and NVDA 2020.4.


Regards


Sandra


Sandra Pilz
 

Hi Vaibhav,


Thank you for your reply, I'm glad to hear that it works.


Unfortunately, I can't work with your specified sequence of keys, because my Windows and Office are in German, so the key sequence would be different, too. Could you please let me know what the keys stand for? Then I could look for the respective sequence in my version of Office.


Thank you


Regards


Sandra



Am 12.06.2021 um 12:30 schrieb Vaibhav Saraf:

Hi,

To rename a sheet use - Alt + H, O, R - commands in specified sequence. A modal will open up, you can provide a new name and hit Enter.

To move or duplicate, use Alt + E, M - you can schoose to move current sheet ahead of any other sheet, or check the checkbox to create a copy at any specified spot.

Hope that helps.
Thanks,
Vaibhav


On Sat, 12 Jun 2021 at 15:32, Sandra Pilz <sandra914481@...> wrote:

Hi,


When using JAWS or Narrator in Excel, once you have opened a file, you can press f6 to see the name of the current sheet, to see other sheets in the file , rename it or select another sheet. When using NVDA, pressing f6 does nothing.


Is there another way to get to the sheet list in NVDA?


I use Office 365 and NVDA 2020.4.


Regards


Sandra


Vaibhav Saraf
 

Hi Sandra,

For renaming a sheet:

Alt + H stands for 'Home' tab in the ribbon.
'O' stands for Format which is found under Cell styles group which is a sub-group of Styles under Home.
'R' is for 'Rename Sheet' which will come down in the list after activating the Format menu.

For moving, I have no idea what Alt + E is for, pressing that hotkey just places me on the Home tab, I think probably its tab is hidden right now in my ribbon. I will try to search on that and come back if I am able to figure that out.
Alt + E generally contains commands to copy, paste, delete, etc.

I found one thread in the Microsoft community which suggests that you can use Office in German language with just the ribbon in English, maybe it will help you. Caution: Moving to English ribbon will also change other shortcuts for you, which you may already feel comfortable with in the German version.

Thanks,
Vaibhav
 


On Sat, 12 Jun 2021 at 17:02, Sandra Pilz <sandra914481@...> wrote:

Hi Vaibhav,


Thank you for your reply, I'm glad to hear that it works.


Unfortunately, I can't work with your specified sequence of keys, because my Windows and Office are in German, so the key sequence would be different, too. Could you please let me know what the keys stand for? Then I could look for the respective sequence in my version of Office.


Thank you


Regards


Sandra



Am 12.06.2021 um 12:30 schrieb Vaibhav Saraf:
Hi,

To rename a sheet use - Alt + H, O, R - commands in specified sequence. A modal will open up, you can provide a new name and hit Enter.

To move or duplicate, use Alt + E, M - you can schoose to move current sheet ahead of any other sheet, or check the checkbox to create a copy at any specified spot.

Hope that helps.
Thanks,
Vaibhav


On Sat, 12 Jun 2021 at 15:32, Sandra Pilz <sandra914481@...> wrote:

Hi,


When using JAWS or Narrator in Excel, once you have opened a file, you can press f6 to see the name of the current sheet, to see other sheets in the file , rename it or select another sheet. When using NVDA, pressing f6 does nothing.


Is there another way to get to the sheet list in NVDA?


I use Office 365 and NVDA 2020.4.


Regards


Sandra


Sandra Pilz
 

Hi Vaibhav,


Thank you for your description of the key sequence.


Please don't spend any time on researching alt+e, I think I know what the equivalent is.


Also thanks for the link. Setting my ribbon to English is not something I want to do, as you said, it changes the key sequences I am familiar with and it would also make communication with other colleagues about Word more difficult. :)



Thank you.


Regards


Sandra

Am 12.06.2021 um 15:22 schrieb Vaibhav Saraf:

Hi Sandra,

For renaming a sheet:

Alt + H stands for 'Home' tab in the ribbon.
'O' stands for Format which is found under Cell styles group which is a sub-group of Styles under Home.
'R' is for 'Rename Sheet' which will come down in the list after activating the Format menu.

For moving, I have no idea what Alt + E is for, pressing that hotkey just places me on the Home tab, I think probably its tab is hidden right now in my ribbon. I will try to search on that and come back if I am able to figure that out.
Alt + E generally contains commands to copy, paste, delete, etc.

I found one thread in the Microsoft community which suggests that you can use Office in German language with just the ribbon in English, maybe it will help you. Caution: Moving to English ribbon will also change other shortcuts for you, which you may already feel comfortable with in the German version.

Thanks,
Vaibhav
 


On Sat, 12 Jun 2021 at 17:02, Sandra Pilz <sandra914481@...> wrote:

Hi Vaibhav,


Thank you for your reply, I'm glad to hear that it works.


Unfortunately, I can't work with your specified sequence of keys, because my Windows and Office are in German, so the key sequence would be different, too. Could you please let me know what the keys stand for? Then I could look for the respective sequence in my version of Office.


Thank you


Regards


Sandra



Am 12.06.2021 um 12:30 schrieb Vaibhav Saraf:
Hi,

To rename a sheet use - Alt + H, O, R - commands in specified sequence. A modal will open up, you can provide a new name and hit Enter.

To move or duplicate, use Alt + E, M - you can schoose to move current sheet ahead of any other sheet, or check the checkbox to create a copy at any specified spot.

Hope that helps.
Thanks,
Vaibhav


On Sat, 12 Jun 2021 at 15:32, Sandra Pilz <sandra914481@...> wrote:

Hi,


When using JAWS or Narrator in Excel, once you have opened a file, you can press f6 to see the name of the current sheet, to see other sheets in the file , rename it or select another sheet. When using NVDA, pressing f6 does nothing.


Is there another way to get to the sheet list in NVDA?


I use Office 365 and NVDA 2020.4.


Regards


Sandra


Howard Traxler
 

It seems that the F6 key moves between open files.  The file you are moving to is announced.

On 6/12/2021 5:02 AM, Sandra Pilz wrote:

Hi,


When using JAWS or Narrator in Excel, once you have opened a file, you can press f6 to see the name of the current sheet, to see other sheets in the file , rename it or select another sheet. When using NVDA, pressing f6 does nothing.


Is there another way to get to the sheet list in NVDA?


I use Office 365 and NVDA 2020.4.


Regards


Sandra


Howard Traxler
 

Moving between sheets in a file is done with ctrl+PgDn.  The name of the newly arrived sheet is announced.  Is that still correct?  I'm using an older version of Excel.

On 6/12/2021 5:02 AM, Sandra Pilz wrote:

Hi,


When using JAWS or Narrator in Excel, once you have opened a file, you can press f6 to see the name of the current sheet, to see other sheets in the file , rename it or select another sheet. When using NVDA, pressing f6 does nothing.


Is there another way to get to the sheet list in NVDA?


I use Office 365 and NVDA 2020.4.


Regards


Sandra


 

A couple of bits here, some of direct help, some from a moderator's standpoint.

1.  The keyboard shortcuts for ANY Microsoft product in ANY language it happens to be translated to can be found with a simple web search provided it's being done from the location that is appropriate to the regional language being discussed.  If I search here in the USA, I always end up in the part of support.microsoft.com that's followed with "en-us" (English, United States).  I seem to recall when once playing with a VPN to fake being in a completely different country that searches such as this would bring me in to Microsoft's support pages for the correct language and region.  In the case of Office for the USA, the links to the shortcuts for all the Office suite here:

Keyboard shortcuts in Office - support.microsoft.com
or just Excel here:

Keyboard shortcuts in Excel - Office Support

If I am incorrect about that, then would someone please report how they get to the Microsoft Support pages for their specific region and language?

2. This is the perfect example of a question that is not about NVDA.  It's about Excel.  There's not a blessed thing that's NVDA specific about it.  Thus, this sort of question should be asked either on the Chat Subgroup or elsewhere.  Our group description states:
The central purpose of this group is discussing how to use NVDA. This includes configuring NVDA's settings or familiarizing oneself with its modes and commands.  Discussions about which programs are accessible using NVDA, NVDA add-ons, NVDA tutorials and documentation, and configuring synthesizers or Braille displays for use with NVDA are also permitted.
and our group rules state:
It is presumed that the majority of members will be using NVDA, and possibly other screen readers, as part of their daily routine.  This being the case, before you post a message you have to consider whether the question you are about to ask is actually about NVDA itself, or about the program you’re using it to access.  Questions of the form, How do I use . . . with NVDA?, are very seldom about NVDA, but are almost always about the program being accessed with NVDA.

And I actually expect people to pay attention to both.  If the question is really not about NVDA or really closely related stuff like configuring things like braille displays to work with it, or the accessibility of a given program with it, it doesn't belong on this group.

I am asking, directly, that people think before they post and choose the venue that is appropriate for the question they're about to ask.  Those who want to answer non-NVDA questions, and I'm among them, are participants in those venues.  But the folks who elect to participate only here have made it clear that the strong preference is for sticking with NVDA-centric discussions.

Any further discussion about Excel should be taken to the Chat Subgroup, or, if you prefer, to the Microsoft Office Accessibility Discussion Group.  Here are the addresses:
Chat Subgroup:

Microsoft Office Accessibility Discussion Group:


This topic is now locked.

--

Brian - Windows 10, 64-Bit, Version 21H1, Build 19043  

I do not understand why some seek to separate a person from their actions.  The self is composed of an individual’s thoughts, actions, and expression, which are contained in and actuated by the body.  What you do and say is the clearest indicator of who you are.

      ~ Brian Vogel