Does anyone know the shortcut for applying a formula for rest of the column? Other than copy paste.

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

If you have already selected the column/range, Ctrl+Enter when you are typing the formula (instead of just Enter) or Ctrl+D when you have already typed and pressed Enter. Both are safe to use on filtered ranges.
I’m not aware of shortcuts that work when you *haven’t* selected the range you want your formula to be in.

like

1) go to the cell which has the formula
2) Shift+Ctrl + down arrow will select all the cells of that table to which you want to apply the formula (if no table then it will go all the way down)

3) after selecting the cells (step2) you want to apply the formula -> just hit F2 (it will show you the formula)

4) CTRL+ Enter

likehelpful

Was going to comment this as well!!! F2, control and enter

likeuplifting

Double click bottom right of cell

like

double click the bottom right corner if it’s next to another column wi the data in it?

like

And without double clicking

likefunny

And only using 1 hand. Why?

Double click the bottom right corner of the cell

like

Ctrl + arrow keys to navigate the end of the column, ctrl + shift + up arrow to select the column, alt > h > fi > d

like

Look in to flash fill. I don’t use it but think it is what you are looking for

like

1. CTRL+C on formula
2. ALT>A>C (clear filters)
3. Move to closer full column (no blanks)
4. CTRL+down
5. Move back to target column
6. CTRL+SHIFT+up x2, then down 1 time
7. CTRL+ALT+V > only formulas
8. Enter

like

Flash full using your keyboard and ALT keys, assuming you’re not a sociopath and use Windows.

Ctrl D / Ctrl R. If you don’t have Macabacus or similar, it will only work if the cells are highlighted. With Macabacus, it goes to the end of the table.

Convert the range to a table. When you punch in the formula it fills the entire column auto-magically.

Double click the bottom right corner of the cell, but I don’t recommend this, especially if you’re trying to copy a formula on filtered data, as it will overwrite cells which are filtered out. Because of this I recommend copy, ctrl+down arrow (or left then down if you have other data in columns you want to get to the bottom of), then ctrl+up arrow and paste.

Crtl + D

Related Posts

Am I the only one that is happy to change jobs but has zero commitment to do the case study in the recruiting process ?

like

Who has experience going through interviews with JP Morgan Chase for DevOps/SRE position, how many rounds are there and how is the whole process ?

likehelpful

I got an offer from company A but I’m more interested in company B, who I’ve had one interview with so far. I think I’m going to turn down A regardless. Is there any benefit to telling B I got an offer from another company but that they are my top choice?

like

I have a third interview with a start up making their second legal hire. It seems like an exciting space but I’d be leaving a huge company and taking on risk if it works out. Any good questions to ask the GC as a second legal hire? I have management style, work assignments, handled but could use help on some other big ones folks typically ask!

like

Hi Amazonians,
I am looking for guidance.

I am going to start interview process with Amazon next week. Probably all rounds will be done in 1-2 day time frame.

How/what should I prepare for interview?
Am clueless on what kind of ds & algo questions, system design questions are asked in Amazon interviews.

My techstack: javascript developer- react+Angular.

1. Pls guide me on what/how to prepare?
2. Also, will the interview be solely on da & algo and javascript; or on Js frameworks?

Amazon

like

For those waiting on Columbia regular decision, I think they’re rolling out interview invites. Just got mine 😁 good luck to all!

like

Why it is so much difficult to switch for heigher experience people. I m having 11 yoe.
As per experience, in current organization working as a lead. Have experience in many of the Java technologies. But when I told I worked it 7 years back every thing vanished and like I'm fresher. They don't even bother to ask questions.

They want web services development, hibernate, react, angular, node. We can't work everything at a time right?

How do you guys tackle this in interview.

like

Currently on an F-1 visa & wondering if any of the firms are hiring foreign students. In the last 6 months, during interviews, I’ve been told I can’t be moved to the next step cuz of my visa status.

Interviewing with Nickelodeon next week. Anybody worked for the NYC office before? What’s the vibe?

like

Anyone gave interview for Tesco System engineer profile?

like

Experience with vestas data analyst interview ?

like

Trying to pivot into a PM role and as a pre-interview stage I am being given a UX task to provide an actionable insight to their sign up journey. What could they be looking for specially - I want to be able to stand out from other applicants

like

I gave a technical interview at Nagarro 2 weeks back and it went well. I have not heard from them since, not even a rejection mail. Tried calling the HR PoC and they did not answer. Why am I being ghosted? Does this mean I am rejected?

like

Hey TW,

Is there a HLD or LLD or both design rounds in java dev interview?

like

Hi Fishes,

My Interview for 
Accenture  scheduled next week. I'm SAP SD Consultant with 3 years of experience.

Any suggestion or tips for interview??

like

Hello! I had 3 interview rounds for a Program Manager role at Amazon. The 3rd round was conducted last Thursday. I have yet not heard anything from the recruiter. Does it mean that I am no longer considered for the role?

