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

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

like

What is grm round in bosch?

like

Working on my BHA and I’m interested in becoming a lisenced nursing home administrator in NY. Is the exam difficult?

How much a product training manager can earn after 2 yrs of experience in pharma industry @palsonsderma

like

EY FDD NYC office - have you returned to the office? If not, any words on when?

like

Any one received offer from Walmart in Data Strategy & Insights department?

like

What are consulting exit options in Middle East? Just trying to see what's out there in the market and see if something makes sense. Any guidance would be appreciated.

like

Hi fishes,

Is there a deadline for accepting the offer letter in Cognizant once the acceptance portal mail has been sent?

Also if I accept and then decline later before joining, what will be the consequences? It says in the acceptance portal that the offer letter is legally binding.

like

For IP Litigation folks in life sciences/pharma - what are the likely exit options? The boutique patent lit firms don’t seem to have a lighter workload and it seems like most in house positions require tech transaction and patent persecution experience, which is not easy to get while in big law (since different groups). I am a junior associate and any advice is appreciated.

like

@other BD folks at Deloitte KPMG EY PwC - how technical are you? I got brought in to sell a tech heavy solution that combines Red Hat, Salesforce, Service Now and I feel like I’m WAY out of my depth. I’m hitting numbers now but still have a heavy dose of imposter syndrome.
Any tips on how to get more technical? Or how to manage as a non-technical person in a very technical space??

like

Did anyone ever try to do level II and GMAT at the same time and passed / got a good score?

like

Longshot but anyone from BofA in this bowl and have any insight when the return to office in NYC is?

like

I keep seeing LinkedIn posts about Chief. Anyone know anything about it? Seems exclusive yet they are trying to be more inclusive??

like

Wanted to know details on Telstra
1. Does Telstra offer work from home?
2. Does Telstra provide international relocation transfer(onsite)?
3. What would be the average salary slab for 10+ yrs exp in Telstra?
4. Does Telstra have mandatory work from office?

like

Hi fishes, i got an offer in eClerx Services Ltd. as Automation developer (L1), my YOE-5yrs, how much I can ask them as hike , since iam from Chennai i need to relocate Mumbai for this job, kindly do help me on this

like

Cocomelons dad is dead behind the eyes

funnylike

Interested in relocating to San Fran - what are the good spots ??

Planning a trip to Greece and don’t know the first place to start. I am going for 7 days in August and would love some itineraries or suggestions. Right now I fly into Athens and plan on spending a day there and then off to Santorini and Naxos. Thanks in advance!

like
like

Additional Posts in Finance

What are the biggest challenges women face in the workplace?

like

Hope everyone is staying warm and safe tonight!! #howdaysuntilsummer

like

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

like

How to get the best deal in your group

like

What crazy idea is going to make you a millionaire?

like

I’ve come to realize a large part of my job satisfaction has been working in an office and as a team, not virtually. My job satisfaction level has been diminishing MOM. Projections are that we won’t RTW until December. Feeling like I need to make a change or the downward trend will continue. Anyone else feeling similar and take any action?

like

Comparable PC alternative to a MacBook Air? Looking for an ultra-light laptop that's fast, etc... Really not into Macs though.

like

Anybody made a switch from funds to investment banking? What is your role and did you find anything challenging in doing so?

like

What is a fun thing to do at CLT airport during lengthy layover? #BAMLpeeps should know this

like

Best group in IB for hedge fund recruiting?

like

What is the average salary @JPMC for Executive director in finance/controllers/FP&A role?

like

When your damn ED talks to the rest of the team with his back turned to you expecting you to hear and be part of the convo! God damn it - learn some manners

like

Does your firm require/prefer associates to have MBAs?

like

What raises are typical in total comp at Fortune 500s? Building a long term personal finance model and trying to get a rough estimate of my income over time if I leave Finance for an excutive role at a company.

like

Serious note... When do you feel fulfilled the most in life?

like

How do you look at block chain or any crypto currency? Do you really believe in it’s future or it’s just a temporary hot spot? Not sure if it’s worth it giving up a BB job for a start up in that area.

like

What's the average age on this thing. Just wondering. I'm 23

like

I think my MD got to where he is now based solely on flattery and politics.

like

Best group at evercore?

like

Does anyone else wish they traveled more for work?

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