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

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

If you mean the dialogue box to "shift down" or such, you simply have to select a range that is not an entire row.

Alt+ctrl+I

Related Posts

Hey folks, can we use our corporate sim to make make personal calls? Like do they keep a track or something?

like

Hi SFishes.

India.

I have 2 offers for
Salesforce tech, total yoe - 8yrs.
1. Deloitte usi - senior consultant
2. Salesforce - senior tech consultant.
Both are offering same package.

Which one should I prefer for long term association. Factors - WLB, WFH, Growth.

@salesforce Deloitte USI

like

Did you change anything on your resume when you have 2 FT jobs?

like

How do you guys keep a 25+ mileage per week while traveling and working 60h weeks?

like

Moving to Chicago on Thursday! How do I like...make friends

likehelpful

31 year old female here. Recently started ttc. Was on pill before. How many cycles should I try before consulting a obgyn? I want to be proactive in case there is a problem. Also, do I set an appointment with obgyn for a fertility workup? Pretty new to all this and would appreciate all advice.

like

So, some of my co-workers simply said that they want to go ahead and start something or start looking elsewhere (career change) because they don't know how much it will last at the pace we are going in regards to case intake and pay out. Should I start panicking or simply start looking elsewhere? They even they even told me if I was looking elsewhere or planned on doing so also. I found it weird in a way.

like

“Bad news, we’ve had to eliminate the position that we were supposed to finalize your promotion to. Good news, your current position is still available and the prestige of your current role is now increased”
Not the money, not the title, bonus or anything, but oh the prestige.

likefunnyhelpful

I was recently promoted, and now part of my team report to me. I'm now able to see their pay rates and I am honestly so disappointed in the company. Especially since we just gave annual raises in Feb, plus we can all see where the money is going and it's not to the employees. Makes me sick

likehelpfulsmart

Is there any good reason to take a 10+ minute call in a bathroom stall at work? Noticing people doing this as RTO ramps up and I really don’t understand why you wouldn’t go outside or at least in your car.

Can anyone share a salary range for a non-attorney with a JD and 1 YOE handling incident response and contract negotiations?

like

Recently been invited for an interview with Bearing Point. Interested to know what type of work they do in the UK? Also what is the typical working arrangement, working mostly on-site, in the office or remote?

like
like

What is everyone's current positions going to the weekend?
Here are mine:
$BA 110p 4/9
$SPY 220p 4/20

like

Anybody getting into DraftKing?

like

Infosys Consulting Hello Fishes, Infosys Consulting Infosys Could you please guide me on Infosys variables. I got Infosys offer with 20% variable. How much % we get of variable average??

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

I gained weight during my last relationship (probably around 30 lbs, and I’m 5’9”). Before my relationship, I felt like I could get any guy. But I’ve been single for 2 years now and it’s been so hard to date. I’m not sure if maybe I’ve lost confidence, but I legitimately don’t know how to get a guy to be interested. Any pointers?

likehelpful

I'm plopped on the floor buzzed, single AF, surrounded by cats, and I have no regrets tonight.

likefunnyuplifting

Additional Posts in Excel Genius

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

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

What is the best FP&A tool, Anaplan, Jirav, Planful, Vena? Any other recommendation?

like

I’m referencing a cell (numeric) to a text cell. Is there a way to format that number to include commas? See example in comments.

Help me save the day: have a massive excel file (600k rows) with duplicate records (column a, b and c are duplicate, not a duplicate if a and b are the same though). How can I filter for just these records? If it didn’t crash excel I could concat into one column, Conditional format for duplicates, and sort by color. What’s a work around?

likehelpful

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

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

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

After I set a print area, how do I showcase the page 1 - page x in the excel sheet and have the background be grey?

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

What’s the best way to summarize multiple amortization schedule. I have each schedule on a separate tab. On a master sheet can I do something where I can input a specific month and show my ST/LT ...

like

Best free data sites to tap into to build a city analysis model? Basically I want to "discover" cities with certain dimensions, like: population, elevation, climate, and proximity to other things (ski resorts, particularly)?

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

Is it possible to round a number (say rounding $98 to $100) without losing precision in following calcs? So I only want to round visually and I want the calcs from that cell to remain off the $98 not $100

likehelpful

What’s the symbol that you can type in a cell so you can input a text, but that text would not appear in the spreadsheet? I want to describe the formula without using a text box, which uses more space.

The equivalent of this is in SQL, you can use the apostrophe in the beginning of and end of a text. That text will not affect the function of the query, but that text can be seen if you proofread the query.

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

How long did it take you to become good at excel? Like fast?

like

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

like

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

Client sent over a 90 MB model this evening. Took 10 minutes to open and a fraction of that to crash. Can’t wait for tomorrow 😭

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