Anybody have a trick for really quickly coloring cells aside from ctrl + y? Would love something faster than Alt + h + h since you still need to click or navigate to the color

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

F4 repeats last action, so if you colored one cell a specific color you can press F4 on other cells afterwards

likehelpfulsmart

Incredible thank you

Related Posts

Hello, I have 4.5 years of NYS WC authorizations for orthopedic. I also have experience as a front office supervisor at a hotel. Any suggestions on a career move? I feel really stagnant where I am right now and I feel very under paid for the amount of labor I have to put in. Any suggestions would be greatly appreciated. Thank You

like

Anyone else having issues booking nights with Marriott rewards? Nothing seems available anywhere for June

like

Anyone know about realistic accommodations for a tech professional with autism, or good places for an IT guy to look? I'm looking to get away from the stress of MSP style work. IE, travel, on-sites, sales/consultancy and client relations bureaucracy.

like

Any recommendations on best travel sites to book a blue grotto tour and/or lake Capri boat tour??

After a hard reset on travel points (got none after Covid and change to industry) how would you start over? Which credit card is best for travel points? Airline? Starwood or Bonvoy? Avis or ??

At one time I had status on most airlines and hotels but I never bothered to focus on accumulating points since it seemed like they were infinite and I booked on convenience. Oh have times changed! I even let go of Amex platinum, just wasn’t worth it to me. Base airport LAX/SNA so no airline pref.

like

I’m having my performance review tomorrow. Looked at my goals last year which was set before the pandemic really hit. Since it really affected business and travel I didn’t hit most of my goals. Plus I was really depressed (who wasn’t really) so I didn’t take much initiative. What’s a good way to navigate this...?

like

Successfully made the jump.

Places where I applied and got an interview so at least I know they look at fed backgrounds. Might want to check them out. These were DC area.

Amazon
Google
Marriott
Visa
Facebook

likehelpful

Amex to Marriott point transfers are 1.0:1.3 right now. Is it worth?

Has anyone ever gotten the SGB treatment? Was doing some research on chronic pain management treatments and found something called Stellate Ganglion Block (SGB), a non-invasive injection that helps chronic pain, anxiety and PTSD symptoms. Helps 'reset' the flight or fight CNS.

Would love to hear about your experience and how has your pain/PTSD symptoms been since!

like

If u got an offer and usdc matched it but said u may need to move to core ( increased travel) would u stay or move to core/usdc?

like

Free deposit of 50% of Elite nights from last night for Marriott Members. Sounds like Marriott really wants us to start going back and staying in their hotels.

like

Hello Fishes,

I have got my L2 Dependent Visa stamped for the US through the Wife's organization and she has booked the tickets for the both of us in the next weekend. I am currently unallocated in TCS and seeking projects in the same US location as my Wife. Can I travel to the US just like that and then continue my search within TCS from there or do I need any approvals to even fly in the first place?

I am worried because of the time crunch and will be glad to hear some points on this.

like

How is it in working with Delta Air Lines Bangalore? How is work life balance and is there any out of India travel opportunities involved?

like

Travel opportunities for functional consultant in D365 at PwC AC and shift allowances?

like

Can anyone offer advice , possible job openings for an individual that is in the last semester of earning certification after student teaching hours are acquired? This individual has been working/ cos chi big in the school system for over 12 years… experience with autistic students , middle school , students spending time in the alternative setting… pending masters degree in secondary education… coursework completed (with exception of student teaching)… also enrolled in an alt/cert. master

like

Which firms have the best partner perks outside of comp? Training, retreats, travel luxuries, family events, etc?

likesmart

Looking to go on a short 3-5 day trip, preferably a beach destination. Any safe suggestions at the moment? Flying out of the US and would like to use southwest.

likefunny

Has anyone here ever accidentally walked in on a hotel guest? Oops...

like

Best SPG/Marriott hotels in downtown NYC? Thoughts on 11 Howard?

like

I have to travel to my client every week and the client’s office is attached to a very nice hotel that’s $250 per night. There’s a hotel right across the street that’s $150 per night.. it’s alright, but not as great. Should I be mindful about how much I’m spending or should I blow up the budget until someone says something?

likefunnysmart

More Posts

When you get stuck on a design or when you are starting a big project, what are your creative processes? Do you look at colors? inspiration? Pen and paper? Illustrate something? Want to work with my designer on a toolbox of steps to pick from to find what works best for their individual creative process? I know my creative process is look at inspiration, pen and paper, then start designing, but I don’t want to assume that’s theirs too.

like

What is the salry range of band 8 at IBM

like

Your thoughts on iPhone 12 Pro Max camera system?

like

Your best strategies for getting business...Not looking for a silver bullet. I am interested in best practices that I might adopt.

like

What are the career opportunities in SDET after eoy 10-15 years?

like

Looking for recommendations for the Douro River in Portugal! Restaurants, hikes, vineyards?

likesmart

38F here .. for those of you on apps and seeking a relationship, not something casual, what are your age filters? Please specify your age and gender when replying

like

Follow up post to my last post…My husband was laid off from the company where I also work. I am feeling really isolated / depressed about working and moving forward. I’m also getting to a stage where I’m really sad that people haven’t reached out to either my husband or myself to send well wishes or provide support. It’s like they don’t know what to say or I make them feel awkward so they don’t bother…I’m trying to focus on a few that have been supportive but it’s hard…Any words of advice? 😞

like

Back from the can. What'd I miss?

like

Black Friday Sales - any good deals?

like

Hello,

I just joined
IQVIA, wanted to know how much variable is paid and when? Joined in FEB month. IQVIA

like

What are your thoughts on how TikTok is shaping the workplace?

like

Any thoughts on Invisalign? Has anybody ever done it & were you satisfied with your results?

like

Does anyone have a template to poll a TA team on time in task? Trying to evaluate how much time a team spends on Admin duties.

like

Is 120k salary enough to enjoy DC ?

like

Considering trying this whole no sugar thing for a week. I'm on a traveling project. How does one start and keep up while on the road?

like
like

Hi fishes,

Need help on how to put counter offer on already rolled out offer.
I have got offer of 24lpa CTC with X company before i put down paper.
Now i have the other offer of 28lpa CTC with Y company and 15 days is left with my notice period.
If i won't get any good offer in these 15 days i would like to go for X company as it is giving remote option and Y is 4 days office.
So when can I put counter offer for X and plz help me with what reason i can to match Y offer atleast.

Thankyou.

like

Sorry if there is a better board for this question. We are not yet pregnant. Are there any other Firms out there that offer financial assistance with IUI, IVF, egg donation, surrogacy, adoption?

like

Anyone know anyone in the industry that's done foster parenting? Looking to connect with other foster dads and moms.

likeuplifting

Additional Posts in Excel Genius

Can I write a macro that will fill out a table of information based on cells that have comments on them? For example, if G12 has a comment, I want to pull text from that comment + data in A12.

like

Why when I refresh a query, the table where the query is loaded to just gets duplicate rows? Same with the pivot table that feeds off of that query?

like

What are the most typical models you all build

likehelpful

Our system is really lacking and we do a lot of work outside of it to track data. Currently I’m using Excel to track data from multiple resources, however, it’s so manual and prone to error. Any suggestions to keep the data clean when I have to pull info from multiple places? I’m constantly auditing and we won’t even look at getting a new system until next year :(

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

Tips on adjusting to Mac? I’ve figured lots of keyboard shortcuts but it’s just not the same 😪

like

Has anyone encountered this error before? We can’t access a workpaper with 70% of the work done 😩😩

Post Photo
like

I have three lists. Each is a list of processes. Each list represents one hierarchy level. Is there an easy way to get from three separate lists to one list ordered like shown on the right?
Thanks for your help fish!

Post Photo
like

Whats a good book/course that will teach me advanced excel skills? I want to be quick with shorcuts etc & learn VBA/Macros. Under $30 please, input is greatly appreciated.

like

I’ve toggled the “Show Formula” setting and it changes nothing. File format is xlsx, so that shouldn’t be the issue. Any ideas why these are showing the formula instead of the output?

Post Photo
like

I want to create a heat map of when people are unavailable with day of week as the columns and hour of day as the rows. I have start times and end times, how can I use this data to create the map?

like

Is Macabacus or any other add-in actually worth it for Excel & PPT? In LMM - MM M&A roles.

likehelpful

Best pdf to excel converter?

like

Any recommend courses (coursera, edx, etc.) people would recommend for user with intermediate experience with excel?

like

What's the F4 analogy in Office 365?

like

If you follow him on LinkedIn you probably already saw this! Lol 😆 but I totally resonate with the post... 🤣

Post Photo
funnylike

Hey Geniuses! I apologize in advance if this question has been asked before, I'm new here and just trying to learn as much as i can. Does anyone know a great source to learn Macros for beginners. I would like to create one for work. I appreciate it

like

Hi team i have a bit of doubt.
I have an excel sheet where column A is the order numbers. I want to add comments in column G.
There are many repetitions in order numbers but they are all sorted in ascending so all the repetitions are below one another.

If i have a comment, how can i automatically paste that same comment in all the repetitions of that order numbers if i write it in the 1st instance.

Thanks in advance

like

A lot of the work at my new employer is quite redundant and can be automated via macros. What are some of the best resources to learn vba?

like

Please help. I was recently hired by a Venture Capital firm that uses MacBooks instead of PCs. I’m extremely efficient with Excel on PCs and am struggling with the transition to Mac. Do any Mac users have a list of keyboard shortcuts that they use frequently, or any other tips/tricks?

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

Send download link to your phone

OR

Scan your QR code to download
Fishbowl app on your mobile

By continuing you agree to Terms of Use and Privacy Policy.

Messaging rates may apply

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