Automatically translated.View original post

3849 followers

Follow

Follow

Follow

63 saved

34

Copy and paste the roster, magic key that ends in 1 second🌿

Hello! With 15 years of IT experience

I'm pretending to make myself easier 🌿

Separating "surname" and "name" on the list...

If you copy and paste these one by one, the sun will set 😭

Actually, in Excel, the computer reads the air

* * There is a god function called "Flash Fill" * * ✨

How to use is very simple.

Enter the example only on the first line,

Just press [Ctrl + E]!

Using the Slam Dunk roster (nostalgic! lol)

I demonstrated it in a video 🏀

Please take a look at the pleasure that fills in an instant ✨

⚠️ not to fail.

Be sure to press the key immediately below the first line

First name and last name proceed "one row at a time"

This alone will increase your success rate!

I'm also bad at Excel.

That's why without hard effort

I only have to go home 10 minutes early from tomorrow 🌿

# Excel # Excel Convenience Computer beginners # work efficiency # leave on time

3/12 Edited to

私もExcelが苦手な初心者でしたが、このフラッシュフィル機能を知ってからは格段に仕事の効率が上がりました。特に名簿のコピペ作業で「桜木花道」など氏名の分割が必要な際、1行目に名字と名前の例を分けて入力し、Ctrl + Eを押すだけであっという間に自動で入力が埋まるのは本当に感動的でした。フラッシュフィルはExcelがパターンを学習して自動的に文字列を分割してくれるので、何十人分もの名簿作業も数秒で完了します。私が失敗しないために気をつけているポイントは、必ず1行目のすぐ下でキーを押すことと、名字と名前を1列ずつきちんと分けて進めること。これが成功率を大きく引き上げます。また、漢字だけでなくカタカナやアルファベットの名前パターンにも柔軟に対応してくれるので、社内で扱う様々な名簿に使えました。忙しい毎日の中で、この時短テクを使うことで確実に10分以上の作業時間削減につながり、残業も減りました。 Excelのフラッシュフィル機能は、まさに「魔法のキー【Ctrl + E】」としてオススメです。動画での解説もあるので、具体的な操作方法を確認しながら試してみてください。これからも無理なく続けられるExcelの便利技をシェアしていきたいと思います。

Related posts

Hair growth on a new level: I Grew my Hair to 28in

✨My top products list✨ 🌺Mielle Rosemary Mint Scalp Strengthening Oil Ingredients: Rosemary oil, mint oil, biotin, and a blend of essential oils Benefits: Rosemary Oil: Stimulates blood circulation in the scalp, which may promote hair growth and improve hair thickness. It also helps reduce

3059 likes

AP Lab Practial Notes : Endocrine System

Hey Lemon8Gworls&Gents here’s some brief notes on the Endocrine System feel free to leave a comment for questions and concerns #anatomystudy #lab #nursingschool #nursingstudentlife #aplab

196 likes

A close-up of a gut-healthy vegetable soup in a white bowl, featuring diced carrots, broccoli, and green vegetables, topped with red pepper flakes. The text 'Gut healthy soup' is overlaid on the image.

A close-up of a vegetable soup in a white bowl, showing diced carrots, broccoli, and fresh green Bok choy leaves. An overlay lists key ingredients: carrots, Bok choy, broccoli, onion, garlic, ginger, and leek.

A close-up of a vegetable soup in a white bowl, featuring diced vegetables and red pepper flakes. An overlay lists seasonings: beef broth, onion & garlic powder, salt & pepper, red pepper flakes, cayenne, and miso paste.

Gut healthy veggie soup

Gut healthy veggie soup that tastes amazing and is so versatile. This is full of fiber and prebiotics for the gut and vitamins and nutrients ✨ Onions, garlic, and leeks, are rich in prebiotics, which are types of fiber that gut bacteria use as fuel. Miso is packed with probiotics and digestive

324 likes

Want a cheat sheet of my best prompts?

Here’s a plug-and-play ChatGPT prompts cheat sheet for Reels, carousels, captions, and sales content. #chatgptprompts #chatgptforbeginners #chatgpt #chatgpthacks #posh

12 likes

From-Scratch Chicken N’ Dumplings 🐓🥘 (Instant Pot)

