What are some Excel keyboard shortcuts you can't live without?

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

Ctrl + Shift + L = to apply Data filter

I probably use that at least once a day and sometimes way more frequently. I look at a lot of reports though…

like

Came here to say this one.

like

Alt+F4

likefunnyupliftinghelpful

Alt+e+d = delete row/column
Ctrl&shft&+ = add row/column & paste what you have copied (quick and saves a step)
Alt+h+b+s = outside border around your highlighted cells (instead of s can swap for any option)
Alt+m+v = step by step of the formula in your cell (so you can see where something is miscalculating)
Those are the main ones I’d instantly think of! Also alt+h+v+v a classic paste values

like

I'm a fan of ctrl-shift-v for paste values myself, but all the alt-... shortcuts are all pretty neat

like

Some of my go-to shortcuts

Alt, H, O, I to auto-adjust cell width
Alt, H, F, P for format painter
Ctrl + Shift + pg up/down to scroll through worksheets in a file

like

Copy and paste is a staple, but it can get tedious. My favourite known time saves are:

CTRL+SHIFT+ArrowKey/Home/End for highlighting through to the beginning or end of rows/columns (ArrowKeys) of entire chunks of data (Home/End).

CTRL+SHIFT+V to bring up the Paste Special menu, always followed by a shortcut letter key for whatever I'm pasting, and then Enter. Most commonly for me:
V for just the values
F for just the formulas
T for just the cell formatting
W for just the column widths

like

Ctrl+1

like

For me, the more basic ones are a lifesaver, anything outside of that I do struggle remembering and usually have to go searching anyways. Undo and close/open workbooks are easily my top three shortcuts I use when working in Excel. Anybody have a lesser known one they use all the time now?

like

Ctrl + semi colon for current date

likehelpful

Ctrl + Shift + ArrowKey, Ctrl + A, and Ctrl + D/R

like

ALT + D,F, F, filtering

like

Alt + H, S, F also 👍🏼👍🏼

I'm like Consultant 1 and love the basics, like Ctrl+shft+arrow keys to highlight rows and columns with data quickly instead of highlighting the entire sheet.

My others have mostly been listed already.

like

Shift+F2, “pls fix”

