Automatically translated.View original post

わこ｜1分で学べるPC仕事術

7398 followers

Follow

Follow

Follow

817 saved

294

2

[Convenient Excel] Cell joining is NG! How to make it look like vertically joining cells

@ wako _ pc _ work ← Overtime will be reduced by following!

Today, I introduced [How to make it look like cells are vertically combined] ✨

I would be happy if you could send your requests and comments to comments / DM 😊

- - - - - - - - - - - - - - -

[Self-introduction]

It's Wako!

At a major IT company, I develop apps and manage teams 💪

There is such a past.

Adaptation disorder due to working too much

Overtime is now less than 10 hours a month!

・ I was shaken by my boyfriend who I dated for 5 years

Let go of perfectionism and 😊

Meet a nice person and have a happy marriage 🕊️

These two things changed me when I was at rock bottom!

① Skill up

② Mind

We will deliver not only Excel, PowerPoint, Word but also mind and know-how to promote work easily 🫧

Nice to meet you!

Those who want to know more 👇

@ wako _ pc _ work

- - - - - - - - - - - - - - -

2025/12/31 Edited to

Excelで縦にセル結合した見た目を作る際、実は「セル結合」を使うことはおすすめできません。セル結合を使うと、フィルターやソートが効かなくなり、データの扱いが大変不便になるからです。そこで私がいつも使っているのは、セルの中央揃えやテキストボックスの活用、条件付き書式を組み合わせた方法です。例えば、セルを結合せずに「中央揃え（縦方向）」を設定し、見た目を整えるだけでも十分にきれいに見せられます。さらに、隣のセルに同じ内容を表示させることで、結合したかのような印象を与えられます。これはコピー＆貼り付けを駆使すれば簡単にできますし、あとからデータを編集する際にも自由度が保てます。また、画像やテキストボックスを利用して表の中に文字をはめ込む手法も便利です。文字が上下中央に配置されたテキストボックスや図形を使用すると、Excelのデータセルとの干渉を避けつつ美しいレイアウトが作成できます。 OCR画像からも分かるように、「貼り付け」や「フィルターをクリア」などの操作がスムーズに行えるための工夫が重要です。私の経験上、この方法で効率的に表を管理するようになってから、残業時間も大幅に減りましたし、データの加工や集計も楽になりました。ぜひこの記事の方法を試して、Excel作業のストレスを減らし、スキルアップにつなげてください！

Related posts

Excel shortcuts every student should know! 👩🏻‍💻

Stop Wasting Time: Master These Excel Formulas for Maximum Efficiency! 🕒 If you’ve ever struggled with Excel, mastering formulas can seriously up your game. Here’s a breakdown of the essentials that’ll make you look like a pro 1.Core Calculation Formulas 🧮 These are the basics you can’t live

1175 likes

A vibrant image showcasing four different smoothies, fresh berries, and an apple on a tray. Text overlay announces 'Drinks that Helps Burn Fat Daily Recipes Included', promoting healthy weight loss beverages.

A close-up of a green Kale Banana Smoothie in a glass. The recipe is overlaid, listing 1 cup kale, 2 tbsp flaxseeds, 1 banana, and 1 cup plant milk for this healthy drink.

A yellow Mango Coconut Water Smoothie in a jar with a straw and mint. The recipe details 1 cup mango, 2 tbsp oats, 1/2 cup yogurt, and 1 cup coconut water for this refreshing drink.

Best Daily Drinks for Weight Loss ✨

Here are the benefits of each smoothie for weight loss: Kale Banana Smoothie High in fiber: Kale and flaxseeds are excellent sources of fiber, which promotes satiety and aids in weight loss. * Nutrient-dense: Kale is packed with vitamins and minerals, supporting overall health during weight lo

2515 likes

Mississippi Sin Dip