My FAVE chicken n’ dumplings recipe to use for meal prepping, comfort food, and something that’s just damn good! ☺️💖 (and it’s an #InstantPotRecipe so it’s faster!) I used 1 TBS beef bouillon paste with 3 1/2 cups of water instead of the chicken stock (I was out of the stock lol) and Hubby sa

61 likes

A flat lay shows a tablet displaying digital notes on 'Language of Sets' and various pens and highlighters, representing general study essentials.

White over-ear headphones rest on a wooden surface, with text indicating 'music' and 'study playlists on Spotify' as a study essential.

A tablet displays a study timer interface with options to play music via Spotify, track tasks, add notes, and customize settings, highlighting a digital study tool.

Study Essentials

Here are some of my study essentials as a college student! :) Music-personally, I find it easier to study when I have some background music. I try not to choose music with lyrics though because they’re distracting Astrostation.me- this website is so helpful when it comes to studying. You can

936 likes

A title slide with the text "HOW TO SPOT FAKE EMAIL COLLABS" on a dark green rectangle, with a white background and plant shadows.

A dark green rectangle with white text explaining that fake email collaborations are real and that the following slides will show examples to avoid.

An example of a fake collaboration email from "Cell By Cell US" showing the sender's email address ending in "@gmail.com" and advising that real collaborations use official website domains.

How to spot fake brand collabs!

If you are a content creator, you should read this. What you should look out for, real vs fake emails, and some key information! I hope this helps! If you have any questions let me know in the comments! Stay safe out there 💞 #collaborationtips #contentcreatortips #premails #pr

130 likes

3 things that are literally ruining your hair 🤯

#lemon8hairproduct #lemon8lhairserum #lemon8haircare #lemon8finehair #lemon8healthyhair

585 likes

Steal my cardiovascular notes 🫀

#cardiovascular #nursing #nursingnotes

91 likes

Fantasy Fudge Recipe

Fantasy Fudge Recipe Ingredients: 6 cups sugar 1-1/2 (3 sticks) butter 2 small cans (5 oz.) evaporated milk (about 1-1/3 cups) 6 packages of Baker’s semi-sweet chocolate, chopped 1 jar (13oz) Jet-Puffed Marshmallow Creme 2 cups chopped walnuts (optional) 2 tsp. vanilla Directions:

192 likes

Savory, buttery, and full of umami flavor — ready in just 20 minutes! 🐟✨⁠ ⁠ This baked trout with miso butter is tender, juicy, and packed with flavor. Weeknight simple, yet elegant enough for the holiday table.⁠ ⁠ Pair it with roasted squash or simple greens and you’ve got a meal that feels sp

10 likes

Which one looks the best?! Let me know if you try these! 🙌🏼🩷 #healthyrecipes #lowcalorie #dinnerideas

1018 likes

Chatgpt prompts for students

Here are a few CHATGPT prompts for students to use to ensure ethical use of this AI tool. Its a great tool to save you time in mundane or tedious tasks such as removing first times from a roster, re order something alphabetically. It’s always a wonderful tool for writing and brainstorming!

24 likes

Damaged Hair & Split Ends Remedy

damaged Hair & Split Ends Remedy 1 cup of water 3 tbsp cornstarch 2 tbsp sugar 2 tbsp coffee 4 tbsp molases first bring the cornstarch and water to the stove on low heat moving constantly until getting a soft paste. turn off and let it cool. once cold, add the sugar, coffee and th

31 likes

How to make money as a UGC creator💸

There are so many ways to make money online now a days, and most people don’t have just one specific stream of income. There are multiple ways they are bringing themselves in money, and it adds up! I personally have a couple of different ways I make money 🪽Freelance websites: Upwork and Fiverr Th

12 likes

#studytips #successfulstudent #productivestudent #studywithme #StudyHacks

48 likes

A collage titled "PIERCINGS 101" featuring close-ups of a person's face and ears with various piercings, including septum, nostrils, vertical labret, helix, conch, daith, and lobes. Text asks about where to go, jewelry, healing, and keloids.

A collage titled "MY CURRENT PIERCINGS" detailing the location of 12 piercings on a person's face and ears, including paired nostrils, septum, vertical labret, helix, conch, daith, and multiple lobe piercings.

