Any way to collapse the content of several cells into the top cell in a selected range?

I'm converting PPT tables to Excel, but any table cell with multiple lines gets copied over as multiple excel cells. I want to quickly selected a range of cells and have all the content go back into that top cell. Would prefer not to merge cells unless there's clean way to do that

in live hirevue interviews, can they tell if you switched tabs? I have a few notes on my computer id like to refer to if possible

Which will be the best between JPMC and Nagarro (permanent work from home)?
Please suggest.

Hi Fishes,

I am a MBA-Finance professional with 10 years of experience in Handling Finance, Accounts and Taxation in SAP.

Please let me know if any job opportunities with your reference.

Thanks and Regards,

Suraj Amin

I am a mechanical engineer and people think that because I am a "mechanical" engineer like I fix cars. It is part of the career, but it is not the same thing. It happens to others that people confuse your profession, or it's only to me?

How about the scope/ demand of mobile application testing.

Any designers or ADs here make the jump from advertising/marketing to product? (and adjacently - from agency to in-house tech) Would love to hear about how you pivoted and any challenges/insights.

Hi all I have 7 years of experience in Banking operations Internal audit and internal control, risk and control framework, Thematic review. AML/KYC aspects review, transaction monitoring, compliance reviews, CDD and STR reporting. Please refer me eagerly looking for a change. Preferably chennai and Bengaluru location.

I got an offer from Pwc IAC, HR confirmed over mail that this is a permanent work from home position. But not mentioned in the offer letter.

I got an email confirmation from HR, which simply says "you can work anywhere from India".

I am not willing to relocate to Bangalore, can i trust HR, if anyone working in pwc is aware of such policies please share your inputs.

For those in financial services strategy, I’d love to gain some more insight in what’s going on in the industry.
- What kind of projects are you working on?
- What problems are you solving for your clients?
- What challenges do you see coming up in the next 12 months on the client side?

BCG🐠 how long is the cool off period for a fresh application if I didn't get to the interview stage?

Any suggestions for healthy self help books? Or healthy eating or understand why we get cravings? Looking for self help books alone those lines to help get my eating right

Showing off my new badge

Which company is good to work at Fidelity investments or IBM cloud (product based)

Fidelity investments: 25.5 (22 fixed+3.5 variable) + 1 lak joining bonus

IBM cloud: 25.1 fixed+ 3 lak joining bonus

Both are individual contributor role

Hpe Hr releases an offer letter with joining after 2months. Should I wait or back out? What if they withdraw?

Is any one from pune CIS working at kharadi location (EON) do they allow to work from kharadi instead of hinjewadi.

My 2023 media budget was just rejected and I was told I need to cut 20-30%...but our growth goals are 10-15% next year...not sure how upper management thinks we are going to do that without advertising...

Hi Everyone!

I am a Software Engineer looking for opportunities in Singapore. Do let me know if you can refer me for open positions

Skillset: Microservices, Golang, Openshift and more

After I set a print area, how do I showcase the page 1 - page x in the excel sheet and have the background be grey?

I’m trying to learn more about Excel functionality and there’s several simple functions that I don’t know, this is probably one. If I am color coding data, is there a way to automatically move those lines to the top or bottom of the spreadsheet once the color code for the line is made?

Client sent over a 90 MB model this evening. Took 10 minutes to open and a fraction of that to crash. Can’t wait for tomorrow 😭

Anyone use power query before? My goal is I have multiple look up values in one cell (separated by comma) and I need it to look up those values and return values from another table which also may have multiple values (separated by comma) anyone know how to do that? I played around with power query today but it wasn’t giving me what I wanted

Has anyone had an issue with index match and lookups returning NA when trying to manipulate data from a password protected workbook?

Does 2-finger touchpad scroll not work on Excel sheets anymore? I used to be able to swipe quickly on my laptop's touchpad to navigate sheets but now it doesn't work. Based on the handful of posts I've read online about it, the problem seems unresolved. Has anyone dealt with the same issue and fixed it?

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.

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

Best free data sites to tap into to build a city analysis model? Basically I want to "discover" cities with certain dimensions, like: population, elevation, climate, and proximity to other things (ski resorts, particularly)?

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)

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?

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).

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

Hi there,
Which Excel courses you recommend for a beginner?

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 🙏

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

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 🙏

Vlook up isn't recognizing a couple of cells even though it's feeding off a pivot and when I check with an " if =" it comes up as being the same.
Any advice on what I need to check?
Thanks

Is there a way to identify duplicate URLs within labeled hyperlinks on multiple columns/rows/cells?

I was thinking conditional format, but it’s identifying duplicate labels. I have over 80,000 cells, so extracting URLs manually isn’t going to work for me.

Thanks in Advance!