After grouping rows or columns, is there a short key to extend or collapse the grouped rows/columns?

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

Collapse grouped columns / rows with ctrl + 0 / ctrl + 9, respectively.

like

Thought It might be helpful

Post Photo
like

Yeah it’s called group and ungroup, it’s in the data tab…it’s pretty awesome

I would expect an answer like that from Adobe. Short keys are non existent in your application

funnylike

Related Posts

like

Hello all,

I have got an offer from vmware but I have heard that vmware layoff employees a lot. Can anyone please put some light on the layoff situation in vmware. I am really confused

Thanks

like

Can anyone please refer me in LTI.

I have 2.8 yrs exp. Skillet - Azure Cloud, Devops. Open to any new latest technology as well.

I am serving notice period.

Thanks for your help

like

Does anyone work at @prose that could refer me for the senior brand designer position? TYIA

like

I hate when customers say “I understand it’s not your fault” and then continue to be rude anyway.

like

Anyone working in family offices? Boutique investment firms

like

Can anyone tell me the salary range for both a Senior Consultant AND Manager for Slalom in Columbus, OH? Trying to figure out what I can negotiate for in terms of base salary. Does Slalom provide a sign on bonus?

like

By when salary will be credited to accounts? Can anyone say where can we find payslips?

like

How to get release from a project? Hating the work environment and pressure here.

like

Has any creative here ever tried to make the leap to leave advertising and be a film maker, photographer, illustrator, etc.?? I’m so tired of ad agencies and how draining the “creative” can be. Happiness is more important than a nice paycheck for me. Any inspiration success stories advice would be so helpful right now...

likefunny

Is the future bright if one wants to just get started with mulesoft?

like

How is MBA (Executive) with Specialisation in Business Analytics from NMIMS (Upgrad)?

Have anyone done that.. please share your feedbacks

like

My boss asked me what id like to do moving forward at work. The department im in has gone under many changes the past few months. I was really hoping the business would put me in a place they “need” me but instead it’s up to me…
My goal is to reach the top, climb the ladder and one day be CEO. I have a lot of outside influences that make this a possible venture.
I’m currently in sales but don’t know if the right path is to continue in.
What should I say to my boss, knowing I’m on right path?

like

How much Js7 maximum budget should be??

like

Please help me to choose , super confused,
1)Epam Anywhere 32lpa fixed +70k joining bonus, permanent work from home 2) Capgemini 38 lpa 10% variable
I need work life balance .
Java developer having 8 years of experience.

like

What’s the culture like at Waystar Royco? Its an UMM fund focused on media

likefunny

Hi,

Is this a good time to join HP? As they have recently announced 6000 layoffs in 2 years.

like

which model deloitte usi banglore follows is it wfo or wfh?

like

Additional Posts in Excel Genius

How long did it take you to become good at excel? Like fast?

like

This is dumb, but. How can I pull and average the numbers in column b associated with the 4 values in column a? So, (sum of all As/total number of As) without filtering?

Post Photo
like

Is there anything similar to the INDIRECT function that I can use to build a formula reference to another workbook? INDIRECT creates errors when the referenced workbook is closed..

like

Hi Group, seems like it should be basic format, but I just can not get it to work. a list of data and want to alternate shade (blue,white,blue,etc) each line but if I have multiple lines I want to group together and they all shade the same. I want to group by the same data in column A, and the number of rows that are the same could vary. So let’s say row 1& 2 same entry in column A(blue) row 3 different (white) row 4,5,6 same as each other different to other rows (blue) etc… help 🙏

like

Hey guys, I'm trying to find a formula to use instead of the Goal Seek function. Anyone know it? I thought I had seen one years ago, but can't find it now.

like

Struggling with this:
Suppose I want to shortlist companies that serve the priority industry vertical of a country. So I have the industries served by company (one column for each industry) and (cont)

Anyone have an app or Excel spreadsheet they use to keep track of utilization? We just switched systems and our new system doesn’t give us a real time balance of our utilization rate (cont)

Anyone know what these badges are?

Post Photo
likefunny

Is there an easy way to switch XLOOKUPS to INDEX MATCH? Have a large file with bunch of formulas that don't work on all client machines (different excel versions).

like

Does anyone have any tips/tricks for knowing where to plug +1/-1 in a large table with totals across the y and x axis that contain un-rounded numbers? Every time I fix a row I throw off a column or my check figures to the true data source.

Post Photo
like

Help me save the day: have a massive excel file (600k rows) with duplicate records (column a, b and c are duplicate, not a duplicate if a and b are the same though). How can I filter for just these records? If it didn’t crash excel I could concat into one column, Conditional format for duplicates, and sort by color. What’s a work around?

likehelpful

How can I copy a formula from one sheet to another?i tried the simple Ctrl+C, Ctrl-V, but the formula refers to the old sheet.

like

Any book recommendations on excel modeling for real world business applications?

like

I am trying to recreate this without the numbers at the end. Any advice?

Post Photo
likehelpful

How do I set the formula to calculate “If x falls between 1-10, return 1-10, if it falls between 11-20, return 11-20, and so on”

like

How do I easily find any cells that are hard coded vs formula? I have 10,000 rows of data and column F is supposed to be a formula based on columns C and D, without clicking into all 10k cells in column F how can I make sure formulas are there and not accidentally hand keyed over?

like

How do I compare two sheets to make sure they are identical?

like

What are your top excel functions you use in finance / accounting - besides vlookup - Pivots - sumifs - count - index. I have an interview coming up which will have excel based technical questions. Not sure what other functions are considered important in the accounting finance world.

like

Would anyone be willing to teach me vlookup?

like

EY trying to move away from Excel . Think it’s possible? Want to see it happen?

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

Scan your QR code to download
Fishbowl app on your mobile

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