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

JPMorgan Chase Is there anybody here in JPMC UK office ? Mainly Engalnd.JPMorgan Chase

like

Got an offer from Microchip.
Can someone share some reviews about this company. Like the hikes, culture, wlb, office.

Thanks in advance

like

My friends and I when we go out

Post Photo
funnylike

Anyone gone through Amazon AWS’ military apprenticeship?

like

Do you think required ethics CLEs are worth anything? Any good recommendations?

McKinsey & Company I am joining the McKinsey & Company Boston office in late July and searching for housing in the meantime. If I could get some insight on the ratio of days in the office vs work from home that would be super helpful!

If I need to come into the office regularly I will try to find a place close by.

like

Hi! Anyone at Optum or UnitedHealth Group willing to provide a referral?

Thanks in advance!

What should be the salary of a senior seo manager at a decent sized agency in Toronto. I am being offered 110k base + 20% bonus for hitting retention and revenue targets.

I have 8 years of experience in SEO, SEM and paid social

like

Curious to know what you've seen as working to non working dollars split in Canadian agencies. Reference any specific brands (or categories) if you can. I'm used to seeing the conventional 15-20% split for non working (production dollars only, not including media budget, agency fees) but are those days gone now with the takeover of digital (vs traditional) ad placements?

like

Marriott or SPG credit card (for the sign on bonus)?

like

How is hcl GIT vertical?

I got offer for senior manager profile.
Offered 32L
Yoe: 11.5 years

Hi 👋,
Anyone aware of hike percentage in CBA ?? and CBA is giving company shares to employee??.

like

What’s the general guidance on the order to maximize retirement contributions for tax benefits for an normal individual and for a self employed/small business owner before moving to taxable accounts or alternate vehicles like cash value life policies?
I’ve seen for individual: match trad 401k->match roth 401k->max roth IRA->max trad IRA->max trad 401k->max roth 401k->max HSA
For self employed: max SEP IRA/solo 401k->max roth IRA->max trad IRA->max HSA

Of course situations differ but in general?

like

“Circumcision makes your dick look like it’s wearing a tailored suit. Circumcised is James Bond. Uncircumcised is James Out-On-Bond"

likefunny

OH: (RE: required meeting attendance)

"Ok, fine. I will say yes now but fair warning I may fake my own death beforehand."

likefunnysmart

Nagarro OR Deloitte which firm is good for interesting big data products? And which firm has better work life balance?

like

Alright, Fishbowl - whats the juiciest gossip you heard this week at work?

likefunnyuplifting

Anyone in here with a masters degree on the business side of entertainment? What type of salary do you usually negotiate for as a coordinator or manager or director?

like

Interested in everyone’s opinions on replica luxury. I ask because, as noted in the previous thread re: Chanel’s price increases, the quality of authentic luxury bags is going way down while the price increases consistently. Specifically Chanel and LV. I’m fascinated in the online rep community and it looks like rep quality has increased exponentially (with genuine materials and 1:1 markings, stitching, hardware, etc). What’s your argument for or against replicas?

like

Additional Posts in Excel Genius

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

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?

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

like

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 change line style@back to default on excel? Accidentally click on one, and now it wants to use that style every time. I just want to be able to use the ones in the typical drop down

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

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

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

Any book recommendations on excel modeling for real world business applications?

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

I am trying to recreate this without the numbers at the end. Any advice?

Post Photo
likehelpful

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

Vlook up isn't recognizing a couple of cells even though it's feeding off a pivot and when I check with an " if =" it comes up as being the same.
Any advice on what I need to check?
Thanks

like

Will need to migrate to office 365 soon. What’s the difference for excel from the 2013 version?

likehelpful

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

like

Anyone know what these badges are?

Post Photo
likefunny

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

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

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

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