is there a way to use my keyboard to go through drop down options in a given cell?

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

Alt + down arrow to access

arrows to move inside it

like

Alt+down

like

how do you uncheck off items that are part of the drop down options by just using the keyboard?

You mean in a filter?

Alt + down arrow on the cell, and use the arrows to navigate (tip: going up is faster). Hit space to check/uncheck a given option

like

Related Posts

Hi Fishes,

I am currently serving NP, My job role is React Frontend Developer have 1+ YOE. Looking for the similar job role.

Needed your help for referral for the any similar job opportunity.

like
like

NOK next get in while ya can homies

like

Hedge funds until last week: “it’s called capitalism, losers, you lose, you shut up 😂”

Hedge funds this week: “the mean wetail investors dinnit pway faiw 🥺”

likefunnysmart

How do I become more assertive at work? I keep getting this feedback. I don’t think I am a shy person, I am however an introvert and don’t go out of my way to interact with people. I do good work and believe it should speak for itself. My supervisor told me that this is not how it works in consulting. I am worried I will not be able to climb the ladder because of my personality. Any tips on how women on the more introverted side of the spectrum have made it in consulting?

like

Hey I'm a purple belt in the NJ area (although I'm 100% nogi now)

Manage to make this hobby work with consulting through low travel and morning training. Hope to do it as long as possible. 34 now but maybe I'll go on the trt juice later lol

like

General question about LinkedIn, but I figured recruiters may have a better perspective.

Is it really beneficial to have a LinkedIn premium account over the regular free account? I’m currently looking for opportunities and wondering if it really will make a difference to pay the price and subscribe to the premium account.
Can anyone recommend if, and how it will, or will not help?

like

Who else out here feeling indignant when audit recruiters slide in ur DMs 😤

likefunny

Anyone hiring in PHX looking to leave BCG and start a new role next year.

like

Could anyone refer me for Senior UI Developer role at JP MORGAN ? 7.5 yoe and Angular + Vuejs

like

PwC or EY Houston Tax?

I am looking for a switch in the pharma consultancy space. Work experience in pharma forecasting, commercial analytics, competitive intelligence (5 years). Currently working as a team lead with a team of 10 people. Any leads appreciated thanks.

like
like

Hi, I am looking for a job due being laid off. I have experience working with ServiceNow as an end user with my previous company. Would that be enough to get a job with ServiceNow?

helpful

Hi Fishes,

I have cleared all the rounds with Wells Fargo, waiting for HR discussion. YOE 8 years, Skills: Azure, MSSQL, MSBI.. How much can I ask for ? Current CTC: 16 Lakhs

like

Any recommendations for a functional medicine doctor?

like

Hi guys, i got good comments in my review and feedback was also the same during regular connects in last cycle. But even after being a lateral hire and already completing 2 cycles at ZS, my ratings are barely halfway, whenever i ask about feedback from seniors i always get answers like you are already doing good. Feeling pretty bad about the ratings and seeing people of my tenure getting far better hikes. How do i take this up with my AC without sounding rude?

like

Stop comparing success.

like

Has anyone taken the entry level/early career Software Engineer interview at Google? I have 3 months to prepare for it and looking for some advice on a good preparation plan

like

How difficult is it to start a solo firm? I’m a first year attorney working in insurance defense in Florida. I love my firm and the mentoring I’m receiving and I’m definitely not looking to move anytime soon, but I would love to start my own firm once I feel competent. Maybe in a few years. Any advice for planning? Thanks!

like

Additional Posts in Excel Genius

If you follow him on LinkedIn you probably already saw this! Lol 😆 but I totally resonate with the post... 🤣

Post Photo
funnylike

Ok, using excel is not a primary function for my role (this will be very obvious shortly...) So please be kind! On my sheet, in the first and third columns, I have lists of reference numbers. In the second column I have a client name. I already identified the duplicates in the first and third columns using conditional formatting.What I need to find now is column 2 value, whenever value in column 3 is identified as duplicate. Problem is, I have over 120k rows of data so I can't filter! Help!

like

Google Sheets vs Excel - pros? cons? differences?

likefunnysmarthelpful

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

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

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

Please help. I was recently hired by a Venture Capital firm that uses MacBooks instead of PCs. I’m extremely efficient with Excel on PCs and am struggling with the transition to Mac. Do any Mac users have a list of keyboard shortcuts that they use frequently, or any other tips/tricks?

likefunny

What's the F4 analogy in Office 365?

like

I have three lists. Each is a list of processes. Each list represents one hierarchy level. Is there an easy way to get from three separate lists to one list ordered like shown on the right?
Thanks for your help fish!

Post Photo
like

I really need some help.
What shortcut inverses my
Ctrl + [ aka Ctrl + {
which jumps through a cell to the source? How do I jump back? Manually isn't practical for a 50+ tab sheet

like

Can anyone help me with this pls? I created a graph using data above (not shown) but for some reason “technology” here appears three times. I want sectors to be grouped together. Is there any way to fix this?

Post Photo
like

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

like

Has anyone encountered this error before? We can’t access a workpaper with 70% of the work done 😩😩

Post Photo
like

What are your top Excel ninja tricks? Ones that few people know...

like

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

likeuplifting

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

like

Our system is really lacking and we do a lot of work outside of it to track data. Currently I’m using Excel to track data from multiple resources, however, it’s so manual and prone to error. Any suggestions to keep the data clean when I have to pull info from multiple places? I’m constantly auditing and we won’t even look at getting a new system until next year :(

A lot of the work at my new employer is quite redundant and can be automated via macros. What are some of the best resources to learn vba?

like

Tips on adjusting to Mac? I’ve figured lots of keyboard shortcuts but it’s just not the same 😪

like

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