In excel, whenever run a command that requires a pop up (like paste special or data validation), it clicks off of it (I.e., I can’t use the keyboard anymore and have to manually click back into the excel application or alt+tab back (even though excel is still displayed on my screen. Any way to fix?

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

It just gets stuck like this (so you’ll notice the paste special bar is grayed out, meaning it isn’t clicked on. It should be blue). Because of this, I can’t use my keyboard anymore

Post Photo

May see if using alt works? So you don’t have to click

Related Posts

How do you take your morning beverage. And what do you think that says about you?

like

Hi! I’m wondering what would the salary range be for a senior HR advisor in Canada?

like

I need 11 likes to start DM please 🙏🏻

like

Any Cherry Bekaert tax folks? How is the culture?

like

What do everyone think of the designation CLTC, thank you

like
like

How much did you spend on trips/recreational activities in business school (NOT rent or general food expenses)? Trying to budget!

likesmart

Continental Automotive or Robert Bosch?
Both Bangalore location
Offer:Conti: 33lpa Bosch:30 lpa

like

AWS Cloud and Security+ certified,
6+ years of tech experience ranging from hardware networking to Security and compliance.
Looking to get into cloud security, analyst, TAM, consulting... I'm open and hungry for something new.

like

What is PMO office/role all about? I see some colleagues talking about it and even looking down upon it.

I'm new to Big4 and haven't heard much about it in my earlier organisations.

like

Model y ?

like

Hi Guys,

Got offer from oracle.

Tech stack java

Current yoe 5.4 yrs
Current ctc 8.2 lpa

Oracle offer:
AGP - 16.7 lpa

Basic 7.5 lpa
Flexi benefit plan 9.2 lpa
Epf 90k
Gratuity 36k

Ctc around 18 lpa

Is it good offer or can I negotiate?

Kindly suggest.

By the way what's meant by flexi benefit plan?

Thanks in advance.

like

Has anyone pivoted to a SWE role from consulting without having a CS (or related field) degree? Is this even possible?

like
like

Does anyone else hate weekends? Like let’s pretend we don’t have work to do so we can please our family & kids but meanwhile our anxiety is brewing inside? I’m never more relieved than to sit on my computer on Monday morning.

likefunny

Capgemini campus offer holder.
Got a mail recently from superset platform asking for language certifications if available.
Can anyone give any insights on it? What if we don't have any foreign language certifications?

like

Question: does anyone know if the new hires starting in October in the Dallas market are actually starting at $60k?

like

Does anyone actually love their job and the company they work for? Would love to hear how you found these opportunities

like

Infosys or ibm

Exp 6 years I want wlb and Job security do which will be the best .

like

Where do you guys and girls shop at for your suits and/or business casual wear?

like

Additional Posts in Excel Genius

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

likeuplifting

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

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 :(

[shortcut genius] how can I use a keyboard shortcut to simulate the double-click on the cross in right low corner that extend your formula only to the row you need (ctrl+d will go too far)

likehelpful

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

How can I extract just the year into a new cell from a “yyyymmdd” cell (labeled PD here) that isn’t recognized as a date? I basically need to sort this data by year. Thanks in advance!

Post Photo
like

What are the most annoying things for you in old-school excel users?
I’ll start:
1) vlookup 2) concatenate 3) inability to work with file versions, therefor constantly locking file from changes

like

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

like

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

likehelpful

Google Sheets vs Excel - pros? cons? differences?

likefunnysmarthelpful

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

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

like

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

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

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

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

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

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

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

like

What's the F4 analogy in Office 365?

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