Mississippi Sin Dip Ingredients: • 16 oz sour cream • 8 oz cream cheese, softened • 2 cup cheddar cheese, shredded • 1/2 cup chopped ham • 1 green onion, chopped • 1/4 tsp hot sauce • 1 tsp Worcestershire sauce • salt • pepper • 16 oz French bread loaf Instructions: -In a mixing bowl,

723 likes

CROISSANT RECIPE 🥐✨

Prepare dough: Prepare the dough by adding all the dough ingredients (except the 55g of butter) to a stand mixer. Knead until the dough comes together. Then cover it with plastic wrap and let it rest for 10 minutes. After 10 minutes, add the 55g of butter and continue kneading for 10-15 minutes u

1229 likes

why do i love sugar wax so much? 🥲

*Cost-Effective: inexpensive compared to salon waxing treatments or purchasing commercial waxing products; a single batch can be used multiple times, stretching your investment further. *Convenient: anytime, anywhere! *Hygienic: no risk of contamination from others; easy cleanup, clean spills or

1600 likes

A supermarket aisle filled with various vitamin and supplement products. Overlay text reads "VITAMINS 101 How to Pick the Right Vitamins for You?" with a bottle of orange pills and scattered pills.

Text explaining the benefits of taking vitamins and supplements, including support for eyes, hair, teeth and bones, skin, gut, heart, mind, immune system, metabolism, blood health, and reproductive health. A bottle of orange pills is shown.

Text outlining how to read supplement labels, covering serving size, amount per serving, percent daily value (%DV), ingredients list, quality certifications, and dosage. A bottle of orange pills is shown.

Look & Feel Better: What Vitamins You Should Take💊

In today’s fast-paced world, it’s common to look for quick fixes for health concerns. Vitamins and supplements can play a crucial role in maintaining overall wellness, improving specific areas like skin texture, hair health, and immune function. However, with the myriad of options available, it

3080 likes

All the crochet tips & resources I wish I had when I started 😩 #crochet #crochettips #beginnercrochet #tiktoklearningcampaign #education

316 likes

Crochet fidget using pony beads pattern

Hello everyone! Thanks for clicking on this video 😊 I’ve got a fun crochet pattern for fidgets! 😁 You can crochet this pattern two different ways. You can crochet this pattern with the pony beads positioned horizontally or vertically. It’s pretty much the same pattern, it’s only adding more chains

316 likes

One Dumbbell/Total Body Workout

Try this one! 🏋🏽‍♀️ Use a challenging dumbbell weight (not too too easy and not too hard) ➡️ Drive your hips back as you lower down. ➡️ Rotate your feet a few degrees away. ➡️ Glute squeeze on the way up, making sure that you stack the arm vertically over the shoulder to recruit your back. ➡

79 likes

A person in workout attire stands next to text stating "CARBS DON'T MAKE YOU FAT!". Surrounding them are images of Fairlife chocolate milk, pasta with broccoli, bread, white rice, avocado, and ice cream, illustrating various food types.

A graphic titled "What Should I Eat? Foods with High Quality Carbs" displays images of butternut squash, granola, couscous, sweet potatoes, pasta, lentils, oats, cooked rice, and fruit, each with their carbohydrate content per serving.

Text outlines how to calculate carbohydrate needs for weight loss, including formulas for Basal Metabolic Rate (BMR) for men and women. A yellow cartoon character is shown thinking of a croissant.

Carbs are not the enemy!!✋🏼✨🩵 Weight loss With Carb

I wanted to talk about something that's been on my mind lately—carbohydrates. It seems like carbs have gotten a bad reputation, especially when it comes to weight loss. There's this belief out there that if you want to shed pounds, you have to avoid carbs at all costs. But let me tell y

2009 likes

A woman shows her toned abs in a mirror selfie, with a large 'Abs' text overlay and an abdominal workout poster in the background, promoting fitness information.

