{ "media_type": "text", "post_content": "Does anyone know how to freeze both the top row and first column of an excel file? Thank you!", "post_id": "61a0fd784cf6dd002aedb238", "reply_count": 7, "vote_count": 2, "bowl_id": "553769a790f5eebe1d2a0f92", "bowl_name": "Finance" }

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

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


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...


To freeze and unfreeze: Alt + w + ff


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

Thank you so much!

Additional Posts

Who’s responsible for the Oatly campaign that’s taken over the city? Follow-up question: how can we convince them to stop?


What do we think about the Tudor Royal? It’s like a Daydate or Datejust (depending on the size), on a Royal Oak bracelet and with that funky bezel fluting/knurling. And no cyclops.

Post Photo

For those who have therapists, how did you know that they were the right one? I've just started therapy because I've always felt like I'm not good enough at my job. This imposter syndrome before was tolerable but now it's changing how I view myself entirely. I just want to find a good therapist that will get me out of this mindset 😔


Anyone here from KPMG Toronto IARCS? I would love to know more about what is done in that dept, what your day to day work looks like, work load, working hrs and salary

Hadn’t noticed this sub before, and most of the threads are old so thought I’d ask a follow up - how has everyone been handling parenting with public accounting? I’ve got a toddler and my wife is an accountant (industry), and we only have a few immediate family in the country- but they have health concerns. Busy season was rough, things are looking better now as things return to normal. Still working crazy hours if you count the daycare duties on top of utilization targets.


Some rules recently changed regarding 529 accounts. Anybody using this to pay off their student loans with tax free money?


Is it wise to spend my money to buy a rental property instead of using that money to build a bigger stock portfolio? Found a great property to become my 1st rental property.


Anyone tried fugu? (Puffer fish)


Need gift ideas! I’ve been crashing at two of my good friend’s place for the past month and a half and I want to get something to thank them for letting me stay/holiday gift. Budget probably in the $100–150 range combined for both of them. They are both pretty outdoorsy 24 year olds so I was thinking something along those lines but can’t think of anything. All I have so far is a nice bottle of scotch. Please help!


Any ISSOs here?


Where do you live, what is your title, what is your salary? Include employer if you want. UX Designer, Toronto. $73k CAD


Had my first psilocybin mushroom experience this weekend. It was an intensely emotional experience that was therapeutic - helped me process a lot of stuff that I had been repressing.


Here's all you need to know about 2020: One candidate thinks violence and chaos will be good for his electoral chances. The other doesn't.


I have heard Deloitte cut recruitment and had layoffs this year. But their revenue and headcount number online show increase. Could anyone explain what's going on in Deloitte? Is it industry wise prob


For anyone who had a rough week please use these drink vouchers and just let me know it got used. Cheers ladies!! 🍷

Post Photo

Fun question - what non-FAANG companies get posted about in this bowl way more than you’d expect based on their size, prestige, etc? My answers would be DoorDash (by far 1st) and Capital One. Not that they’re bad necessarily, but see so many Qs about them.


Anybody pursuing a side hustle while on the bench?


Do companies count college years as part of experience if I was interning and freelancing nonstop as a student? If I graduated a year ago, can I apply for positions that ask for 5 years of experience?


Has anyone been invited to sit on a board of directors for small to mid-size companies? If yes, what process do you go through to get approval from your current employer?


Hi, Could you please let me know the Salary range for a Project Manager in Deloitte Consulting in Singapore and Malaysia ?

New to Fishbowl?

Download the Fishbowl app to
unlock all discussions on Fishbowl.
Download Fishbowl to see what others are saying
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


Embed this post

Copy and paste embed code on your site


Download the Fishbowl app

Get realtime notifications and see
what's happening in your industry
from the palm of your hand.

For account settings, visit Fishbowl on Desktop Browser or