Is there a shortcut that pulls up a list of shortcuts in excel?

Thought I had seen it mentioned before but can’t seem to find it now and all the lists I’ve found online don’t mention it.

TIA and sorry for the basic question!

likefunny
Posting as :
works at
You are currently posting as works at

Press the Alt key. From there, you'll see a bunch of "next step keys" (i.e. H = Home tab) appear in the ribbon. Takes a little practice, but fairly straightforward once you get the hang of it.

like

This. You’ll mostly learn the ones you use a lot, it’s an extremely efficient use of brain space. Also Shift-F10 opens the right-click menu (super useful for pivot tables).

For actual shortcuts (e.g. Ctrl-T to create a table), just Google “list of Excel shortcuts” and download the most complete one.

like

Tell me your dad got you the job without telling me your dad got you the job.

like

Maybe they’re referring to the royal family

smart

Also shift space and ctrl space to select rows and columns. Ctrl up and down and left and right to move (hold shift to select). Ctrl++ for autosum. Ctrl d to copy down selection.

like

Related Posts

Currently doing some ok work, but have a job offer with a 30% raise doing different work. Love the people where I'm at. Don't know the new team yet. What would you do?

like

I can’t remember where half of these bruises came from. (Not drinking too much, just clumsy, I guess.)

funnylike

I hung out with my brother at an extracurricular for one of his children and his and I was so proud of the type of supportive dad he is now. We grew up in a very tense and chaotic house. Happy to see him try to break generational trauma.

likeupliftingsmart

Best spot for classy cocktail dates in the city?

DM or comment below if anyone is looking for job change.. and interested to apply in LTI

Ps. Need minimum 3 yrs of experience

My son’s first birthday is coming up and my parents want to gift him $1k in a separate account under his name for him to use in the future. My husband and I make about $250 combined so but paying off student loans and a mortgage so don’t have much in assets. My parents only make $50-70k a year. We’re all pretty clueless about money. What would be the best way to invest in his future?

like

Looking for internal communications opportunities either remote or in the DC metro area. 10+ years of communication experience. Thanks!

like

Unpopular opinion: Hookup culture is wack.

likeuplifting

Hello Fishes !!

I am about to receive an offer from EY GDS for a role of a Business Analyst_Banking finance (Principal Consultant) with a CTC of 27 LPA (inclusive of 10% variable).

I am having 10.5 YOE. Is this grade relevant which they have offered, taking my YoE into account? How much i can negotiate upto in CTC front? I mean the highest slab of Principal consultant?

TIA

like

I'm having a cold streak where a bunch of my leads are choosing to stay in the sidelines to "ride out" the volatility. I'm literally seeing this with everybody, from prospects to existing clients.

like

Anyone interested in buying two tickets for the Stranger Things: Experience event tonight?

like

Hello! I am starting a Bible study devoted to teachers! This season has been hard, and I believe teachers need to be poured into so we’re able to pour into the kiddos.

It’ll be remote, and I was hoping it could be accompanied by an encouraging group message as well. Let me know if you are interested and we can find a way to connect!

likehelpful

Hey! Has any recently interviewed for a Solutions Architect role at AWS? If so, can you speak to the online assessment? How is it structured? How are the questions - “how would you describe yourself on a scale of 1-10?” Type questions? Thank you in advance for your help.

like

Advice requested: When you were a legal intern or a summer, what type of projects did you like best? What was most helpful to you when you received a new assignment? Anything you wish your mentor did/didn’t do? I’m working with my first ever intern and trying to structure projects so they know that the work is important and relevant to the business, and why, and to provide enough background info on the area of law so they don’t spin wheels on the basics. What else should I be doing?

likehelpful

How are the Verizon projects in Brillio?

like

Will be in Dallas later this week, and I will have some free time to explore. What are some good things to do, preferably close to downtown.

like

Looking for recommendations for the Douro River in Portugal! Restaurants, hikes, vineyards?

likesmart

I am consulting for a chain of hairdressers in Germany. It's incredible. They don't get employees! Question: what are the motivations of a stylist to apply for a job offer (different to salary and hours, that has already been analysed)?

