HELP! Excel gurus, is there a way to allow filtering but turn off sorting on a worksheet?

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

Alt+A+T?

I think this works

Related Posts

like

Not sure if other firms are the same, at EY we can add “🏳️‍🌈 I support inclusion” in our email sig. Most people from Unity ERG don’t. If you don’t, why not? Particularly during Pride month.

like

Hi fishes
Do Accenture have rotational shift for business analyst? Pleasee let me know

like

I have 2.5 year experience in dot net technology. Now I am looking for change. My current ctc is 6lpa. how to prepare for dot net interview. Can anyone pls guide me Tata Consultancy Accenture India Capgemini Cognizant Mindtree GlobalLogic Nagarro . Thanks in advance

like

Question: which privacy & data protection cert has highest return and value to your career (CIPM, CIPT, CIPP, CDPSE, DLP tool cert)?

like
like

I got 50% hike in Infosys however in accenture, I got 20% mid year hike and 30% hike promise in Dec'22 to match Infosys. Should i stay in Accenture or move to Infy? which company is better?

like

Hello Fishes, I have two offers in my hand
1. L&T Technology Services: 22LPA(8% variable) + 1L JB
2. KPIT : 22LPA(Fixed) + 1L JB

TS : Infotainment Testing, YOE : 8
Which company I should join?
It would be helpful if I get to know about the benefits of both companies
Need suggestions!!

Bosch KPIT L&T Technology Services Continental Mercedes-Benz Research & Development India Wipro Tata Consultancy Tata Elxsi Altran Capgemini

Does PwC provides joining bonus

like

DC Metro folks, we should do brunch/happy hour

likehelpful

Happy Monday everyone, gotta start the week strong 🥃

Post Photo
like

Had interview rounds with client, director, partner however no round with HR but today got a mail for documents. Can i expect HR round now?

like

Looking for referrals to Facebook (Meta) if anyone can help me out! I applied for their Associate General Counsel (Commercial) role and I am coming from a publicly traded company where I have been the Regional Counsel. 10 years experience in-house, 5+ doing commercial contracts. If you’re willing to refer me please DM me and we can work something out! Thank you!

Who has the Descovy business?

like

Is 49,000 a fair starting salary for a scientist 1 with a B.S in biology in Philadelphia?

like

It’s open enrollment season, and health insurance premiums are way up at my company (up 37% to $600/month for a family). Anyone else see big increases this year?

likesmart

Do you guys give your boss's New Years' gifts? I'm thinking of doing one since I didn't give a holiday gift but thought it maybe weird

like

Why shouldn’t all countries ban TikTok for the damage they are doing while harvesting all Western data for the CCP to use against us?

US big tech also needs to addressed but China’s aspirations for world domination and a totalitarian control globally is far more of a threat

Google TikTok Amazon Facebook (Meta)

like

Hi y'all
Anybody here pivoted careers completely? How did you go about it? How much time did it take for the transition ? What tools or online help(training/ coaching) did you take to make the switch??

like

Hi,

If anyone has given interview for Salesforce developer position in
Goldman Sachs , please share your experience like what kinds of questions they ask if a guy from salesforce developer background?

Thanks in advance

like

Additional Posts in Excel Genius

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

Hey, I have been tasked with teaching some of my coworkers excel from the very basics to more advanced. Does anyone have recommendations on the skills to teach them about? Thank you all in advance!

helpful

How do I look up values from a column in a row? E.g. Values in A1:A6 in B2:F2?

like

How can I add multiple characteristics within one cell and make sure that a pivot table can read both values independently if needed? E.g., I have a column titled “color” and in one cell I write “red” and the other “red, blue”. I’d like a pivot table / formula to be able to count that there are technically two “reds” in this data set. Any tips?

like

Need help building an electric schedule for a production schedule with a Gantt chart style view (sort of)

Currently have an excel list with resource (production line), start date and time, and then also the name of the item being produced.

Any ideas how to tackle this??

I’m thinking a stacked bar chart with the vertical categories to be my resources and horizontal the date/time and then each individual bar to be the name of the item being produced.

Thank you for the help Excel Gods 🙏

like

What’s the keyboard shortcut to get into the “insert options” dialogue when you’ve inserted a new row with Ctrl+Shift+Plus?

like

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

Does anyone from PwC have a list of the favorite groups shortcuts for excel? Please provide. Much appreciated .

like

How do you fix microsoft excel cannot paste data error?

like

Excel Rookie looking for a super simple formula to bring all information linked to a certain date in tab 1 to be organized under said date in tab 2.

like

Can dates be grouped just by Month-Year in pivot tables on a Mac without having the year as its own dimension?

Post Photo
like

Anybody know if there is a way to automate a Gantt chart in excel when building out a roadmap? Essentially want to recreate the functionality of ms project because my client does not have project and wants a nice visual for the roadmap

like

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

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

like

HELP!
I have raw sales data on one tab, which includes a sales rep ID number. My second tab has that sales rep ID number in column 1 and the rep name in column 2. How can I get the rep name added to the correct line items in the raw data?

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

Anybody have the SQL server data mining add in on excel? Desperately need to run a really quick analysis through it but can’t configure it.

like

Does anyone know what purple tables mean in Excel?

I know about green and orange, but never saw purple before and trying to figure it out.

likefunny

Any suggestions for a formula to calculate a running count of the number of incidences in a list? For example, in a list with A, B, C, B; I want to label A = 1, then the first B =1, and first C = 1, and then the second B = 2, etc. The list is in a column and there are thousands of names. TIA for your help!

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)

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