A list of five recommended mobile applications for health and ab exercises, including MMA Spartan System, Six Pack 30 Day Workout, Lose Belly Fat at Home, Daily Yoga for Abs, and 7-Minute Workout, with their respective icons.

A detailed abdominal workout poster illustrating various exercises like crunches, leg raises, and side bends, with a central diagram highlighting different core muscles and a muscle color code.

🧠Get Informed - Get Fit🔥: Melt Away Tummy Fat 🥵

Let’s talk about abs. Let me be real with you—getting abs and keeping them is no easy feat. It takes time, dedication, and a whole lot of effort. 🍋First off, don’t feel pressured to chase abs just because it’s the “in” thing or the start of a new year. Remember, everyone’s body is differ

369 likes

Biology notes to help you revise 🧬

These are some digital notes I have taken over the semester!! I hope this help you study for and hopefully pass your exams. Biology is so so so so hard 🥲. #studytips #lemon8challenge #revision #biology #biologystudents #grades #exams #biologynotes #notes

254 likes

How To Blend 2 Videos Using Your Phone 📱

Mobile Video Editing Tutorial - How To Blend 2 Videos Using CapCut! 😎 #videocontentcreationtips #videoediting #capcutedit #contentcreatortips #contentcreatorlemon8 #contentcreatortools

166 likes

I found new way to learn new language

I found new way to learn new language @Captain Lemon8 @Lemon8 US #Lemon8Diary #lemon8diarychallenge #studywithme #studygram #studytips #studymotivation #studylanguages #study

1916 likes

A promotional image featuring a woman with text overlay that reads: 'Ultimate office software Cheat Sheet can leverage your career. Get PDF from valder.org'. The image also includes 'lemon8 @wuvalder' branding.

A 'Custom Guide Microsoft® Excel 2021 Basic Quick Reference Guide' cheat sheet, detailing the Excel program screen, keyboard shortcuts, general navigation, getting started, editing, and formatting options.

A 'Custom Guide Microsoft® Excel 2021 Intermediate Quick Reference Guide' cheat sheet, illustrating chart elements, chart options, various chart types, and instructions for creating, modifying, printing, and distributing charts.

my ultimate office software cheatsheet

Let me tell you a little secret: I used to be that person who Googled every single Excel formula, struggled with PowerPoint layouts, and spent way too much time formatting Word documents. Sound familiar? 😅 But then, I decided to take control. I printed out these Ultimate Cheat Sheets for Excel, Po

59 likes

cucumber trellis idea

Boost your garden yield and save space by using an A-frame trellis to grow cucumbers vertically for easier harvesting and healthier plants. #GardenHacks #VerticalGardening #GrowYourOwn #CucumberTrellis #HomeGrown #OrganicGardening #SmallSpaceGardening #GardenInspiration #VegetableGarden

703 likes

A person in workout attire takes a mirror selfie, showcasing their physique. The image features text overlays: 'MY BBL WORKOUT', 'WHY BUY YOUR BUTT WHEN YOU CAN MAKE IT YOURSELF?', and 'IT'S ALWAYS BETTER WHEN IT'S HOMEMADE'.

A person in black workout clothes takes a mirror selfie in a gym, with dumbbells in the foreground. Overlay text lists workout and diet strategies, including training glutes 3 times a week, intermittent fasting, limiting carbs and sugar, and aiming for high protein intake.

A black background with white text lists exercises targeting the gluteus maximus, such as hip extension and glute bridge, and the beginning of exercises for the gluteus medius, including side-lying hip abduction and clamshell exercise.

🍑Grow a Big Butt in the Gym: Glute Exercises

🍑My go to Glute exercises🍑 🍑High stance narrow feet leg press: This exercise primarily targets the gluteus maximus, with some engagement of the gluteus medius and minimus to stabilize the pelvis. 🍑 Wide stance leg press: A wider stance in the leg press shifts more emphasis onto the inner port

3049 likes

