What Excel shortcuts save your life on a daily basis? I feel like I could be doing things faster, I just don’t know how. Makes me feel old, lol.

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

***Ctrl+S every 2 minutes***
1. Selecting multiple cells using combos of Ctrl/Shift/Alt + direction arrows/"Home"/"End"
2. Pasting as values: Alt + E>S>V
3. Text to columns to change numbers stored as text into numbers
4. Grouping columns and rows instead of hiding them
5. Pivot tables:
a. Create: Alt > N > V
b. Refresh: Alt + F5
c. Stop columns width from adjusting to content: right click > Pivot table options > Uncheck "Autofit column widths on update"
6. Insert/remove columns/rows: Ctrl + or Ctrl -
7. Customize the top ribbon to your most used functions (eg, I've got (un)filter, copy format, (un)group, text to columns
8. Find: Ctrl+F
9. Replace: Ctrl+H

Also, Google has very creative shortcuts and answers for almost any of your problems :)


There's a function that highlights all duplicates in red. Makes it that much more easy to do busy work


I use ctrl+f to find things every single day. Some of my spreadsheets have soooo much info on them that it becomes hard to find what I am looking for.


This is a great hack.


Control + K
Adds a link to another file on your spreadsheet

Easily rename a folder when selected on it

For easy adding. Select the cells you want to add up. Look at the Right hand corner. Click on “Sum:” it’ll copy the total to clipboard.


I feel like I'm about to save so much time with this!

I'm all about hiding stuff I don't need to see and freezing cells so I don't have to endlessly scroll. Also second the Ctrl+S every 2 minutes, as someone suggested above. Can't tell you how many times I had to redo a bunch of work because my laptop crashed and I hadn't hit save in awhile.

Auto size width: Alt + H + O + I
Open dialogue box: Ctrl + P
Find and select: Alt + H + F + D
Create new sheet: shift + F11
Spell check: F7

Also best practices: don’t be a douche and use merge and center (always center across selection)

Quick access toolbar
1) top border
2) right border
3) font color
4) fill color
5) font size
6) create chart



Alt+shift+right to easily group. X lookups as well! Although that’s not a shortcut really.

Alt + ⬇️ to open the dropdown on a filter. “E” to jump to the search box you can start typing right away. In pivot table filters, you can start typing as soon as it’s open

And Alt + = in the cell directly beside a range to autosum said range

These are all great, thank you guys for all the advice!

Alt + H + N + N
I had to think hard to remember what the actual keys were. I highlight cells that need updating, once updated, this clears the full colour.

Another one I use, which probably won’t help you is alt + 7 which for me is a query refresh that I have added to the quick access toolbar. A button in smart view add in

When in doubt, just tap Alt and every combination of keys will highlight… identify the ones you use the most and write them on a sticky note until they are burned into your subconscious

Related Posts

Anyone feel frustrated at times with the super aggressive sales personalities we deal with? My AE is always pushing on every ask no matter how minuscule it is. My vp is super anal about anything we do. I understand these guys pull in huge commissions and bonuses that’s why they are so motivated. However what I personally feel is they just nag us until we do the job according to their spec. Just venting……anyone else feel the same?


I’m getting ready to start my FT position as a HUC (Health Unit Coordinator) in Labor and Delivery. I know it will be a while before I do anything of the sort, or IF I do anything of the sort. But I wondered if there were any other HUCs on here who crosstrained? (Wether as a PCT Patient Care Tech, Medical Records, or Telemetry?) was it worth it?


Is there anyone here who can be kind enough to review my CV and give some brutal feedback?

The more I look at it the more trashy it looks. I would really appreciate a fresh perspective



I have recently given interview at Microsoft.
HR provided the feedback as I am not rejected bit not fit for the role so they have put me in talent plus pool. What should I expect next and does this mean that I may get the offer ?


For the crazy ones out there, what are your strategies for deep OTM calls? How do you research and pick them? How do you factor in time while holding them?


If I have the opportunity to transfer into TAS from audit should I take it?


