Does anyone know how to freeze both the top row and first column of an excel file? Thank you!

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

There are 3 options in the drop down for freezing things in excel... I believe in you

funnylikeuplifting

If you select a cell and click on freeze pane, everything on the left of that cell and on top of that cell will be frozen...

like

To freeze and unfreeze:
Alt + w + ff

like

This is the right answer. Have cell B2 selected to hit row 1 and column A

Thank you so much!

Related Posts

Hi fishes. Can someone please tell me if BCG India has a cooling period?

like

Thoughts on Guidepost Growth Equity (performance, culture, comp, wlb)?

like

Hi Ladies :) Can you help me reach 11 likes. I am new on here looking forward to connecting with you.

like

I’ve been a management consultant for 3.5 yrs. I’ve done 18 months of internal sustainability work such as building our sustainability practice, initiatives to get B CORP, SBTI, tracked carbon emissions, company campaigns for sustainability awareness, sustainability strategy. I want to move into a sustainability consulting role. Which area of sustainability consulting should I look at? Are there any courses or certifications I should do?

like

Any of you married your co-worker (lawyer, for clarity) and both of you decided to stay in the same firm afterwards? How is/was it and do you recommend it?

like

How much salary does entry level consultant get at Deloitte?

like

I had an interview on Friday for a position that is no longer accepting applications as of today. I haven't heard back from the recruiter yet. Is this good news?

like

Need help! I am a working mom of 2 young kids. I have an offer for about $25k more than I make currently outside of public accounting. It’s 40 hours year round, amazing benefits, with a pension (cont)

Experienced hire, looking to practice cases over Skype. PST time Fri- Sunday, CST - Monday - Thur. Connect at fishbowlpractice3276@gmail. Weekend mornings; weekday evenings.

Does anyone have any tips/resources on how to take a deposition? I’m taking my first deposition in a couple of months and I’m pretty anxious about it. I’ve been practicing for 5+ years, but haven’t done a depo yet…

like

Thoughts on Upfront Ventures in LA? Even if not specific, has anyone heard anything about them?

like

What do y’all miss most about the airport?

like

Not cringe. Let’s think about it

Post Photo
funnylike
like

I feel at a loss at my company's direction for the next few years and it's making me so stressed about my future. I wish leadership was more clear + I had more of a voice but I feel like a tiny cog in a machine that's warp speeding towards a giant ? mark in an industry in constant turmoil.

like

We’re hiring at Havas. Looking for Administrative Assistants in New York, San Diego, Los Angeles and Chicago. Let me know if you’re interested in learning more!

likehelpful

Looking to buy a 900k condo in a prime location (3 bedrooms). We have a family income of 210k and have been approved by the bank with 20% downpayment. We have zero debt other than current mortgage but we will sell the property. We really want it, but even though we were approved I feel like its a bit over the top.. anyone has any insight in terms of our ratios?

like

Is there anyone who battles with depression and anxiety and is able to rise up the ranks to director/partner? It appears depression/anxiety weeds consultants out of the business at more junior levels

like

New CEO/CCO is Asian. Feeling empowered

likeuplifting

There’s an opportunity to step up into the role of Director of Product, but I’ve only got 2.5 years of experience and am already being paid below average by like 15%. I’ve accepted this because A. My company has historically underpaid people but I still like the people and B. My lack of experience. I think a promotion would come with a raise, but the percentage difference would most likely only grow and I’m not sure that would be ok with the responsibilities I’d be stepping into. Any advice?

likehelpful

Additional Posts in Finance

New York sarcasm is a local delicacy that doesn't travel well.

like

Hey all! So I got a job offer for 95k for a Sr. Regulatory Relations Specialist. Is this the average salary or a lowball offer? Personally, I am having a hard time finding the average role salary posted anywhere.

like

For new hire who’s struggling, will going back to office actually makes things better and easier?

like

Besides working, how do you finance pros typically spend the weekend?

like

Hey! I've always wanted to get into IB (prestige, money, you name it), however now that I'm in a more laid back environment (better WLB, "easier work") it doesn't seem as attractive as before and the pay is quite good for an analyst level (I think the pay is competitive even comparing with IB's pay in my country) . I wanted to know if anyone had the same experience and what were your thoughts (pursue an MBA and leave your comfort zone and "good pay" or just stick with it). TIA!

like

I'm addicted to my phone and social media. Need serious intervention/help. Suggestions?

like

I've been to some wild brunch spots (e.g., bottomless personal pitchers, loud trendy music) in NYC. Does anyone know of anything similar in LA?

like

Friday night NY... who's up to meet at a cigar lounge and exchange the week's war stories?

like

What are some side-hustles you do in your free time?

like

Ladies, need interview suit recommendations for a non-vanity-sizing size 4. Thoughts?

like

Bose QC35 or Bowers and Wilkins P7 Wireless? I got a gift card this year and trying to buy solid headphones for train, traveling, etc. I really like them both.

like

Is there any experienced insolvency Admin in this bowl?

like

Tips on analyzing the benefits and risks associated with long-term investments in the stock market? In normal times

like

How are you chillin fish?

like

Good morning let’s have a beautiful Thursday. Here is my question I want to somehow break into Asset Management and I am having a hard time doing it. I have 1-2 YOE and Finra Licenses SIE-6-63. In all honesty I just want a better pay and avoid taking calls all day, I’m fine with a few calls a day but back to back calls is exhausting. Thanks for any tips!

like

Does Citi usually drag their feet with the offer process? I received an offer two Fridays ago and the recruiter went to the hiring manager with my salary request. They countered my salary request last Tuesday and I countered back in between both numbers (only a $5000) differential. I reached out to the recruiter yesterday and she said she would get back to me very soon. Wanted to make sure I’m not in jeopardy of losing this offer for negotiating? TIA

like

For those with significant others who are healthcare workers, how do they react when you are having / had a bad day? I feel like they think they have it 1000x worse (which could most certainly be true) but our job is also stressful/challenging just in a different way? Agree?

like

Uber driver awkwardly asks if he can ask me a question. I say, "Sure." He says, "What do you think is the most important thing in life?"

like

Anyone know of a good resource to learn how to analyze CIM’s?

like

DM me for a referral to EY or EYP if you have over 1 year of professional experience. Great pay, most positions are location-flexible, and they are hiring like crazy.

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