i returned my insta360 go3s for this one & after 3 months of use i’m happy i did. the dji osmo nano has been one of my go-to cameras for vlogging. it shoots in 4K, it’s so tiny that no one even notices it, & the magnetic feature is a game changer. being able to mount it pretty much anywhere makes i

269 likes

Master Your Camera Basics pt.3

Creating a polished, professional-looking video doesn’t have to mean spending on expensive videography equipment. Just by paying attention to a few key details that may not be obvious at first, and practicing your craft you can become exceptional. These videography tips will prove to be very useful

50 likes

Tap 🧡 cart to shop + follow @tiffanyallison7 for more faves ✨ Okay these hanger hooks are my new closet hack 😭🫶 They let you stack your clothes vertically so you can fit way more without everything feeling cramped. I’ve been using them for sets, jackets, and my “I’ll wear this someday” pieces lol

2 likes

Copycat Olive Garden Chocolate Lasagna

This dessert that was asked for by a follower! This lasagna style cake is so delicious! A very easy recipe to follow! PREP TIME: 15 minutes COOK TIME: 15 minutes TOTAL TIME: 30 minutes INGREDIENTS~ BROWNIE LAYERS ▢ 1 Brownie Box Mix plus ingredients listed on box – typically 2 eggs, 3

200 likes

Look at this outdoor privacy hack she did

#diyhomedecor #balconymakeover #patiomakeover #privacyscreen #foldingscreen #diyhomeprojects

7512 likes

A pink camera mounted on a car dashboard, recording the road ahead. The car's infotainment system displays music and text related to "LOW BUDGET YouTube Video Ideas."

A white camera with a pink fluffy microphone attached, mounted on a car dashboard and facing the driver. The camera screen shows a person, with camera settings visible, against a background of trees and a house.

A pink background with the white text "BE CONSISTENT." centered on the image, offering advice for content creation.

Low Budget: YouTube Video Ideas

💕 It Girl Habits That Changed My Life 💕Becoming that girl on a budget 💕How to rebrand yourself 💕 How to Move Like a Confident Woman 💕Feminine Habits Nobody Talks About 💕Girl Talk: Cutting Off People Who Drain You 💕Things I Stopped Doing to Level Up My Life 💕Becoming the Main Character in Re

1182 likes

My everyday go to's !🤌🏼😍

these are all pretty much my everyday go to's!! i linked the names & prices to make things easier for anyone wanting to try something new, all of these products in my opinion are amazing! i will list below what each product is & why i use it :) •hair, skin, & nails: it helps wit

379 likes

They aren’t doing a proper investigation. Just automatically “verifying” the dispute ⚠️❌ #evictions #eviction #fyp #creditrepair #creditscoretips

151 likes

How To Blend Videos On CapCut

CapCut Tutorial - How To Blend 2 Videos On CapCut To Make Cool Social Media Videos For Your Business! #contentcreatortips #contentcreationtips #smallcontentcreators #contentcreatorlemon8 #contentcreators

47 likes

✨Crazy Bread ✨

#mealprep #lemon8challenge Ingredients: Copy Cat Little Caesar’s Crazy Bread Baking & Spices 1/2 tsp Garlic salt 1 can Pizza dough, refrigerated Dairy 2 tbsp Butter 1/8 cup Parmesan cheese, grated Directions: 1. Roll out your pizza dough onto a clean surface, into a

410 likes

How to Stream Your Console on OBS Studio

For this I am using my Nintendo Switch but this should work for any other console as well. Step 1: Nintendo Switch & Capture Card Connection 1. Insert the HDMI cable into the Nintendo Switch Dock (where the HDMI Out port is located). 2. Connect the other end of the HDMI cable to the HDMI I

364 likes

🥰10 best Amazon finds you must have 🌸

#amazonfinds #amazonmusthave #homeimprovement #kitchenhacks

186 likes

How to Properly Cut an Avocado