A graphic titled "GETTING PIERCED" advising to research piercers, avoid certain stores, and look for reputable tattoo/piercing shops. It lists criteria for safe piercing practices, such as sterile tools and quality jewelry.

✨ Piercing Tips!

Hey friends! As you can tell, I love getting pierced! I got my first lobe piercings at 10, then my second lobes at 14 ish. The day I turned 18 I got my first helix piercing on my own, and since then I’ve accumulated a total of 18 piercings, 12 of which I still have. I do a lot of research about pie

3366 likes

RUN…don’t walk, and more importantly help your friends! check the comments 🫶🏼 #slashtheprice #freeproduct #tiktokshop #viral #greenscreen

42 likes

NFL Hard Truths

MANNING COULDVE CHANGED MULTIPLE FRANCHISES #Nfl #drewbrees #tombrady #peytonmanning #patrickmahomes

18 likes

Full-Body Shower Routine for Head-to-Toe Glow✨🪒💅🚿🦷

This is my 9-step full-body routine that took my dry hair and skin to luscious hair and glowing skin, smooth legs, and a fresh, long-lasting scent. Here’s my guide to achieving that radiant, dolphin-smooth body and much more—right from the bathroom. 🫧Hair Care: Deep Cleanse, Hydration &

188 likes

Final NFL Hard Truths

I think the buccaneers are in great position 🛬 #bakermayfield #justinjefferson #tampabaybuccaneers #minnesotavikings #oaklandraiders

1 like

Blowing up the group chat before summer ends 😈

Okay, we've hit THAT point of summer. You’ve been to the beach, you’ve binged all the shows, and now you’re just bored, scrolling. My friends and I were literally just staring at each other in the group chat. So, I’ve decided our new mission is to create a little chaos before we all have to

4 likes

Pot Roast Recipe

1. Slice up your chuck roast, season according to your taste, and brown on all four sides 2. Sauté the1 chopped onion until translucent 3. Add minced garlic (measure with your heart) and sauté until fragrant 4. Add 1Tbsp each tomato paste and Worcestershire sauce, mix 5. Add the browned roast,

5 likes

A woman with curly hair is surrounded by images of Chebe Ointment, Castor Oil, Hibiscus, Raw Shea Butter, Aloe Vera, and Fenugreek Oil, detailing their benefits for black hair care.

Four women with long, dark hair are shown, illustrating the concept of growing a thick mane naturally with chebe oil, as stated in the text "chebe oil EVERYTHING YOU NEED TO KNOW TO GROW A THICK MANE OF HAIR NATURALLY".

This image details the ingredients of Chebe Paste, including Chebe Powder and Karkar Oil, and provides a six-step guide on how to apply Chebe Paste to hair for moisture and breakage prevention.

Need help growing long, thick hair?

✨Grow Like the Ancients✨ This rich, earthy Chebe hair growth paste is inspired by centuries-old traditions from Chad’s Basara women—known for their waist-length hair and unmatched hair care rituals. 💫 Packed with strengthening herbs and natural butters, this paste locks in moisture, reduces breaka

390 likes

A black Dagne Dover tote bag with a butterfly clip, featuring a badge, scissors, and a clear pouch in its pockets. The image is titled "What's In My Work Bag" for a Registered Nurse.

Various nurse essentials laid on a pink and red checkered surface, including a badge, an ECOLAB hand-washing reminder, and a Centrak location tracker/duress device, alongside a butterfly clip, scissors, and pens.

Personal items laid on a pink and red checkered surface, including face masks in a clear yellow pouch, black headphones, a black Coach wallet, and a white charging cable.

What’s in your work bag? Post to win a Lemo doll🍋😍

🩷Peek inside the work bag of a registered nurse! Amazing post by @Madeline Ramos and she’s using a medium Dange Dover tote! — 🩺👩‍⚕️Do you work in the healthcare industry? If so, we’d love to know what’s in your work bag! 👜Publish a post titled “Daily essentials as a __(job title)__” f

146 likes

✨Share with u the all in one notebook

