Excel: format data options shortcuts

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.
LVL 1
LD16Asked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Roland LeeSenior Systems EngineerCommented:
Hi there,

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

Thanks,
Roland
Karen FalandaysTraining SpecialistCommented:
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!
Bill PrewIT / Software Engineering ConsultantCommented:
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

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Price Your IT Services for Profit

Managed service contracts are great - when they're making you money. Yes, you’re getting paid monthly, but is it actually profitable? Learn to calculate your hourly overhead burden so you can master your IT services pricing strategy.

Karen FalandaysTraining SpecialistCommented:
Yea...no
LD16Author 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 ConsultantCommented:
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 EngineerCommented:
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.
LD16Author 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 EngineerCommented:
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 ConsultantCommented:
Did you try using the special key I mentioned, or does your keyboard not have that?


»bp
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Excel

From novice to tech pro — start learning today.