like

Best world timer or which one do you like the most?

like

I have a first grader who has a 2 sec attention span. I have to use a scripted ELA curriculum with lots of talk but not much writing. She NEEDS to do something focused on the lesson. Any ideas? TIA

Additional Posts in Excel Genius

What is y'all's preferred clipping tool? One of my former companies had a great simple program that was only like $50 and worth every penny.
Snipping Tool just ain't cuttin' it (lol pun intended).

like

What are the most typical models you all build

likehelpful

Is there a way to consolidate non numerical data from multiple excel sheets into one master sheet?

like

I am having difficulties getting my (Return on ad spend) column displaying correctly. The source data is shown in currency but on the pivot table I am only seeing count and percentage options. Any help would be greatly appreciated.

Post Photo
like

Can you share the most useful formulae and built in automation features you have used with the latest version of excel?

like

At my old firms when I would be using excel and modeling using the font schemes (blue, green, black for hardcode, link, and formula) I could use the “control shift ;” to shift through the schemes. My new firm doesn’t do this. Does anyone know why the shortcut would be different and how I can add it back?

like

I’m trying to go back to the basics. How do you guys structure thoughts around identifying the correlation between 2 variables? A basic example: the number of steps I take in a day and the hours of sleep I got that night.

like

Just created my first macro! Super proud of myself! #humblebrag

likeuplifting

Any recommend courses (coursera, edx, etc.) people would recommend for user with intermediate experience with excel?

like

Is Macabacus or any other add-in actually worth it for Excel & PPT? In LMM - MM M&A roles.

likehelpful

Can I write a macro that will fill out a table of information based on cells that have comments on them? For example, if G12 has a comment, I want to pull text from that comment + data in A12.

like

Hey, tips for where to look for good excel cheat sheets online? :)

Whats a good book/course that will teach me advanced excel skills? I want to be quick with shorcuts etc & learn VBA/Macros. Under $30 please, input is greatly appreciated.

like

What's the F4 analogy in Office 365?

like

Last cell question. Some of my simple models are massive in file size because every tab has a last cell of ~XFD65. But I’m not using anything past ~U100. Continued.

like

Hey Geniuses! I apologize in advance if this question has been asked before, I'm new here and just trying to learn as much as i can. Does anyone know a great source to learn Macros for beginners. I would like to create one for work. I appreciate it

like

I want to create a heat map of when people are unavailable with day of week as the columns and hour of day as the rows. I have start times and end times, how can I use this data to create the map?

like

How do I stop excel from changing the cell reference to a different column each time I refresh the data pull?
The spreadsheet is connected to an API data pull. Each time I refresh the data it changes the cell reference (SCD_0010) to a different cell e.g. (SCD_0127). How can I stop this?

Post Photo
like

How do you all prepare for excel/financial modeling tests? Every firm is different, so I imagine there are multiple effective ways to get ready.

likehelpful

New to Fishbowl?

Download the Fishbowl app to
unlock all discussions on Fishbowl.
That was just a preview…
Sign Up to see all discussions
  • Discover what it’s like to work at companies from real professionals
  • Get candid advice from people in your field in a safe space
  • Chat and network with other professionals in your field
Sign up in seconds to unlock all discussions on Fishbowl.

Already a user?
Login here

Share

Embed this post

Copy and paste embed code on your site

Preview

Download the
Fishbowl app

See what’s happening in your industry
from the palm of your hand.

A phone with Fishbowl app

Send download link to your phone

OR

Scan your QR code to download
Fishbowl app on your mobile

By continuing you agree to Terms of Use and Privacy Policy.

Messaging rates may apply

Download app

Sign up for free to view this conversation on Fishbowl

By continuing you agree to Terms of Use and Privacy Policy

Already have an account? Log in

Sign up for free to continue using Fishbowl

By continuing you agree to Terms of Use(New) and Privacy Policy(New)
Messaging rates may apply

Already have an account? Log in

For account settings, visit Fishbowl on Desktop Browser or

General

Legal