Looking for a shortcut key that is the equivalent of PowePoint's Ctrl + Shift + Up/Down arrow.

Essentially a way to switch row positions w/o replacing or inserting cells...

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

Best I can think of is select row, then Ctrl + X. Then select desired row above/below, then Ctrl + Shift + =

likehelpful

Ahhh.... That's really useful. Much better that what I was doing

Related Posts

Controversial opinion… I’m jealous of the covid-classes were forced to do their MBA’s online. I have no desire to do an MBA in person, but I also have no desire for people to look down on me because I got an online degree which isn’t “prestigious enough” for some people 🥲🙄

likefunny

BNP Paribas CIB does allow leaves in probation period?

Do you feel comfortable to reveal that you are a H1B worker with your coworkers? I never do.

like

Sending some good vibes! H1b extension got approved with RFE getting cleared in 14 days. These were some of the most stressful days with covid, EO and so much non-clarity everywhere. For anyone in the same boat, hang in there and you will hear the good news soon. :)

like

Anyone wanna network at gunnison this summer? 🍆⚖️

like

Renting a 3br/3ba in Lincoln Park for 3700. If interested, please DM me.

likefunny

Anyone joined nagarro from oracle, plz dm

like

I live in FL and my AC has an internal leak, landlord refuses to replace it anytime soon. Electric bills are now $300 for an apartment. He isn't doing anything about his aside from coming to the unit to see the issue himself. What type of recourse can I get this is insane.

I was laid off from Deloitte in the 18th. I have an interview with Amazon for a Senior Program Managers Non Technical position with Amazon hiring manager on Monday. Any advice would be much appreciated. I would love to get into Amazon. I hear their interview process is brutal.

like

Honest constructive advise required - I am 37, left consulting as a SM now want to come back and being asked to come in as a SM and been told in 2 years there will be a path to Partnership….should I be fighting for direct MD or should I take the SM path and grow organically

like

Is there a material difference in comp between McKinsey, Bain and BCG? I know post-MBA, they are pretty identical but does this fluctuate depending on YOE and title?

like

68 on FAR, 7 points from passing, and only one away from a meme 😩

like

Hi All, I’m closing in on my 2 year mark as a PM. I started my career with a tiny startup that was acquired last year. My manager/mentor had his role expand with the acquisition and now has limited time to push me through mentorship. Curious if others have experienced this and how they confronted their mentors/found additional mentors?

I’m bootstrapping a startup and community growth is the biggest area I’m struggling with. Is there a course or book you would recommend?

like

Anyone who gave IELTS recently,
Need help with where I can give mock exam

All things equal is the Bay Area or NY the highest paying city for remote employees? Has anyone interviewed with firms in both cities?

helpful

I want to exit to MBB but if that’s not a possibility what are the next best consulting firms? Looking for at least midsize firms (non-boutiques).

like

Does anyone know what agency did the Skip The Dishes rebrand?

like

Over the top vegan brunch - cold morning in Boston - had to make something warm and filling. Oven fried vegan chicken on a biscuit with hot vegan “honey” butter. Full credit to Atlas Monroe for the vegan chicken but the rest was me. Totally nap-worthy!

Post Photo
like

Additional Posts in Excel Genius

Is there any big advantage of using gsheets over excel?

like

Help!! Time-sensitive:
Please tell me how I can achieve this:

To create concatenation of every possible combination of Type to Price for every ID.
I provided an example below with the outcome I want in the second table. Would prefer if this be down without a macro.

Post Photo
like

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

like

Wait … xlookup is basically VLookup and Index/Match?

Is this seriously a viable alternative because what the hell have I been doing with my life?

likefunnysmart

Would someone please explain in a simple way when to use an array? Is it for every index match formula every time?

like

I’m trying to do a crosswalk of sorts. Look up a GL account number in one cell in an array and bring back a number from a specified column. Not having great luck with a vlookup. Can’t remember the exact rules (order, etc.) is there an easier way?

like

Just here to praise the Unary Operator. Old school programming trick that’s still very relevant.

In Excel it’s =--(Range =or other logic op Condition)

like

Does anybody know how to create a VBA code to automatically extract all the active data in a sheet on a different workbook without opening and manually copying to a different workbook? Ps also to create a reference cell to be able to change the file name and run macro so that it can use the reference cell to find the file and copy..

like

What is the most useful macro for my tax accounting professionals?

like

Would you rather use Excel versus CRM to store data and manage records? If so, why?

like

How much of a learning curve for Alteryx if one’s excel skills are advance? Or it doesn’t matter since both are totally different?

like

Hello Excel champs , need your help with the below screenshot. First table contains the master data with Parent and Child item details. Agenda - is it find out all the child items pertaining to make 1 unit of the corresponding parent item. In this example I took Parent Item A and exploded all the Child items and the required units to make 1 unit. Now the challenge is that I have a master data of 250,000 line items and I am trying to figure out the exploded version of all the Parent items.

Post Photo
likesmart

Right click menu. If you have a Logitech keyboard with no key to access the right click menu, press FN and F10 to pop open the menu. Very handy when you are trying to lose the mouse.

like

What’s everyone’s favorite keyboard? Thinking about switching mine up

Is there a way to add 3+ criterias into a vlookup and if there are multiple results, to list them in different cells?

like

My company has locked down our Excel so that we can no longer access the VBA Editor (it’s greyed out and Alt F11 doesn’t work). However I can still access the Word VBA Editor. Is there a creative way I can launch the Excel VBA editor via the Word version, or somehow run Excel VBA code via the Word version?

likehelpful

Is it possible to make a VBA userform that let's me interact with the workbook? I know how to create the form but default seems to be that I can't do anything else in the workbook until the form is closed.

like

What’s your Excel horror story (worst crash, worst mistake, worst there-was-a-way-to-do-this-quicker moment)? Extra points for self-shaming

like

How would I create a bar graph that shows same store sales growth for 5 products that were promoted during different time periods?

like

Story time: I was on a trip about 15 years back, doing some Excel work on a ferry ride - your basic pseudo-database work that is so common. I started talking with the guy sitting next to me and after a while he commented on what I was doing, “You know, that’s really not what I designed that for…” (continued)

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