Just got a dell and getting annoyed learning new shortcuts on excel (had HP prior) - how do I automatically get to cell A1? Used to be CTRL-HOME on HP and Lenovo

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

You can change the settings in Bios if you want to flip the fn keys response. Not recommended. But that’s an alternative for that irritation. I had the same thing with HP Spectre.

like

Fn lock can be helpful while working in Excel, but it looks like your keyboard might not be conducive to that. External keyboard is probably going to be your friend. I have a super slim one that I travel with if I’m going to be using Excel a lot

helpful

I just like thinking control effin home or control effin end when I try to get to the top or bottom of the sheet. It’s the little things.

Related Posts

I have 1 year of experience in Workday Integrations. Can anyone suggest what all companies should I target if I am looking for a switch?

like

Check out KarinaCummings.com for employment assistance!

like

Travel and TTC combo haven’t worked. After 6 months, the only offer I got included 4 weeks paid and FLMA only after 1 year. So 1) go and risk laughable benefits or 2) stay but risk TTC. So shitty 😭

like

Anyone have a gym bag they travel with? Looking for some recs! Ideally something that has enough room for two pairs of shoes (lifting and gym shoes), accessories, and supplements. Durable for travel.

Does anyone have any resources (i.e. books, handbooks, etc.) to recommend for a first year in-house tech attorney? I’m currently reading the Tech Contracts Handbook by Tollen. I have found it very helpful. I review and negotiate vendor agreements for SaaS, consulting agreements, HR related engagements, and other services. Thank you!

like

Has Pfizer done away with Assoc. Director roles in favor of Sr. Manager roles?

like

My work doesn’t require us to be licensed in a particular state (i am licensed in my home country) - International Arbitration. What are the obvious benefits of getting licensed in New York?

like

What has been more beneficial to your career and why: specializing in a service offering or an industry?

like

Any west coast lesbians 29-38 want to chat?

I recently joined Swiss Re at 30lpa, pretty good manager and work culture. Got a hike of 10% in 3 months without me asking for it. But got an offer from another company which I was interviewing for before joining here and they are offering a base of 45lpa. Now I am unsure how I convey this to my manager coz I want to stay here but at the same time I am salivating over this new offer and wish I get similar numbers here. Is it worth raising a discussion? If yes what would be a subtle way to do so?

like

I had a google referral from privacy counsel for a privacy counsel role that I met all the qualifications for and I didn’t even get a screener. Feeling a bit confused. I just got an offer from another FAANG company but feeling perplexed by this rejection.

Anyone know company called

overt ideas and solutions in banglore .

like

I feel like I have way less energy now that I work from home than I did when I was working 9 hour days at the office. I don't understand...

like

Not able to clear Independence Training for new joiners can anyone help how I can clear this?

like

Does anybody else think that the Wharton Slack & Discord groups are kinda quiet/inactive compared to admit groups from other schools?

like

PV sindhu lost :(

PR Groups. Might need to fire ours. They aren’t forward thinking enough for our brand and the reach we want to attain. Small, innovative shops would be nice without a shit ton of overhead. Local not necessary. But overall creative thinkers that aren’t just order takers. Got any good references?

like

How bad is the attrition in your team/company?

like

Currently iam working as a Senior analyst in operations. However, is it good to go for Data analytics rather than continuing in the same Supply Chain field?

like

Additional Posts in Excel Genius

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

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

I created a macro to help me save time on this onetime task and now whenever I open my excel, a blank excel opens with the name of the macro. How do I get rid of it?

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

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

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

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

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

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

like

My job often has me conducting analyses where we try to identify if product launch A has had an impact on B (cannibalization analyses) but super often they are inconclusive. I feel I need statistics / rudimentary data science here. Any idea what to study?

like

I’m trying to learn more about Excel functionality and there’s several simple functions that I don’t know, this is probably one. If I am color coding data, is there a way to automatically move those lines to the top or bottom of the spreadsheet once the color code for the line is made?

like

Sheet B pulls data table from Sheet A. Sheet A is my base sheet for inputting data and will use Sheet B and other similar tabs to pull info from A and run calcs accordingly.

Question is about adding rows to data table in Sheet A. Will often have to append data in Sheet A by inserting rows in middle of data like shown/highlighted. How do I ensure the tracker ID column starts at 1 and counts sequentially all way to bottom, even with the newly inserted rows. Thanks in advance!

Post Photo
like

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

like

Hello. Quick question about formatting. I have an excel sheet with bunch of negative numbers, but some are percentage values and some are dollar values. Is there a way to make all of them have a parenthesis for being negative while keeping them still percentage and dollar value separately or do I have to target them separately?

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

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

I have 6 months left until I start my first consulting job, I want to use (and improve) my Excel skills via volunteering, where should I look to find such opportunities? (UK)

like

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

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