my Excel pet peeve is when people leave endless blank rows in a file.
What’s your biggest spreadsheet annoyance? Let’s vent together!

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

When someone makes every cell white instead of turning off gridlines

likefunny

I do that! Sometimes I want to remove grid lines from only a portion of a sheet.

When someone leaves a filter on and does not leave the cursor in A1

like

…or any sheet where the cursor is not in A1

like

When someone writes new VLOOKUPs.

like

When someone invents a reason to be upset over trivial crap

like

reminds me of the days you invented bank accounts for customers without them knowing…

funny

When someone scrolls to the bottom of a table instead of using hot keys

I'm afraid I still do that some times....

Here to read comments 😅😅

Related Posts

Got so comfortable with being on my own that I really think I will die alone.

likeupliftinghelpful

How much do you pay for car insurance and with whom? I have no accidents, one ticket that should be dropped off now, and am constantly getting charged insane amounts.

like

Synechron technologies Synechron Inc. Did synechron call to office ?

Looking for a weekend toy, reliable sports car recommendations?

like

As other global firms are calling their employees back to office ? Will pwc ac follow the same or will continue to provide option of working from home .

I know someone earings 50 lakhs per annum with 5 years of experience in .net full stack technology. Is it possible this much growth in 5 years.

like

Hello everyone,

If you know about DBS in capgeminigar please share your inputs how it is in terms of technology and growth for micro services profile with 6years of experience

like

Guys..
Do capgemini revice offer amount if you have another offer?

like
funnylike

3 Things to keep in mind which changing jobs:
1. Always ask dedicated budget for the job before you tell your expectations.

2. Always have atleast 2 weeks of gap before you join any company. You might not understand significance of that but just have a gap.

3. Always talk to people of team you will be joining before you accept offer or atleast before you join company.

like

So I KNOW I have ADD maybe ADHD...my parents told me just recently I was diagnosed in third grade but they didn’t want to give me medicine but I struggle a lot with paying attention or remembering...

like

When I get mild anxiety during a conversation I press my thumb agains one of my other fingers and it helps me relax a bit. Does anybody else do this? 😭

likehelpful

Are budgeted hours as big a deal at Big 4? I've legit been asked why I charged 8 hours one day on a client I was assigned 40 for the week. It makes it difficult to hit utilization targets too

like

Hi fishes, what's the fixed range for B30 Engineer 2?

like

That was a lame flyover! Where are the stealth planes?

I got 2 times in Nagarro cheerboard. For Sep and Nov month.

Will this be beneficial in appraisal?
BTW 2 Cheerboard ka bas 1000 rs mila
😭😭

like

what's the best app/site for planning an itinerary? I'd like to list all the things I want to see and be able to plan out the order by day. surely this must exist. tripit seems very manual/lacking.

like

Planning a southern Germany and Switzerland trip over Xmas - must visit cities??

like

Additional Posts in Excel Genius

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

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

What are some common reasons that a COUNTIF formula might not be working correctly? I'm using the correct range and value to count. I'm not seeing "ERROR" but the values aren't correct (it's not counting everything). Thx.

like

Best websites to get more of a handle on Excel as a beginner-intermediate?

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

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

like

Anyone else have a formatting pet peeve and get annoyed when people don’t have a blank first column and row in tabs? I.e headers/data in cell A1

My first manager told me this, and I’ve followed it to a T since.

likesmart

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

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

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)

Best way to lookup a value with multiple criteria across rows and Columns, for 3 criteria I usually do sum product. Any other tips?

like

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

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?

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

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

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 am trying to recreate this without the numbers at the end. Any advice?

Post Photo
likehelpful

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

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

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