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

My lease renewal papers just came through and it’s approx 18% in Chelsea NYC. Any advice on how to go about negotiating? My previous leases (at other apartments) usually increase by $50 so I’ve never had to negotiate before. I’m terrible with these things. Any help will be appreciated.

like

LinkedIn Premium Business for 6 months - Flat 85% Off +Extra INR 200 OFF for Fishbowl users. Connect and message (contact only if you can connect with me on linkedin)

Post Photo

What's the industry's view on the CISM cert? I know the CISSP is like the gold standard but what about the CISM? Lots of higher level roles require one or the either so it seems like there is value?

likehelpful

I am second year PDM II in Deloitte and my base package is ~125 K. Is this fair or should I expect more base on market adjustments?

Anyone in here hiring for senior design roles? I’m on the hunt! Open to contract or FT!

like

Hi Fishes,

Please let me know, how much in hand salary,
I can expect ?

Thanks

Post Photo
like

Commercial Lines agents who function as account managers & new business sales - what are you seeing for salary? Commissions?

15 yrs exp & 12 with the same independent agency / 8 yrs in PL and moved to CL 4 yrs ago. Still writing and servicing both PL&CL.

like

Howz the work life balance of a Senior Consultant in tech consulting in a client facing role in EY India?

Skills: Java 8, Spring Boot.

Please do answer with respect to EY India only.

Role will be as a tech lead in java development team.

Client probably HSBC.

Few days left in Notice Period.

like

Hi guys,
I want to inform you all that with your help I was able to clear the Hirevue round of Deloitte New Grad position 2023 and now just final interview remains. Thank you guys, you made it possible.
The role is technical strategy which I guess comes under SAP so the SAP team will be taking the interview for Toronto location.
The interview will have 30 minutes behavioural interview questions and 30 minutes case study.

I’m looking for tips now guys. I really want to clear it. Please guys.

like

Anyone recently joined Accenture and just hardlock to a project with no work? How long does it takes to get allocated to project ?

like

at what title does it become appropriate to wear a “nice” watch to work? (Rolex, Omega, etc)

likefunny
like

I still think about you 😬

like

Hi Fishes.
I’m an L4 IC. I just got promoted to L4 in an off cycle promotion. It’s been only a month and since it’s a CS based role we work in Night Shifts. I feel monotonous within a month as it is a Virtual role.
I started to look for roles in JobFinder. The HMs are okay to consider, but the thing is “How do I say it my Current Manager??”
Can anyone give a subtle idea, such that my Current manager agrees even though its a month only?

like

So incredibly excited that we will be honoring Keni Thacker with this year’s Bill Sharp Award. Keni embodies the spirit and legacy of Mr. Sharp in such an incredible way.

Post Photo
likeuplifting

Does anybody find Sneako hot? Forget if you are for or against his views, just by his appearance do you think he is hot? I feel like he hypes himself too much and tries too hard to be like the Tates. He is a follower not a leader. He doesn’t seem genuine or believe in any word he is saying.

How to know our current CTC in WorkDay in IBM? Could someone please tell the steps.
TIA
IBM Consulting

like

Any suggestions on best restaurants for a Rostov evening with wife on/near time square?

like

After orientation till my training starts, what I will be assigned in ey gds?

What percentage of time do you feel in control of everything and what percentage of time do you feel like you’ve lost your mind? About 50/50 here.

like

Additional Posts in Finance

Thoughts on CAIA? Difficulty, hours studied, study tips, overall experiences, etc.? I’ll be sitting for Level 1 in September. Currently work in the fund of funds space - moving over to my firm’s hedge fund research team soon so CAIA seemed like a perfect way to get knowledge in the area beforehand. I’m almost one year out of undergrad (econ background) so a lot of the CAIA content is new to me

like

Are there any other sober fish out there? How do you deal in this industry?

like

Favorite excel shortcuts that many of us might not know about?

like

Why can PMs effortlessly land new firms after being let go by previous firm? Didn’t think finance is about second chances?

like

What do you think will be more common in 20 years: AI or VR?

like

How many of you golf? And what's your favorite golf course that you've actually played on?

like

Any implications of resigning effectively immediately if you're still on probationary period? Leaving the industry completely for another opportunity. Shitty I know but can't afford to turn this down

like

How did you know when it was time for a change in your career?

like

Just finished reading the book "The One Thing" by Garry Keller.....highly recommend! Has anyone else read and found it inspiring?

like

How long does it take 'till you feel like you're good at the job?

I just got laid off and I just don’t know what to say “if” I ever get an interview. Any tips would be appreciated. I know when you get laid off, no one wants to hire you.

at what title does it become appropriate to wear a “nice” watch to work? (Rolex, Omega, etc)

likefunny

Search firms are worthless for sell side lateral moves, no? They literally only send me jobs the company already posted online.

like

For the introverts, how do you (politely) set an expectation that you don't want to attend team hangouts beyond once a week? Current team dynamic is sensitive so prefer to avoid a direct convo.

like

What are the best ways to increase my assets and decrease my liabilities? Specifically for the age range: 21–30, paying down my student debt, need to pick my next investment targets

like

Banks don't generally hire at Director level for IB. True statement?

like

God damn I'm too young to be balding already. Should I shave it? I'm relatively fit and stylish.

like

Gym before, during, or after work?

like

Is fishbowl not monitored?!

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