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
Posting as :
works at
You are currently posting as works at

Press f5 and click enter and you’ll go back

likehelpful

This! I use it all the time.

likesmart

Go download Arixcel and use this to trace precedents and dependents. This allows you to toggle through the cell references, and return to source.

likehelpful

After doing Ctrl + [ and while on the cell, press Ctrl + G + enter

uplifting

May both sides of your pillow be cool each night and your phone charger always be long enough. 🙌🏽

like

Related Posts

Can someone share how would a salary structure look like if you opt out of epf

like

Hi, due we need to share the resignation acceptance letter to the mindtree recruiter immediately, or we can take time?

like

Hi Sharks,
I want to know what is the expected ctc for a 4.5 yr SAP SuccessFactors consultant in KPMG for designation consultant.

Hi Fishes,

Can anyone refer me for HRBP role at Google Hyderabad, there is a position available.

Regards

like

what kind of induction sessions leads to more questions than answers? The LTI one.

Leader didnt show up
HRs were concerned more about next meeting than Induction.

Honestly no positive vibes.

like

How do you share your work on LinkedIn? I'm worried it'll come off as cocky

like

Just benched myself to get out of a toxic client relationship last week and already my mental state has significantly improved. I can’t stress enough that pulling the cord is always an option.

likehelpful

Accenture profile screener shouted 'Support???!' as if i stole someone's life support upon knowing i currently work in an Infrastructure support and maintenance project. Hung up the call so fast, Not expecting a call back

like

What helps you deal with stress and anxiety? It's all starting to feel like a lot and I'm afraid it'll start hurting my client relationships if I don't find a better way to cope soon.

like

Guys what is deployment manager in IBM?

Be honest.

Are you secretly jealous of other copywriters who are also published book authors (if you aren’t one yourself)?

like

Welcome, all! Thanks for joining our amazing group for those advisors looking to cash in on their great book of business and those looking to take over their book.

like

Best Marriott property in Maui?

like

Would it be wild if I added my preferred gender pronouns to my signature? (He/his)

like

I am switching from patient care front desk with a eye Dr clinic to patient care in a hospital. I'm worried about learning all the codes I'll need to learn. Is there a resource site or something i can start reviewing codes?

like

Not much of a rise and shine person more of a caffeinated and hope for the best.

Anyone else feel this ? Monday’s suck 🥴

likefunny

I quit my job and am going back to home country. What is the fastest way to transfer $100k from the US to a country in Asia?

like

What sort of skills translate well post-LEK? Is it worth getting really sharp with Tableau and Alteryx?

like

Anyone has any idea about CVS healthcare project in cognizant, how is the wlb n environment ?

This scene was all to real. I have lived it , & seems like currently can’t escape it. Can anyone else relate to having to work twice as hard just to get a fraction of others ?

Post Photo
like

Additional Posts in Excel Genius

Coolest, best, or nerdiest thing you've been able to do with Excel?

like

Has anyone used VBA to create multiple what-if data tables before?

I’ve heard of power query/pivot multiple times but what are their advantages compared to traditional excel? Anyone can share some examples?

like

Please help: 2 line items of data is getting dropped from the source to the pivot table. The source is an excel sheet in the same workbook so I can quickly verify that the data is there. Now I’m getting REF results from my GETPIVOTDATA formulas. How do I begin to troubleshoot this?

Hi, two of my colleagues keep getting a run-time error 91 when trying to run a macro on this worksheet. However, I am unable to detect the issue nor find a solution as this does not happen to me when trying to run the same macro. Any way I can find a solution?

like

I'm stumped!
Coworker creates "Sheet A" with invoice numbers
I use Monarch to extract invoice #'s and amounts from another report.
I do a pivot table to compile amounts by invoice. I copy those results to "Sheet Z".
I then do an @vlookup on Sheet A referencing Sheet Z (just the invoice # and amount).
It isn't working unless I go to Sheet Z and type over the invoice # (same number)! All invoice #'s are absolute and in the same font & alignment. Workbook has 10 yrs data. Has worked in past!

like

How can I make these dates sortable with a filter?

Post Photo
like

What are the most useful macros you’ve seen that could be used across multiple projects?

like

Just wanna say thank you to this group of beautiful people, always willing to help each other reach a solution!

likeuplifting

I have a spreadsheet that includes these columns: total AUM of firm X, % of AUM allocated by X to sector Y, % to sector Z, and so on (one column for each sector). Goal is to present in tabular form...

I have a large binary file (20mb) . When trying to reference another workbook in formula, excel won’t recognize the other workbook. Any fixes? I’ve been trying to reduce size

like

So xlookup? How is it going for you? Still haven’t use it.

like

What are your favorite excel macros to make you more efficient at work?

like

Does anyone know why negative IRR sometimes gives you a NUM error? A lot of googling and experimenting but cannot pin down what’s going on.

like

Question. I have data in Column A & I want to color highlight cells with data on Columns B-Z that don’t match A in the same row. How could I write formula/function that can do this?

like

How do I create a formula that creates a “cutoff”? For example, let’s say I have 1000 hours. I have a list of activities in a tab that take up 15,20,50 hours etc. I want to highlight the cutoff as soon as that 1000 hour limit is reached.

like

Not Excel but similar. I’m working in Power BI and I’ve ran into this issue a few times. I have some data and I want to do a calc but get the wrong return. Say I have a column of cities, it’s corresponding state, and population. I want to calculate, in the same table, the % populated but of it’s respective state. In Excel I’d divide the pop by using a sumif where one of the conditions is obviously the state. I can do it in another table but want to do it in the same table. Please help!

like

Do you still use index match? Is it (Always) Possible to switch to xlookup?

like

Tips on how to quickly learn mid/advanced Excel tricks and shortcuts? Forum or training somewhere?

like

I have a spreadsheet downloaded from a SaaS product. Every where there is drop-down multi-select or drop-down there HTML code I need to remove and simply leave my lists. Any ideas? I thought kutools would work but apparently not?

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