1. Cut around the fruit vertically 2. Twist, turn, open 3. Use the butt of your knife to remove the pit 4. Push the pit off the knife with your thumb That’s it. That’s the tweet. #lemon8partner #cookingtips #avocado

842 likes

Here is your sign 🌱 #verticalgarden #verticalgardening #gardentok #onthisday

16 likes

How to join amigurumi pieces

Think sewing parts together is hard? It’s not it’s just one stitch at a time 💛 Save this for your next project 👇 #crochettutorial #amigurumi #crochetforbeginners #handmadejourney #crochet

66 likes

🕰️ Study in the early morning 🍵 Don’t forget matcha ✍️ Don’t forget to use FREE note-taking app @freenotesapp 🌱 There’re many FREE note templates available #studywithme #unilife #takenotes #note #notetaking #study #studymotivation #studentlife

797 likes

9 SMART WAYS TO GROW VEGETABLES VERTICALLY 🌱

You don’t need a big garden to grow MORE food 👀 These 9 vertical gardening ideas help you: 🌱 Save space 🌱 Grow healthier plants 🌱 Harvest easier Which one would you try first? 👇 Save this for your next planting season 📌 #vegetablegardening #gardentips #indoorgardening

95 likes

Brain Health is Important to age gracefully

This product is great, works fine for me since I started college , it helps with my memory etc . I recommend taking this before you go to sleep , if you take it in the morning take it after you eat. Make sure you eat before putting any type of vitamins into your body #goodvitamins #vitamins #

37 likes

A woman with long blonde hair smiles in a car, holding a white fluffy dog. Overlay text reads "NURSING STUDENT NOTES Pharmacology" in yellow and pink, with "lemon8 @kels.colli" at the bottom left.

Pharmacology notes for week 1, part 1, detailing characteristics of an ideal drug, drug naming conventions (trade, chemical, generic), and phases of drug research and development, including pharmacodynamics. A pink medicine bottle is depicted.

Pharmacology notes for week 1, part 2, covering pharmacokinetics (ADME: absorption, distribution, metabolism, excretion/elimination), clinical trial phases (1, 2, 3), first-pass metabolism, and bioavailability.

notes pharmacology

I have way more on TikTok #studytips #study #nursingstudent #nursingschool #notes

62 likes

A blurred image of a person in a steamy shower with text overlayed, reading 'Gym Girlie Shower Routine' and 'How I Keep my skin & hair: soft, radiant, and smelling amazing as a dedicated gym rat'.

Various shampoo and conditioner bottles are arranged around a person with long, brown hair, illustrating different hair care products for cleansing and conditioning.

A collage of hair oil and pre-wash products surrounds a person washing their hair under a shower, showcasing items for hair treatment before shampooing.

Gym Girl✨Must Have✨Shower Essentials🧼🪒🫧

If you’re tired of breakouts, constant oily hair or dry-cracked skin from your daily workouts, here’s what I and all the woman in my life would recommend: ℹ I surveyed multiple girl friends who are hair stylists and my own personal hair stylist, along with my sorority sisters and grandma who’s b

1521 likes

A whole pineapple sits on a wooden cutting board next to a knife, with text overlayed that reads "HOW TO CUT A PINEAPPLE Swipe" and a yellow arrow.

A pineapple with its leafy top removed, lying on a wooden cutting board next to a knife, with text overlayed that says "Cut off Top".

A pineapple cut in half lengthwise, with both the top and bottom removed, resting on a wooden cutting board next to a knife. Text reads "Cut in half, cut off bottom".

How To Cut Up A Pineapple

Yes, yes, you COULD buy a pineapple corer and slicer BUT where’s the fun in that? Why not learn the skill? With this method you can also control the size of the pieces. Pineapple cutting is great to learn for the summer! I plan on using them for parties, outings, and when I make summer drinks!

106 likes

Placement is everything! #interiordesign #homedecor #homedesign #art

319 likes

See more