Alt + H + FP + (Directional Arrow) = Format Painter for the cell you moved toward in the directional arrow…

Here is what I want to know… how can I paste this format painter to MULTIPLE cells after pressing Alt + H + FP?

I’ve tried holding Shift as I went down across cells, cause I felt like that made sense, but that doesn’t work.

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

Copy and paste formatting with Alt+E+S+T or a VBA shortcut

like

^^^^^^^^^ Alt +E+S+T is it. just remember alt + eastern(E) standard(S) time (T)

Other favorites include alt + hoi for automatically fitting column width to the widest column and alt + hor for renaming sheets ;)

like

Ctrl + C
Ctrl + shift + V -> T

like

Do the above suggestion alt esv once then press F4 for each subsequent cell(s) you want to paste format to

Est* sorry

Related Posts

Anyone affected by the Atlanta airport shutdown? Delta is crapping their pants once again!

like
like

22/F, fitness/health/travel junkie, Nashville. Slide in 😉

likeuplifting

Would you travel in June from NYC to LA - for an editing job? I’m thinking .... why??? It’s working just fine to work from home — Opinions ?

Can anyone recommend a traditional travel agent for booking Italy? Going solo for a wedding, so I don’t need the luxury itinerary planning of a “travel advisor” (& don’t want to pay the fee), but the wedding’s in a small town so handling finding best flight, which airport to fly into, transportation from airport to said small town, etc. plus someone to call during trip if there’s a snaffu. (Would be flying from Philly or Newark if that matters)

like

Moved to Canada on a work permit but recently got my PR approved. It’s been a 4 month wait to get the actual PR card and I have a family trip coming up soon. Can I still travel and get back into the country with no issues given that I still have a work visa (W1) on my passport? Not sure if my change of status nulls my current visa

I make $100K with 12% bonus and was offered a role $130k with 15-20% bonus. 4YOE in provider industry.

I am in a comfortable spot with a good team but the work is dull, new role would be consulting with more work & travel

I would appreciate pros/cons etc! Thank you.

like

Is KPMG, EY and PWC considerate about one not wanting to travel and chosing local projects in the IT Assurance practice? Please share your experiences. Thanks!

What’s going to happen to the people who are at a high risk for severe illness if they catch the coronavirus? Will they still make them travel? Should they look for new jobs that don’t require travel?

like

Need to book a Marriott for parents, how do I make a reservation under their name with my Marriott account to make sure I get the points. Is there a way to do this?

like

Does it matter when you check in online for a hotel in terms of getting an upgrade? I'm a titanium elite Marriott bonvoy member looking for upgrades at Westin and Ritz in a couple of days. Any tips on getting an upgrade?

like

Looking for solid, affordable Airbnb or hotel options in SFO

funny

I am stranded in a foreign country, was traveling for personal reasons, because AA cancelled my flight citing weather concerns but is flying other flights at the same time. Is there a way for me to 1. Get an alternate flight that is not painful. 2. Escalate and get compensation? Thank you.

like

Looking to put $5K in the market. Which ones would you buy? Lululemon, delta airlines, Peleton, docusign, Zoom, etsy. Any that I’ve missed and should consider? Already have MSFT, BRKB, NVDA, BABA and multiple broad ETFs

like

How does one share a Delta drink voucher? Can you just take a screenshot?

Does anyone know where on the United website where I can see all my future PQMs, PQDs, and PQSs for the rest of the year?

like

Any else make the mistake of using Gotogate and we’re successful in dealing with their customer service? I’ve never dealt with something so terrible in the travel industry

like

Looking for referrals for a Technical Sales Executive position that is Remote (USA), possibly in the industrial sector. Last year I made $109k at AT&T so I'm hoping to at least stay in the same ball park but want a change. I have lots of experience selling IT/telecom, but I also have a Mechanical Engineering background so I'm a good fit for a wide range of technical sales. I have been thinking a role in the industrial sector with a longer sales cycle may be a good fit, can travel up to 25%

like

Anyone know of current tourism or travel incentives for Europe this summer?

like

What is better hertz or Avis loyalty program? I have been on hertz (president circle status due to united status) and collected points a few free rental days now. But hertz always seems so much more expensive to me for personal trips and I end up buying Avis. Should I just shift to Avis? United has also ended its partnership with Hertz now, hence wondering.

like

More Posts

How much is fair for movers from Boston to Wayland? Bedroom and living room in a 500 sq ft apartment, only furniture.

like

I have been waiting/looking for this exact bowl. It’s graduation season. Get ready for the “I’m proud to announce” LinkedIn posts that none of us give a piss about. May we post and roast mercilessly.

likefunny
like

Any fish from LEK London willing to refer? Currently interviewing with other top consulting firms in London and keen to pursue LEK
YOE: 6
Appreciate the help!

like

