Excel: format data options shortcuts

Luis Diaz
Luis Diaz used Ask the Experts™
on
Hello Experts,

I am trying to understand how does it works shortcuts for excel format data options
 Format-data-options.pngI see that most of the options contains an underline for a letter however I type alt + the letter and it doesn't work.
I also try alt + shift and I have the same result.
Could you please advice?
Thank you in advance for your help.
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Roland LeeSenior Systems Engineer

Commented:
Hi there,

Press "Shift" then followed by the letter of the option that you want.

Thanks,
Roland
Karen FalandaysTraining Specialist

Commented:
Oh my, I see you are working in charts and you may have unearthed a legacy tool that was not updated with O365. It does appear that there are no shortcut keys to launch those commands! Stay tuned, if an expert can find it, it will appear here!
IT / Software Engineering Consultant
Top Expert 2016
Commented:
Those are activated with a special key (like the windows logo key, but different) on more recent keyboards.  If you have the key shown below press it and then also press the shortcut letter from those panels.


sshot-629.png

»bp
Ensure you’re charging the right price for your IT

Do you wonder if your IT business is truly profitable or if you should raise your prices? Learn how to calculate your overhead burden using our free interactive tool and use it to determine the right price for your IT services. Start calculating Now!

Karen FalandaysTraining Specialist

Commented:
Yea...no
Luis DiazIT consultant

Author

Commented:
Thank you for your feedback.
I tried shift and drop down keys as proposed but it doesn't work. I would like to make some research but I don't know the exactly name of this right menu display in excel.
Do you know how do we call it:?
right-menu-bar.png
Bill PrewIT / Software Engineering Consultant
Top Expert 2016

Commented:
I don't know what that key is called, and honestly it seems to be very 'fragile' in how it behaves.  You have to click a character very soon after depressing it.

You can play around with it using the On-Screen Keyboard.  Open that, and with the mouse left click and hold that "drop down list" key and quickly tap one of the underline characters in the sidebar you asked about on your physical keyboard (naturally you have to have that open and have focus in an option there with choices underlined).  If you catch it just right it will take you to that option, and if it's a checkbox it will toggle it.

I had to use the On-Screen Keyboard with my desktop since it's keyboard doesn't have that special key.  But on my newer laptop it has that key and I can just use it like a "shift" key on the laptop keyboard and press it and a letter together to get the same effect.  It really does work, honest...


»bp
Roland LeeSenior Systems Engineer

Commented:
You just need the "Shift" key followed by the letter being underlined, no down arrow key is required.

Assuming if you need the "Transparency" function, just press "Shift" + "T". this should activate the mentioned function.
Luis DiazIT consultant

Author

Commented:
Thank you all for your comment. @Roland the "Shift" key works as soon as the plot area is in active mode however this is the difficulty.
In the following example I type "Shift" + "A" to modify the field I got a A in the text zone. I need to find a shortcut to activate the plot in and then use the shortcut. Could you please advice on this.
Thank you in advance for your help.

Plot-Area.png
Roland LeeSenior Systems Engineer

Commented:
The option that you've selected "Shift + A" is invalid, this will put an "A" in your cell. What are you trying to accomplish? Kindly be more specific.
Bill PrewIT / Software Engineering Consultant
Top Expert 2016

Commented:
Did you try using the special key I mentioned, or does your keyboard not have that?


»bp

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial