Hot take: Merging cells is the pineapple-on-pizza debate of Excel. Some swear by it, others say it ruins everything. -_-

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

“A spreadsheet merged against itself will not sort.” - Abe Lincoln

likehelpful

haha i love it

like

Format center across > merge cell

like

:)

Who swears by it?

uplifting

some of my coworkers

Merged cells are only acceptable if they're grouping your headers into a "subject" by being placed above the header. Never in the sheet/data set itself

like

I use it often for top row labels for data, but that's about it.

in the working file where you’re evaluating data, absolutely not. in the final deliverable table that will be pdf’d, sure.

Related Posts

Are their recruiters that specialize in placing CD level creatives in Creative Director roles at cool brands? Brands like DWR, Casper, Aesop, SweetGreen. Tired of surfing LinkedIn, Indeed etc. Help!

like

One of my big hang-ups with biden tax plan is raising corporate tax across the board. Why raise taxes on businesses when we've just found out how fragile it is to be able to run a small business?Why not at least propose some kind of progressive corporate tax structure if you want to raise taxes on corps?

likesmart

Hey people

I have recently received an offer letter from PwC and have signed and accepted the offer (via Workday portal).
Now when I check the tasks against the job on workday, I can see no tasks pending and under completed tasks: a green tick against 'review and sign offer letter (step complete)' (and I can see the offer)
I am told that I would receive onboarding emails from HR, but I haven't yet.
My DoJ is in the fourth week of July. When do we generally expect these communications?

like

Anyone here can help me for h1b sponsorship?, i am holding an h4 dependent visa without work permit. Not willing to leave my job here in India due to financial requirements.

like

Appraisal letter party 🥳

Beer on me, if you are nearby sector 29, gurgaon lets catchup 🍻

I am moving to Hyderabad on 4th Nov. Can anyone tell me if they have a vacant room in an already occupied flat near office. I am preferably looking for something within walking distance. Please help 🙏

like
like

How much hike one can get if rating is valued talent

Which one should I go for?

1. Oracle - 18.3 LPA fixed + probable bonus (I may or may not get)
2. Amadeus - 18 fixed + 1.5 variable.

Amadeus is also giving joining bonus of 75k. Amadeus is paying more, may give better hikes too, but I am finding it hard to let go off Oracle's brand name on my resume even if it's means around 2L less over an year. I am planning to work for atleast 3 years in my next company.

What would you have done in my place? Should I go for Oracle or Amadeus?

like

What the current salary range with YoE for UX/UI designers

like

Chicago media agency people - what’s your company’s current RTO policy?

I’ll start:

Spark - 2 days a week mandatory in office this year, 3 days mandatory in office next year.

like

So, where are you all from and what business line are you in? 😊

likehelpful

How company Company performance bonus is paid in persistent? In offer it’s mentioned that some is paid monthly and remaining at the end of financial year based on performance review

like

Anyone work at the CFPB? How do you like it (or not) and how long was the interview process? Thanks!

like

Whats the easiest way to start your own tax return preparation practice (part time at first) then maybe full time if worth it? Which tax preparation software is best to use? Or is it better to start off at HR block or similar places to learn some of the ins and outs before going solo?

like
likehelpful

What are your biggest red flags when dating someone new?

likefunny

Guys I am on talent pool since last 3 months and I am worried now wrt my job security in the company. I see no open position for india geography in open careers page and not sure if I will get a project any sooner. Should I be worried? Anyone have any idea about globant firing employees on bench?

like

layoff news about Amazon is true or just a rumour ?Amazon

like

Is attaching communications between opposing counsel and the filing attorney when filing a response to a motion poor form?

like

Additional Posts in Excel Genius

I’m referencing a cell (numeric) to a text cell. Is there a way to format that number to include commas? See example in comments.

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

like

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

likehelpful

Would anyone be willing to teach me vlookup?

like

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

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)

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

Still don't have xlookup. #fomo

like

Hi All,
Looking to automate a manual process for the client and thinking of creating macros for with VBA. Has anyone done anything similar?

In the process of learning but wanted to reach out for any tips, tricks and advice anyone may have.

Thanks I’m advance.

like

Is there a way for me to automate creating columns to do this so I can drag across and create my columns? For example--
1Q2021 2Q2021 3Q2021 4Q2021 2021 1Q2022?

likesmart

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

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

like

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

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

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

I’m calculating a bunch of totals and averages by category on one worksheet by filtering data in different categories from another worksheet. However, when I change the filters, the previously..(cont)

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

I created a macro to help me save time on this onetime task and now whenever I open my excel, a blank excel opens with the name of the macro. How do I get rid of it?

like

How do I change line style@back to default on excel? Accidentally click on one, and now it wants to use that style every time. I just want to be able to use the ones in the typical drop down

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