Any opening for data scientist in EY GDS. I have total 8 YOE and 3 years in data science. I am seeing vaccancy for GDS team in LinkedIn, if there are any can someone refer me ?

like
like

Does anyone know what does a business program manager do in Microsoft?

helpful

Hey guys.. anyone looking for good friend... Getting saturated with wfh :(

like

Bless the rain 🙌🏻 now the heat wave can buzz off

like

It’s a new week!! Target to win 🏆.. Win! And keep winning!

likeuplifting

How do you folks describe your deals in resume/ interviews/ LinkedIn while stopping short of naming client/target? If you describe the acquirer and target, it’s pretty easily traced to the exact deal.

like

Hello Bowls,

Three Months back, I gave interview for Infy and got selected after that I got one offer from another company with very good pay so, I have to tell infy that I will not be joining. The same thing happened for me in 2018, Initially I gave Interview for infy got offer from them after that I joined in TCS. If I reject the offer now, will they black mark my profile by not allowing me to join in future. Also, what I can tell them for offer rejection. Thanks.

like

Hi guys,
Got offer my Tiger analytics for the role of data engineer. How good company is tiger and team member are supportive or not?
What is wlb and does they fire employee as this is my first switch.

like

What's the typical salary band for a Sr AD in Chicago?
I heard anything over 100 was encroaching ACD territory but I find that extremely difficult to believe because I'm already near that wall...

Happy Friday! Would love to speak with a manager or director working at Slalom Consulting to hear about experience and potential fit for someone with a background in growth strategy & pricing.

like

I’m living in Norway and wonder if it is any remote job oppurtunities in faang? Previous experience as consultant in CFO advisory, Venture capital advisory and Data Science

like

How much is the average Emergency Medicine physician making out of residency? (Name your city)

like

Hey people,

I recently got selected for Amazon brand specialist role L4. My current CTC 5.5 LPA

How much increment can I expect. Is there in pay band for minimum pay.

like

Designers have dribble 🖼
Engineers have github 👩‍💻
Data scientists have kaggle 📊

Do consultants 🧳have a good platform to
1) showcase their portfolio of work beyond bullets on resume and LinkedIn
2) get inspired by work of other comsultants?

Is there a need? Would you be interested in trying out such a platform?

If you have some ideas, feedback on some key characteristics of a good platform for that please post here.

likefunny

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

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

like

Would anyone be willing to teach me vlookup?

like

Hey fishies, looking for some help with the below

I have 4 lots of data categories which are assigned a code in the adjacent cell
Eg:
Cell A2= 'xyz' Cell B2 = 'w1'
Cell C2= 'ghi' Cell D2 = 'x1'
Cell E2= 'plm' Cell F2 = 'y1'
Cell G2= 'mhn' Cell H2 = 'z1'

The combination of the 'W','X','Y' and 'Z' codes identity a specific trend
I am extracting data which includes multiple combinations of these codes. What is the best way to show frequency of the codes against the category it is assigned to

like

Anyone have suggestions on where to start learning how to program add-ins with office.js?

like

Can dates be grouped just by Month-Year in pivot tables on a Mac without having the year as its own dimension?

Post Photo
like

I have 1 sheet with names and sheet 2 with a large list of names that may or may not be those names - which also have corresponding unique identity numbers. How do I easily match the names with the same names and keep the unique identity numbers for importing later?

Hi! I’m trying to create a macro that pulls a copy of a sheet from a file with a certain date in the file name into a new workbook. Is there a way to do this?

How can I resize the horizontal scroll bar to only fit to my data? It goes all the way to column XFD and my data only goes to GK. Someone once had formatting that far out and now it won’t resize

likeupliftinghelpful

Help unhiding columns A-D in excel. I've tried putting A1 in the select cell selecting unhide columns and also youtube to no luck. Please help.

like

How can I add multiple characteristics within one cell and make sure that a pivot table can read both values independently if needed? E.g., I have a column titled “color” and in one cell I write “red” and the other “red, blue”. I’d like a pivot table / formula to be able to count that there are technically two “reds” in this data set. Any tips?

like

I am continually struggling to understand how input complex equations like if functions and max/min. Anyone willing to chat briefly?

like

Top 3 most useful VBA macro codes you use everyday? Would you mind sharing the VBA code or a link showing the code? I’ll start (cont.)

likehelpful

Everyone: Excel is a smart app
Excel:

Post Photo
likefunny

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

Anyone know why a SUMPRODUCT cell would return to zero?

The error said ‘inconsistent formula’... (cont’d)

Can you share the most useful formulae and built in automation features you have used with the latest version of excel?

like

Looking to get rid of ALT+ENTER in cells, it’s messing up my import file formatting when I convert the file to .txt.

Could some recommend a way to do this quickly, I’ve tried find and replace control j, and that worked on most but not all cells.

like

Most used or favorite Shortcut? Ctrl + Z doesn’t count

like

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

likehelpful

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