Lately, I’ve been trying an all-in-one blank notebook to track time, reflections, ideas, and inspirations. But here’s the problem: sometimes ideas flash by too quickly to open my notebook… Or some days I just don’t even touch it. (If the notebook isn’t opened, the plan is basically Schrödinger’s

127 likes

Lemon Garlic Salmon

#food #dinnerideas #Recipe #salmon #fyp

2 likes

My Podcast Roster 👀🤭

Love these girls real bad, especially if you need a good laugh or life advice. Shout out to all my naija babes holding it down. #podcasts #podcastersoflemon8 #podcastsforwomen #podcastrecommendations #nigerianwomen #podcastsfor20s #podcastsforblackwomen

1770 likes

Spring cleaning must haves; dollar tree! ✨🫶🍋

If you want a branded item but you can’t justify paying that much for it. I promise Dollar tree has a dupe and real for that.. it’s 2025. We are not overpaying for laundry and cleaning products anymore So here are a few dupes and deals for you to be on the lookout for!! #dollartreefinds

40 likes

these are the roster Turtles painted and handmade stands Made In Puerto Rico

my Rasta Turtles

2 likes

1945 Magazine ✨

some more photos. ✨

22 likes

A woman takes a mirror selfie, with text overlay "Whats on my BABY SHOWER REGISTRY" and cartoon drawings of a baby bottle, diaper, and a heart with "2025". She is wearing a black jacket and jeans.

This image displays a baby registry section titled "Activity & Gear," featuring items like pacifier holder cases, a baby wrap carrier, a baby floor seat, a postpartum kit, an ergonomic carrier, and a playard. A black diaper bag is also shown.

This image presents a baby registry section titled "Bath Time," showcasing items such as washcloths, a baby to toddler tub, towels, a bath pad, baby soap, baby lotion, and a rinse cup.

did i understand the assignment?

You can find every single item using the link in my bio!! • ITEMS ON REGISTRY ACTIVITY AND GEAR: -Pacifier Holder Case -Bumbo -Wrap Carrier -Postpartum Kit -Ergonomic Carrier -Pack n Play -(Would have diaper bag on here if we didn’t have one) BATHING: -Towels -Baby to Toddler Tub -Bat

9 likes

Super Bowl Eats!!

Super Bowl is in 10 days and I have all the gluten-free dips, party apps, & more! Above is just a preview of what’s to come but you can find all these recipes on my blog THE BOTTOMLESS PIT #superbowl #superbowlfood #superbowlappetizer #superbowlsunday #superbowl2024

16 likes

Friendsgiving Menu Chinese Inspired

Friendsgiving is a time to gather with friends, share a meal, and make memories before the Thanksgiving holiday. This modern tradition began in the early 2000s and has grown in popularity as a way to celebrate chosen family, especially for those who can't make it home for Thanksgiving. Frien

9 likes

Had to ask #Kali about the roster 💅🏽🤭

#kali #jackharlow #interview #embracevulnerability

1170 likes

Unboxing the Pixel 9A

I love the color so much. I've had this phone for a few months now and I only have a few issues with it. sometimes when I try to tiktok the video uploads all black and I don't like not being able to copy and paste text from photos. by the way if anyone knows how to do this plz comment below

26 likes

🌜skin & hair night routine🌛

What I use every night when I step out of the shower: 1.) I start by washing my face in the shower with my favorite La Roche-Posay! My gosh I love this stuff! I do a double wash by the way. 😌 2.) once I’m out, I pat dry my face with my microfiber towel and immediately apply micellar water to

55 likes

A Nintendo Switch console with blue and red Joy-Cons displays a character from a game, positioned next to an Animal Crossing: New Horizons game case. An overlay text reads '10 excellent Nintendo Switch games for relaxing'.

Nintendo Switch Games for Young Boys!

Here are some great Nintendo Switch games that are particularly well-suited for young boys: 1. **Super Mario Odyssey**: A fun and adventurous 3D platformer featuring Mario in various imaginative worlds. 2. **Mario Kart 8 Deluxe**: A high-energy racing game that's easy to pick up and play, w

6 likes

I don’t understand why some people still do this😭

#beautyhack #hygienetips #beautyroutine #SelfCare #femininehygiene

0 likes

NBA Hard Truths

I think Luka is gonna get one #xybca #nba #basketball #stephcurry #lukadoncic

3 likes

See more