I’m verrrrrry new to excel and am going crazy because is there not a way to “clip” text in cells like you can in google sheets? I read about a “fill” option, but then noticed that cells that aren’t filled just repeat text. 😂🤯

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

You can clip cells. Grab all the cells you want to do this on (this can be all of them). Right click format. Alignment tab. Set the horizontal to “fill”. It should be call clip instead of fill but they don’t let me name the functions unfortunately 😉

like

I don’t think there’s a simple alternative. You can wrap text & then manually adjust the row height back to one row visible, or you can fill the next column over with spaces. But no simple directly equivalent feature.

Related Posts

Hey there!
Was wondering if anyone has a range of KMs after which it's risky to buy a secondhand bike? Looking at 600cc supersports!

like

Hey everyone! Fairly new to the city and looking for some cool restaurants to try out. What are some of your favourite places around the city?

like

Is it easier going from Senior Accountant to FP&A or straight from Big 4 Audit. Just trying to figure out what route to take. Also what is a good salary for a Senior Accoutant? MCOL, CPA, B4 Audit - 2 yrs

like

Has anyone heard of, or tried using, the Paladin Registry?

like

Now that I got promoted to manager, I’m kind of missing the camaraderie that came along with being out on the floor with everyone else. Is that normal?

like

I’m a firm believer that a manager should develop a positive relationship with employees, but I don’t want that to be an invitation to disrespect my authority. How do you know where to draw the line to make this distinction clear?

like

How soon after a final interview with a DM is ok to call and follow up on a job potential?

like
like

Deloitte is looking for qualified candidates to join their Cyber & Strategic Risk practice immediately. All levels. Please reach out if you're looking for a change and I'll submit your resume!

likefunny

“There are so many layers of Daddy. Book coming soon. How to get one, how to be one, how to keep one!”

funnylike

Is a 2-day deadline to accept or decline a job offer normal right now?

like

Has anyone done a collab with influencer MIKIRAI? I know she’s a big deal but i’m trying to figure out if she’s worth the money, our agency just had a bad experience with an influencer and the client is not happy. We need to make a comeback! All insights are appreciated.

Hi there,
Anyone here into technical Consultancy. I am looking for a suggestion/advise as where does this leads to after years (5-7) of experience. What’s the career ladder onwards?

like

Saturday night and I’m Netflixing (for the last 15+ Saturdays). For the love of everything, let next year be normal again!!

likefunny

Do any of you have a favorite pre-workout and/or post-workout protein shake? Looking into some to give me energy for sitting at my desk all day 🙃🙂

like

EY Christmas dinner in December. Funny part is we have to contribute for a Xmas dinner/annual company event. I have never seen this before.

funnylike

Please suggest to get some nice suits at London. I will be there for two weeks.

Hello Fishes,
What is the BYOD(bring your own device) policy in EY GDS?
thanks

like

Folks, I am in the final stages of converting an offer for the position of Senior Advisor, Business Intelligence at Dell Technologies

If this gets converted what should be a good salary range to negotiate with the HR?

Total experience : 8.5 yrs
Current CTC : 19 LPA
Skillset : Project Mgmt, Sql, Tableau
MBA from an IIM
Post MBA experience - 5 yrs.

like

Running my first half-marathon mid-October, How many weeks should I give myself to train? I was thinking 14. Not trying to PR, and can run 4/5 miles comfortably right now. Any advice or training plans you recommend?

like

Additional Posts in Excel Genius

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

like

Will need to migrate to office 365 soon. What’s the difference for excel from the 2013 version?

likehelpful

Does anyone know any shortcuts for the “Refresh All” button without having to always click Data->Refresh All every time I want to refresh the live data? For a Mac btw pls thanks!

Post Photo
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

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

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

What’s the best way to summarize multiple amortization schedule. I have each schedule on a separate tab. On a master sheet can I do something where I can input a specific month and show my ST/LT ...

like

For a linear regression analysis… the equation of a line is Y=MX+B, where M is the slope. So if I’m measuring a line across 365 days and M=.2, can I say that I have increased production by 20% over a year. Or is production increasing 20% each day?

like

Would anyone be willing to teach me vlookup?

like

Current IE here. What are some Time Motion Study Softwares that are out there and you use in your jobs?

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?

Anyone know why a SUMPRODUCT cell would return to zero?

The error said ‘inconsistent formula’... (cont’d)

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

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

Hi all! Is there a way to easily copy over all the rows from multiple sheets into one consolidating sheet? We have 32 teams filling out transactions in their own tabs and need to consolidate all tabs transactions into one long list of transactions. Thank you!

like

How do you fix microsoft excel cannot paste data error?

like

Hi! I’m trying to create a macro that pulls a copy of a sheet from a file with a certain date in the file name into a new workbook. Is there a way to do this?

Why don't recent grads know how to use excel?

likehelpfulfunny

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

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