like

Hi All - I have a final round case presentation coming up. I have to chose a company and create a 5-6 slide deck on how the company I’m interviewing for could implement its’ solutions to improve revs/profits at the company I chose. For people who have done this with success, do you have any tips? What was your approach with the deck? Did you use their branding/colors? Did you keep it simple or try to impress with your PowerPoint skills?

Any help is appreciated! TIA!

like

How much difficult it is to switch from Microsoft IDC to Microsoft USA by applying through IJP.

like

What questions I will face in Product management interview any tip.

I have an interview with Bloomberg in ESG domain

like

Interviewed recently with @VillageMD. Anyone have any insight about the remote Medical assistant positions? Preferably someone who does or did work in that type of position with this company. How was the workload? How much time is usually spent on the phone answering calls?

like

More Posts

Recommendation on books/material to improve communication and debate skills

like

Insurance company just denied my prior authorization for IVF due to high FSH.

I can't afford paying it myself. I’m 40, it’s like my last chance of having a child in this life is vanishing. I am heartbroken.

like

Advice for emotionally immature parents? Really tired of always being blackmailed or guilted for not agreeing with my parents for anything they want.

likehelpful

Hi All,

Any update on WFH continuity?

like

Anyone sold their lease to Carvana? How was the process?

like

FAANG interview last wednesday. Was asked my availability for second round the next day to take place anytime tomorrow to next Tuesday. I sent it in ASAP but still no response. It’s been 6 days. Is there the possibility they cut the role/interview?

like

How many teachers feel like we should postpone school until September 7?

like

Www.helenesnotes call now to sign up for the fall! 516-474-6181 Online lessons! Give them or yourself something fun, positive and good to do! All ages 5 and up including Adults!

Post Photo

Riding home from the office only to do some more work when I get home. Ehhh...

like

Accidentally matched on Hinge and going on a date with a coworker (I'm at B4 so higher chances). Set the expectation that we shouldn't try for anything unless there are major sparks. Is this a good idea?

like

I recently graduated with my graduate degree and have no experience in HR but I want to change fields. Any advice on how to go about doing that?

like

Is there such a thing as the "advertising blacklist" of people not to hire? Is it a small group of recruiters who know each other real well? Or is it an Illuminati level secret?

likesmart

How to keep mother and MIL apart? Wedding in 7 weeks, moms hate each other. Both sets of parents live close by.

Dreams of having them all get along in the future have been reduced to dust. Now just trying to make it through the wedding and keep them apart for the rest of my life. And pray they let me and my husband build our own lives.

likefunny

In the recent year, with people switching and landing up at a higher package, i observed most were men. While i have put in lots of hardwork and learnt a lot consistently, still face the pay parity. Want to know if women here have similar experiences.

like

Any recommendations for white linen button ups for summer? Price range $80-140. Looking for that kind of light & flowy / beachy style like you might see someone wear at a nice resort in the Caribbean or on a yacht.

like
like

Are full guaranteed year end bonuses pretty standard in big law lateraling around this time of year?

like

All the lions 🙌

Post Photo
likefunnyuplifting
like

What is a JL6 PM salary range in Infosys?
What is the yearly bonus component in it.

like

Additional Posts in Excel Genius

Ok, using excel is not a primary function for my role (this will be very obvious shortly...) So please be kind! On my sheet, in the first and third columns, I have lists of reference numbers. In the second column I have a client name. I already identified the duplicates in the first and third columns using conditional formatting.What I need to find now is column 2 value, whenever value in column 3 is identified as duplicate. Problem is, I have over 120k rows of data so I can't filter! Help!

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

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

like

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

like

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

like

Anyone use teammates analytics? Does it work well with large worksheet? I am cleaning up this large Excel sheet, it's taking so long I don't even know if it's taking it's time or what.

like

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

likeuplifting

If you follow him on LinkedIn you probably already saw this! Lol 😆 but I totally resonate with the post... 🤣

Post Photo
funnylike

This is pretty vague, but what are some formatting tips n tricks for a model? I know the basics (like color code) but borders, titles, font, tables always look weird and I have no idea how to start

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

A lot of the work at my new employer is quite redundant and can be automated via macros. What are some of the best resources to learn vba?

like

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

What is y'all's preferred clipping tool? One of my former companies had a great simple program that was only like $50 and worth every penny.
Snipping Tool just ain't cuttin' it (lol pun intended).

like

Anyone know if / how to have the CapIQ and SNL (MI) excel plugins running at the same time? I always run into issues with one of them not functioning when they’re both enabled

I really need some help.
What shortcut inverses my
Ctrl + [ aka Ctrl + {
which jumps through a cell to the source? How do I jump back? Manually isn't practical for a 50+ tab sheet

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

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

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

What are the most typical models you all build

likehelpful

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

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