Ctrl + [

Ctrl+C
I believe we can't do without this shortcut

Related Posts

Does anyone work in project management advisory? If so, what’s it like compared to audit? I’m interested in a role at PwC. Thanks!

like

Hi everyone, how is OW in the middle east?

In terms of culture, career progression and projects?

Are their projects more into strategy or how exactly?

like

Alston & Bird LLP Does anyone have any insight into associate pay, bonuses, min billable hours, and general work/life balance at Alston & Bird LLP? (DC Office)

like

Creatives who left for tech. What is it exactly that you do now? Is it still writing or art directing? Or a different creative role? Hearing about people leaving for tech so I want to know what it means exactly aside from the benefits.

like

Hi all, recently in touch by Spotify recruiter for a Sec Engineer position for remote EU and was told that range was 60-80 out of base salary and equity. Had 2 years of security experience out of my 4 years. Was also told that there is no bonus scheme or no sign in bonus 😕 Not sure how I feel about this tbh.

What do you think?
Spotify

like

Hi Fishes,
Please share your reviews about BOLD Technology Systems,Noida.How is work life balance and work culture?

like

Hi fishes,

TCS Hr said to expect offer letter by Feb 7 if business approval goes through.
Or she would have to come back and negotiate.
I didn't get offer till now.
How can I check my status?
It shows evaluation in progress in ibegin portal.

like

Equity research associate considering to pivot into IBD. Is this a wise choice? Heard ER is an exit for some of the IB folks out there.

like

Currently an analyst-level consultant working with a client that has an investment banking division. Since I have access to internal systems, could I reach out to bankers for networking from within using those systems? Or would that be too aggressive? lol

like

Can someone refer me to PayPal?
Job id is R0089926

#LTI - Larsen & Toubro Infotech is hiring for multiple #Data job profiles.

Interested for below jobs opportunity can DM me with Jobcode
4+ Yrs exp

Python developer -JR Code 957669
Azure Consultant -JR Code 446367
Data Science Consultant -JR Code 446347
GCP Consultant -JR Code 446327
Abinitio Developer -JR Code 446287
QlikView/Qliksense Consultant -JR Code 446267
Bigdata - Pyspark/Java+Saprk/Spark+Scala -JR Code 446247
Snowflake Consultant -JR Code 446227
Informatica Consultant (MDM/IDQ/PC) -

like

How is rnd department for java developer in netcracker?

Is selling feet pics an unethical side hustle?

likefunny

Looking for referrals for PwC Australia ..

Thoughts on CVS Health?

like

Hello Mastercard employees. I have been trying to break into MC for long now.

I have 2 yrs workex post MBA. I have experience in data analysis and consulting. But I don't want to get into consulting anymore. I am looking for analytics roles. Anyone here would be able to DM and guide me on the available options at Mastercard?
Location: Gurgaon

like

Does wipro accept a counter offer? And revised with a fresh offer?

like
like

I understand a CofC is triggered in an equity deal, but is that also triggered in an asset deal (along with assignment, obviously)?

like

You know you've made it when _______________ .

like

Additional Posts in Excel Genius

What’s the keyboard shortcut to get into the “insert options” dialogue when you’ve inserted a new row with Ctrl+Shift+Plus?

like

I’m verrrrrry new to excel and am going crazy because is there not a way to “clip” text in cells like you can in google sheets? I read about a “fill” option, but then noticed that cells that aren’t filled just repeat text. 😂🤯

like

Is there anything similar to the INDIRECT function that I can use to build a formula reference to another workbook? INDIRECT creates errors when the referenced workbook is closed..

like

Does anyone have any tips/tricks for knowing where to plug +1/-1 in a large table with totals across the y and x axis that contain un-rounded numbers? Every time I fix a row I throw off a column or my check figures to the true data source.

Post Photo
like

What are your top Excel ninja tricks? Ones that few people know...

like

Does anyone know any shortcuts for the “Refresh All” button without having to always click Data->Refresh All every time I want to refresh the live data? For a Mac btw pls thanks!

Post Photo
like

Anyone know what these badges are?

Post Photo
likefunny

Hi Group, seems like it should be basic format, but I just can not get it to work. a list of data and want to alternate shade (blue,white,blue,etc) each line but if I have multiple lines I want to group together and they all shade the same. I want to group by the same data in column A, and the number of rows that are the same could vary. So let’s say row 1& 2 same entry in column A(blue) row 3 different (white) row 4,5,6 same as each other different to other rows (blue) etc… help 🙏

like

Still don't have xlookup. #fomo

like

Is there a way for me to automate creating columns to do this so I can drag across and create my columns? For example--
1Q2021 2Q2021 3Q2021 4Q2021 2021 1Q2022?

likesmart

Anybody know if there is a way to automate a Gantt chart in excel when building out a roadmap? Essentially want to recreate the functionality of ms project because my client does not have project and wants a nice visual for the roadmap

like

What are your top excel functions you use in finance / accounting - besides vlookup - Pivots - sumifs - count - index. I have an interview coming up which will have excel based technical questions. Not sure what other functions are considered important in the accounting finance world.

like

How do I set the formula to calculate “If x falls between 1-10, return 1-10, if it falls between 11-20, return 11-20, and so on”

like

Best websites to get more of a handle on Excel as a beginner-intermediate?

like

How can I copy a formula from one sheet to another?i tried the simple Ctrl+C, Ctrl-V, but the formula refers to the old sheet.

like

How do I easily find any cells that are hard coded vs formula? I have 10,000 rows of data and column F is supposed to be a formula based on columns C and D, without clicking into all 10k cells in column F how can I make sure formulas are there and not accidentally hand keyed over?

like

HELP!
I have raw sales data on one tab, which includes a sales rep ID number. My second tab has that sales rep ID number in column 1 and the rep name in column 2. How can I get the rep name added to the correct line items in the raw data?

EY trying to move away from Excel . Think it’s possible? Want to see it happen?

like

Is there a way to identify duplicate URLs within labeled hyperlinks on multiple columns/rows/cells?

I was thinking conditional format, but it’s identifying duplicate labels. I have over 80,000 cells, so extracting URLs manually isn’t going to work for me.

Thanks in Advance!

Does anyone know what purple tables mean in Excel?

I know about green and orange, but never saw purple before and trying to figure it out.

likefunny

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

Scan your QR code to download
Fishbowl app on your mobile

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