What's your go-to Excel shortcut that saves you time? Let's create a collective list of shortcuts to boost everyone's productivity. Share your favorites!

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

Ctrl Alt V T = paste format. Way quicker than format painter

like

Great tip!

Alt N V for pivots
Alt asd pivots
Shift alt L for adding table filters (not at computer, I think this is it)

like

First is to make the pivot
Second is sorting. You can you the short cuts for hiding and in hiding grouped cells to sort on different columns
Last adds the filters to any table (not for pivots)

Ctrl Shift Arrow Key - never drag and scroll again!

Related Posts

Hello everyone currently i am working with TCS i have also visited onsite from this working since 2018 overall i have 5+ years experience with very less package i dont see any growth in package. i have experience into customer support technical support identity and access management resource management timesheet management etc i need help to switch which company you suggest would be better with all the benefits

like

I’m a PR manager with 5 years of experience and have been applying for copywriting, project management and comms strategy positions with no luck. I’ve been applying since April and have only had 2 interviews. Any advice on how best to transition or what other fields I can look into?

I have an interview with JP Morgan this week for a Channel Marketing Manager - VP role in the Asset Management area. The role will be based in NYC. Just curious what is the normal range for the base salary and total comp.

like

Does anyone know which country’s U.S embassy is open to renew US visa stamp for H1B ? I know Canada closed the borders until May 31. Just wondering what other countries are good options now given the pandemic. Thanks.

like

Financial advisors—how do you prepare for a meeting with a new client? What information do you need to gather? What information is useful for your pitch? Where do you find this information?

like

Who’s getting a bivalent?

like

Longest you ever waited for an offer letter? I’ve met with a total of 5 people including the partner in charge and accepted the verbal. It’s been a little over two weeks since hearing back. They touched base with me a couple times saying it needs approval but starting to lose hope.

like

Let's talk salary.

I'm up for a raise soon and I'm at 43,000 a year. Anyone have any advice on what I should ask for?

like

Hi
Anybody from hsbc provide me a referral for sr.analyst position in analytics

Yoe 2.4
Tech: python,SQL,pbi

like

Having serious Monday blues! Who wants to talk and help? 35M in Chicago

like

Hey fishes, aside from the obvs candidates (fjord, Ideo, snook, deloitte digital, ey Parthenon, pwc consumer bit), who else is doing good work in the UX research/service design space? UK/Europe based.

like

Hi, I am going to have interview at wipro for Android Developer for Lucknow location. I have 8 yr of experience and my current ctc is 6 Lac. What salary should i ask them.

like

Today I joined the JPMC mumbai and got the offer from UBS Pune, both are providing the same package.
I want to work in pune, what should I do?
Leave the JPMC and join UBS

like

If I'm forced to use my vacation, floater, etc. towards my study leave for CFE but I have vacation booked for right after CFE, will PwC still let me take that vacation as a "leave of absence"?

like

How do you let a HH know you don’t want to continue in a process?

like

If I received 2019 income in 2020, do I need to amend my return? I just received a K-1 for a few thousands that is for income earned in 2019. Not sure if I need to amend or if I can just put it in my

likehelpful

Living in NJ and may be able to choose NYC as my home office. People who live in NJ can choose NJ / NYC office, which one did you choose?

NJ office: no NYC tax, don't have to file 2 state return. Live in NJ so auto assigned to NJ office currently.

NYC office: NYC tax on paycheck, easier commute, possibly higher pay?

likefunny

Thoughts on homage watches?

like

My team oversees internal comms and we’re in the process of signing on BananaTag.

Any fishies out there that can share what level of reporting + KPIs you’re providing leadership?

We plan to use it for exec comms and department-level leadership (HR, IT, etc.).

We’ve historically done mass communication through Outlook, so this will be our first time getting insight into staff e-mail + Teams performance.

like

Additional Posts in Excel Genius

Would anyone be willing to teach me vlookup?

like

Is there an easy way to switch XLOOKUPS to INDEX MATCH? Have a large file with bunch of formulas that don't work on all client machines (different excel versions).

like

Does 2-finger touchpad scroll not work on Excel sheets anymore? I used to be able to swipe quickly on my laptop's touchpad to navigate sheets but now it doesn't work. Based on the handful of posts I've read online about it, the problem seems unresolved. Has anyone dealt with the same issue and fixed it?

Our Data is only showing when something has changed, is there any way to make excel fill in the values?

Post Photo
like

This is dumb, but. How can I pull and average the numbers in column b associated with the 4 values in column a? So, (sum of all As/total number of As) without filtering?

Post Photo
like

How can I extract just the year into a new cell from a “yyyymmdd” cell (labeled PD here) that isn’t recognized as a date? I basically need to sort this data by year. Thanks in advance!

Post Photo
like

Recently made a job switch and have been using a lot more excel. Any free resources to help build a solid foundation / fee based courses to help improve my skills?

like

I am looking for a way to link my Salesforce data into excel so I can have the latest data at all times. Instead of the typical download of static data that by the time I am reporting the data has changed.

like

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

Anybody use a personal computer for work? How's your experience been, any horror stories/watch-outs?

like

For a linear regression analysis… the equation of a line is Y=MX+B, where M is the slope. So if I’m measuring a line across 365 days and M=.2, can I say that I have increased production by 20% over a year. Or is production increasing 20% each day?

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

Hi excel geniuses, how do I quickly copy info from one cell to blanks for same if. Semi below I have products and names, for the blank fields w same product how do I quickly copy for the rest of the blank cells?

Post Photo

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 am trying to recreate this without the numbers at the end. Any advice?

Post Photo
likehelpful

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

How do I look up values from a column in a row? E.g. Values in A1:A6 in B2:F2?

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

Need help building an electric schedule for a production schedule with a Gantt chart style view (sort of)

Currently have an excel list with resource (production line), start date and time, and then also the name of the item being produced.

Any ideas how to tackle this??

I’m thinking a stacked bar chart with the vertical categories to be my resources and horizontal the date/time and then each individual bar to be the name of the item being produced.

Thank you for the help Excel Gods 🙏

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

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