Director of Marketing wants me to write some conversation snippets for a chatbot, but I think those things drive potential clients away. Trying to figure out if I should tell him or not


Would you recommend your agency to other creatives?


Hi Sharks,

I have attended my interview for Infosys yesterday but there are only 30 days left in my notice period, will infosys could complete all the process and release my offer letter before my lwd in my current organization ?

Please suggest ?


Hey Fishers,
I am looking for a Job change as a Java Developer. I have 1 year and 10 months of experience in Java, Spring Boot, and AWS. Please help me with the same if you have any openings for me in your team or at your Organization.
Thank You


Any thoughts on BGB group?


All, I have a offer from TCS for 17 and Tech M with 18 ,

My major query is related to Back to office. Which company gives the flexibility to continue working from Home? My wife is 6 months pregnant so I want to continue work from home for atleast next 1 year.

Insiders please answer. When I ask HR they just say for now it's WFH only. That's it. Need to know which company pressures more to come to office


Anyone part of the social clubs in the DC area? Do you find it to be worth it and are there any firms that get you into any of them?

Exl vs american express? Which is better overall


I currently work as an associate marketing manager for 2 years, I previously worked on the financial operations team. My manager was very patient and trained me in all our systems and my tasks. This was also during the pandemic so a lot of calls, sharing screens on teams. She was very hands on but I took as because I'm younger, new in the digital marketing world and she making sure I was set up for success. Fast forward to 1 year and half she became a helicopter manager.


Any CAIA holders out there? How have you generally been viewed?


ODD vs. HR M&A
What are these (what do the roles entail), and how are the hours and pay? Thanks!


Although this is clearly evident and well documented, it was very interesting to hear directly from the mouth of a Rolex AD VP that lists aren’t really a thing and they sell to who they want (spend history NOT being the only factor).


hi lovely people! my friend finished up an AD internship at deutsch and has since been searching. she’ll be visiting london, paris, & NY in the coming weeks and would love to meet with anyone willing!

Additional Posts in Finance

In honor of TBT: would you take the blue pill or the red pill?


What corporate/commercial banking position can a financial advisor transition to while still preserving VP title and compensation??


Thoughts on open relationships - has anyone ever been in one? Was it successful?


Husband and I are in a HEATED debate…when raising kids, who is generally more expensive - girls or boys? I say the girls, he says the boys…for reference (if this matters) I have one younger brother and he has a twin brother.


Outdoor Voices being a consistent loss maker is not surprising. What is supposed to be their unique product? A green T-shirt.....


Guys... This is it... DM is here. Go.


Any parents here? How does having kids affect your career trajectory? Best time for this?


If you go to banking post MBA, what’s the expected difference in position/pay if you were analyst for 2 years vs no prior banking experience?


What are the good bars these days for analysts?


Bankers are increasingly reluctant to give commodity traders in Asia the credit they need to survive as the lenders grow ever more fearful about the risk of a catastrophic default.


Closest you’ve come to quitting on the spot? Constantly panicking on this deal and am selfishly looking for stories to tell myself “hey your situation isn’t that bad”


Parents: What did you do for infant care after maternity/paternity leave is over and both parents want to go back to work? Work part time, nanny, daycare, combo?


How many of you doing CFA are in front-office IBD? If so, what is your rationale?


Random question – has anyone visited any of the wineries in NY? Looking to do something a bit different this weekend.


If anyone needs a cfa tutor Dm me. I tutor all levels.


anybody working as a corporate actions specialist? Any tips for interview prep? was told to have some basic understanding of excel and SQL and have a good foundation of how corporate actions work.

Should I be worried if I haven’t heard back after a final round interview at citadel after 6 days? They said up to 5 business days is typical but today is the last day and I’m getting worried...


Good questions to ask in an interview? I’m rusty

I scored in the 70's on the CFA practices and felt like I did really well on the exam but still failed. Has anyone had issues telling their coworkers they failed? They emphasize the test so much here.


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


Embed this post

Copy and paste embed code on your site


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


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