Dragging a formula down 50K rows, around the 47k row it just stops. Not stops to calculate the formula but stops to even apply it to the cell (it’s blank with no formula). Am I going insane??? 🤯

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

You’re insane to drag it down 50k rows

likefunny

Control C then Control V. No more dragging OP

like

Fill rows below with a filler "x", then paste formula over

likesmart

Why drag in the first place?

like

Using power query will help if it’s not an incredibly complicated formula. Give it a search and see if it fits your use case!

Related Posts

How do you get out of the burnout cycle? I’ve felt overwhelmed for a while and now I’m in the “can’t function at all” stage. It’s so hard explaining this to my manager because I already have a workload that’s lighter than others (not because of performance or my request). Any tips on how to get re-engaged, since the overwhelming feeling will come back?

like

What does everyone think of Charles River Associates for their life science practice? Is it reputable? For a new grad?

like
like

What my buddy and I are drinking now. As always, the WR Double Oaked is amazing!!!
However, the Hudson Baby Bourbon Whiskey is NOT hitting the spot. It leaves a very dry bland taste.

Post Photo
like

I am an SAP CPI Consultant with CCTC of 12LPA fix & 21% variable pay. My YOE is 4 years. What else should I learn so that I can increase my package to 20LPA plus while switching job. Do you recommend reskilling to some other tech/ domain?

like

Cogni or Accenture !!? (same CTC)

like

Can anyone pls help me connect with some wells Fargo HR.. I am looking some opportunities in their portal for hyd location, even though the skillset/JD completely matches, they do not contact.

Which pharma ECDs approve smart creative work? Please drop names below. Many times when I see inspiring stuff posted here my first though is, the guy who is approving my work would NEVER go for that.

like

Interested in BizOps/Strategy at a SaaS company funded by tier 1 VCs? My team is looking to grow, happy to refer qualified candidates!

like

Has anyone recently gone through Deloitte interview ? If you have do you mind sharing the experience?

like

I am a SM hoping to make Principal. One of my development areas where I believe I can do better is Relationship Management and Sales. Any advice on courses, books, etc. to help improve?

likehelpful

What's the average salary for a mid level CW?

like

Dear Fishes,

Recently my juniors are joining Novartis and they're paid heavily, now I feel I am underpaid and loosing motivation, if I wish to switch higher roles in other functions, is there any possibility my salary would be corrected accordingly, Need your input guys?

like

Howdy writers, what’s your process for developing a TOV?

like

Any recruiters from Target on here?

like

Joining BNP Paribas for role of Senior BA in bangalore, is the Bangalore office new? How many employees are there? How is company culture? Management etc, I had other offers from societe generale and hsbc similar offer but in hsbc the role was of a manager in compliance risk analytics domain, bnp is in trade and investment banking domain, I choose bnp, was it a good choice?

like

Therapists and MHT/BHT's in this bowl, anyone feel like your leadership does not understand anything about how the job works? Or how much effort goes into it? There's next to no compassion for the well-being of the techs where I work, and the strain has caused a few people to quit.

like

Does anyone here work at Ameriprise financial? If so, would you recommend it? What is the work life balance like? I have an interview for a Advisory trading specialist role. Thanks!

likehelpful

Which company should I join from below considering CTC and Technology is same:
1. ThoughtWorks
2. Boeing
3. Deloitte
4. Nokia
5. Teradata

I have 2 years of experience working as Full Stack Developer - Java at IBM. I'll appreciate if you can tell the reason as well.

like

Due in 2 weeks with baby number two, husband just tested positive for Covid 😩 He’s been around me and our 2 year old the past 2 days, getting PCRs for me and my LO tomorrow. Freaking out is an understatement. We had our first in May 2020 and never thought we’d still be going through this 2 years later. Anyone know anyone whose delivered or had a c section with Covid? Looking for some encouragement everything will work out okay. This is crazily the first time we’ve had it!

like

Additional Posts in Excel Genius

Tips on adjusting to Mac? I’ve figured lots of keyboard shortcuts but it’s just not the same 😪

like

What are the most typical models you all build

likehelpful

Google Sheets vs Excel - pros? cons? differences?

likefunnysmarthelpful

Is there any easy way to handle FedEx/ups tracking numbers? I’d like to have some formula that would just show the status in another cell.

like

At my old firms when I would be using excel and modeling using the font schemes (blue, green, black for hardcode, link, and formula) I could use the “control shift ;” to shift through the schemes. My new firm doesn’t do this. Does anyone know why the shortcut would be different and how I can add it back?

like

What's the F4 analogy in Office 365?

like

[shortcut genius] how can I use a keyboard shortcut to simulate the double-click on the cross in right low corner that extend your formula only to the row you need (ctrl+d will go too far)

likehelpful

Any recommend courses (coursera, edx, etc.) people would recommend for user with intermediate experience with excel?

like

Hey Geniuses! I apologize in advance if this question has been asked before, I'm new here and just trying to learn as much as i can. Does anyone know a great source to learn Macros for beginners. I would like to create one for work. I appreciate it

like

Last cell question. Some of my simple models are massive in file size because every tab has a last cell of ~XFD65. But I’m not using anything past ~U100. Continued.

like

I have three lists. Each is a list of processes. Each list represents one hierarchy level. Is there an easy way to get from three separate lists to one list ordered like shown on the right?
Thanks for your help fish!

Post Photo
like

Just created my first macro! Super proud of myself! #humblebrag

likeuplifting

I’ve toggled the “Show Formula” setting and it changes nothing. File format is xlsx, so that shouldn’t be the issue. Any ideas why these are showing the formula instead of the output?

Post Photo
like

Is Macabacus or any other add-in actually worth it for Excel & PPT? In LMM - MM M&A roles.

likehelpful

What are the most annoying things for you in old-school excel users?
I’ll start:
1) vlookup 2) concatenate 3) inability to work with file versions, therefor constantly locking file from changes

like

Our system is really lacking and we do a lot of work outside of it to track data. Currently I’m using Excel to track data from multiple resources, however, it’s so manual and prone to error. Any suggestions to keep the data clean when I have to pull info from multiple places? I’m constantly auditing and we won’t even look at getting a new system until next year :(

Hi! I have knowledge of pivot tables, vlook ups. But I'm rusty on if statements and would like more knowledge on excel formulas. I'm looking for excel classes to take online. Any suggestions?

like

Can anyone help me with this pls? I created a graph using data above (not shown) but for some reason “technology” here appears three times. I want sectors to be grouped together. Is there any way to fix this?

Post Photo
like

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

like

I am having difficulties getting my (Return on ad spend) column displaying correctly. The source data is shown in currency but on the pivot table I am only seeing count and percentage options. Any help would be greatly appreciated.

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

Send download link to your phone

OR

Scan your QR code to download
Fishbowl app on your mobile

By continuing you agree to Terms of Use and Privacy Policy.

Messaging rates may apply

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