Automatically translated.View original post

あお｜Excelで“自分時間”を増やす働き方

8992 followers

Follow

Follow

Follow

214 saved

66

1

This is the fastest! How to total in an instant

[How to do]

① Select the cell of the total column

Press Alt, Shift, and = at the same time.

③ Press Enter

You can get the total in an instant.

① Press Ctrl and A at the same time to select all tables

Press Alt, Shift, and = at the same time.

The total of the whole table can be obtained in an instant.

Please try to imitate it by [saving] 😊

｡: + * ﾟﾟﾟ

How to Work to Increase Your Own Time with Excel

A way of working that doesn't require hard work

▷ Efficient 🪄

▷ Clear life fulfilled with Excel 🌿

▷ Housework and work 🌷

　

Home Freelance Mom 💻

Mom with three children | 3 years of entrepreneurial support | Contributed over 200 million yen

｡: + * ﾟﾟﾟ

2025/11/24 Edited to

Excelで頻繁に合計を出す作業をしている方にとって、ショートカットキーの活用は作業時間の短縮に大きく役立ちます。特にAlt+Shift+=のショートカットは、合計を瞬時に求められるため、複数のセルにわたる金額計算やデータ集計を効率化できます。表全体の合計を出す際には、Ctrl+Aで素早く全選択し、そこからAlt+Shift+=を押すだけでまとめて合計を出せるのも大変便利です。この方法は、特に日用品費や教育費、光熱費など項目ごとの集計をエクセルで行っている主婦やフリーランスの方にとって、繰り返しの入力の手間を大幅に減らせます。また、偏差値やその他の集計をエクセルで計算したい場合も、まずはこの基本ショートカットをマスターしておくと、他の関数入力がスムーズになります。私自身、子育てや家事の合間に書類作成をする時にこのショートカットを使っており、手間なく瞬時に合計が出せるのでとても助かっています。さらに、OCRで読み取った内容にもあるように、一つ一つSUM関数を打つのは時間の無駄。ショートカットキーを使うことで効率化し、Excel作業での“自分時間”を増やすことが可能です。実際に使ってみると、作業の集中力も高まり、ミスも減るのでおすすめです。ぜひ日々の仕事や家計管理に取り入れてみてください。

Related posts

the easiest & fastest way to get PR/collabs!!

#emailingbrands #prstrategy #microinfluencertips #prpackage #prpackages

816 likes

The fastest exercise to lose weight

#looseweight #Fitness #athomeworkout #fatburning

2073 likes

the easiest and fastest way to get pr!!

#pr #prpackage #howtogetpr #microinfluencertips #influencertips

197 likes

the fastest way to ruin a relationship

674 likes

Fastest & easiest way to deep clean a dishwasher

Also “should” and what actually happens are two very different things 😆 Mom life/life in general is hard, it’s okay if you don’t remember to clean your filter every 6 weeks. But I had to share the facts 💗 Here is the fastest and easiest way to deep clean a dishwasher without really doing much! U

1376 likes

This is the fastest easiest recipe ever

This is the fastest easiest recipe ever and I promise it’s amazing! My mom made it all the time when I was a kid 🧒🏻 I used the thin sliced boneless pork chops (season with salt, pepper, garlic powder) Lay them in a single layer in the bottom of a 9x13 Pan Preheat oven to 350 Cover with

352 likes

Why Playing the Villain Is the Fastest Way to Win.

#GirlsTalk #glowup #mindset #education #Lemon8

63 likes

The Fastest Way To Make Money

Book name: Book of Wisdom Volume 2 📖 Link in bio 🔗 #spiritualawakening #higherconsciousness #spirituality #meditation #booktok

159 likes

Fastest Rapper of the Generation??

#Kpop #fyp #viral #katseye

749 likes

15 HARD TRUTHS: LOWERING YOUR STANDARDS IS THE FASTEST WAY TO ATTRACT THE WRONG

Most people don’t end up in the wrong situations overnight… They slowly adjust. They tolerate. They justify. And before they realize it… what they once said “never” to becomes their normal. The truth is — Lowering your standards doesn’t make love easier… it just makes the wrong peo

45 likes

Squat + Lunge Combo = Total Leg Burner 🔥

I started adding this squat + lunge combo and wow… instant burn 😅 It’s simple but hits everything: ✔️ Glutes ✔️ Quads ✔️ Core The key is slowing it down and staying controlled. Don’t rush it. Try 8–10 reps each side and thank me later 🔥 Save this for your next leg day! #legdayworkout #

12 likes

A person in a leopard print bikini and sunglasses is lying on a red lounge chair on a grassy lawn, tanning under the sun. The image highlights a method for achieving a tan.

A hand holds a bottle of browning lotion, described as a favorite for achieving a fast, dark tan. The label lists Hawaiian ingredients.

A hand holds a pink spray bottle with a green top, filled with pink liquid, suggesting its use to spray water every 10 minutes while tanning.

Fastest way to tan as a College student

- spray bottle and re-soak yourself every often -works best with high UV - find a tanning lotion that works for you, also recommend using coconut oil as it has natural SPF and really moisturizing for the skin So hard in college to find time to keep up with tanning, but using this routine even

512 likes

Fastest ways to lose weight

#biovaloura #weightloss #tinywaist #looseweight #looseweightfast

2 likes

How I Make Money On Disney Dreamlight Valley | ✨✨✨

Are you tired of checking Scrooge’s shop everyday (maybe even each location from the 2 DLCs available) but NEVER having enough money for all the items you want. Then do I have the hack for you! Just follow these steps below and you can become a millionaire in Disney Dreamlight Valley just like me!

754 likes

The Fastest Woman in History

Florence Griffith Joyner, known as Flo-Jo, became the fastest woman in history during the 1988 Olympics in Seoul. She won three gold medals and set world records in the 100m and 200m that still stand today. #fyp #fyplemon8 #fypシ #fypシ゚viral #foryoupage

140 likes

my go to- instant pot pho

i like food, but i also like easy recipes. this is my go to pho recipe. it may not be the most authentic because these are the ingredients i can get in a pinch. but its still delicioussss 😋😋 #gettoknowme #pho #dinnerideas #recipeideas

666 likes

The Fastest Way To Manifest Any Reality

Book of Wisdom Volume 2 📖 Link in bio 🔗 #spiritualawakening #higherconsciousness #spirituality #books #booktok

31 likes

the Easiest & Fastest Way to Cut a Watermelon!

Save this for your 4th of July Party! Seriously a summer fruit game changer! the Easiest and Fastest Way to Cut a Watermelon with Zero Mess this summer! Discover the Ultimate Watermelon Cutting Technique: Say Goodbye to Messy Hands and Wasted Fruit! Learn How to Slice Watermelons with Pr

281 likes

Attempting the fastest 67

4876 likes

How to lose weight the fastest way possible

#weightlossideas #weightlossjourneytips #weightlosshabits #weightlosshacks #weightlossfinds

1 like

A person in blue scrubs, a surgical mask, and a patterned scrub cap takes a mirror selfie, with text overlay about becoming a Registered Nurse before 21 or in 2.5 years.

A smiling woman in white scrubs with a stethoscope stands in front of X-ray images, with text advising to find and apply to a local Community College ADN program.

A woman wearing clear-framed glasses and a grey sweatshirt is shown, with text emphasizing the importance of regional and national accreditation and applying for financial aid.

The Fastest Way to Become an RN,No One Talks About

Become a Registered Nurse in JUST 2.5 Years?! Here’s the Secret They Don’t Tell You! 🚨💉 If you’re looking for a fast and affordable way to become a Registered Nurse (RN), earning an Associate Degree in Nursing (ADN) from a community college is a great option! You can complete your ADN in as litt

428 likes

A woman stands by a palm tree with text overlay "HOW TO EARN $10K EVERY MONTH FROM TRAVEL". The image introduces methods to generate income from travel, as detailed in the accompanying article.

A beach resort with an infinity pool and hot tub illustrates "SELL HIGH-TICKET GROUP TRIPS ($10K IN 1 SALE!)". Text explains how to earn $10,000 profit from one luxury group trip by organizing experiences and earning commissions.

A beach resort with an infinity pool and hot tub illustrates "SELL DIGITAL TRAVEL ITINERARIES ($10K WITH PASSIVE SALES!)". Text details earning over $10,000 monthly by selling digital travel guides and using social media for traffic.

How to Make $10K/Month from Travel Step-by-step!

Imagine waking up, checking your phone, and seeing $10K deposited into your account from travel—without needing to book flights or be a travel agent. Sounds unreal, right? But it's 100% possible, and I'm breaking down 6 ways you can hit $10K/month from travel (even if you're a beginner)

26 likes

An infographic titled '15 mins SPEED CLEANING' outlines a six-step process for quick cleaning, including gathering supplies, picking up items, surface cleaning, cleaning floors, cleaning toilets, and removing trash, with estimated times for each step. An illustration of a woman sweeping is featured.

An infographic titled 'LITTLE CLEANING HABITS THAT MAKE A BIG DIFFERENCE' displays nine illustrated tips, such as wiping the bathroom sink, making the bed, emptying bins, keeping the sink clear, and using a microfiber cloth in each room.

A weekly cleaning schedule titled 'CLEAN HOME' details daily tasks for different areas, including bedroom, bathroom, kitchen, living room, and outside, from Monday to Sunday.

How to Keep a Clean Home 📌🫧🫧🫧

315 likes

Fastest way to lower blood sugar

#bloodsugar #hydration #glucose #fyp

184 likes

15 HARD TRUTHS: LOWERING YOUR PRICES IS THE FASTEST WAY TO DESTROY YOUR BUSINESS

This is where most businesses go wrong… They think lowering prices will bring more clients. More bookings. More growth. But what it really brings is: More pressure. More demanding clients. Less profit. And eventually… burnout. You don’t build a strong business by being the cheapest

3 likes

The best and fastest banana pudding recipe!

I’ve made this recipe for every holiday since I found it ! Thought I’d share with y’all as well, it’s delicious 🤤 #bananapuddingrecipe #bananapudding #desserts

101 likes

Fastest 100m ran by teenagers

#newtolemon8 #trackandfield #100m #bolt #fast

5 likes

The image displays three different acne treatment products on a bathroom counter, presented as solutions for overnight pimple relief. Text overlays indicate a guide on how to achieve clearer skin quickly.

A tube of acne treatment is shown, described as fast-absorbing and effective at penetrating and unclogging pores. This product is presented as a solution for reducing acne.

A bottle of acne treatment is featured, highlighted for its ability to calm inflammation and prevent future breakouts. It contains ingredients known for addressing skin concerns.

Fastest way to get rid of a pimple overnight

Here is how you can easily get rid of pesky pimples overnight with these 3 fast-acting acne solutions. Clean & Clear Persa-Gel 10, Murad Deep Relief Acne Treatment, and De La Cruz Acne Treatment with 10% sulfur offer powerful formulas to zap away blemishes and reveal clearer skin by morning.

464 likes

The Fastest Way to Stop a Panic Attack 🧊

The fastest panic attack hack costs nothing and works in just 30 seconds. Most people have never heard of this simple method, but it’s backed by your nervous system and can naturally reset your body. If you struggle with anxiety, panic attacks, or sudden stress, this technique is a safe, natural wa

21 likes

Florence Griffith Joyner — Fastest Woman Ever

Florence Griffith Joyner, better known as Flo Jo, still holds the world records in the 100m and 200m — records set back in 1988 that no one has come close to breaking. Her style, her speed, and her dominance made her more than a track star — she was a global icon who redefined greatness. A true l

1756 likes

How I lose 12 pounds in 5 days🥰

Lose 12 pounds in 5 days? Track your intermittent fasting with this app — it really works!! For post-feast recovery or rapid weight loss, try this 5-day fasting plan. Tested and truly effective! 🥚Day 1 – Egg Fasting Day Eat only eggs all day: 2 boiled eggs for breakfast, 3 scrambled eggs for l

814 likes

🌟The Fastest Way to Read & Remember🌟

If you’re spending hours reading but not remembering anything, I’ve been there too! When I first started medical school, I thought reading and re-reading my textbooks was the best way to learn, but I was completely wrong. I’d spend hours studying, only to realize I barely retained anything. That’s

17 likes

A plate of jollof rice served with red-sauced chicken and fried plantains, ready to be enjoyed as a complete meal.

Various fresh ingredients for jollof rice, including red bell peppers, an onion, tomatoes, and habanero peppers, laid out on a countertop.

Roasted red bell peppers, tomatoes, and habanero peppers in an air fryer basket, prepared for blending into a sauce.

Make Jollof rice in your instant pot

Jellof or Jollof how do you spell yours? First tip. Be familiar with the type of instant pot you use and tweak settings (temp, cooking time) to your pot. Ingredients can be found on the slides. #jollofrice #instantpotrecipes #nigerian #naijatiktok #westafrican #bestjollofrice

45 likes

The fastest way to manifest them back #beauty #lifestyle #letsesh #sesh

#hacks #subliminals #manifestyourlife #jessiemc00

21 likes

Fastest Cluckin Bell Stealth Run (Probably Ever)

3 likes

Crochet Girliess, spill your fastest project 🔦

I’ll go first! The quickest thing I can crochet are scrunchies! They take me about 15/20 mins (with no distractions, but let’s be realistic my adhd brain allows me 20/26 LMAO) What’s the quickest thing you can crochet?! Lemme know below cause I have a bunch of yarn and an empty stock lol and

630 likes

A close-up of a green watch with a gold-tone case, a green malachite-patterned dial, and a green alligator-embossed leather strap. The dial is adorned with blue gemstone hour markers and a diamond-encrusted bezel.

Instant Favorites❤️‍🔥

#bagsforwomen #colorfashion #pursehaul #guesspurse #bagcollection

4 likes

found the FASTEST way to level up as a student…

1⃣️Ditch Low-Energy Habits: Staying up late, binge-eating, complaining, getting angry over small things, overthinking, and giving up too easily—these things are holding you back. If you don’t cut ties with these bad habits (and with the people who drain your energy), you’ll just drift further from

33 likes

Get The FASTEST RP In GTA

3 likes

Fastest way to get around a busy traffic city.

Pigeon power! And don't forget the Starbucks! #STARBUCKS #traffic #pigeon #citygirl #citylife Proxima

6 likes

Man vs Dog FASTEST Sushi eating challenge!

Man vs Dog FASTEST Sushi eating challenge! whos gonna win #dog #funny #funnyanimal #funnypet #pets

630 likes

the smallest skincare mistakes age you fastest 😭

#glassskin #kbeauty #selfcareroutine #drsongserum #aestheticroutine #skincaretruth

81 likes

Sam’s Club Instant Savings

Sam’s club Instant Savings Love a good deal ❤️❤️❤️ no coupon clipping required #goviralonlemon8 #samsclubfinds #savingmoney #dealsandsteals

2 likes

Fastest way to see progress in gym

#progresstips #gainsinprogress #gymtipsforbeginners #bodytransformation #fyp

0 likes

Fastest ASMR is Relaxing

ASMR fast and aggressive triggers for sleep! Idk if Lemon8 is ready for Fast ASMR tinglea or not though. #asmrsleep #asmrforsleep #asmr #rynsey #asmrvideo

25 likes

my go-to instant pot pho. 🍲

as requested ♥️ i didnt promise this was the most authentic pho you can get, but to feed 3.5 humans and making it with quick ingredients i cant get at an asian market, it still hits the spot ♥️ 2 tbsp of ginger, cumin. 1 tbsp cinnamon. 1 tbsp ground cloves 1 tbsp anais extract 1 tbsp su

62 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

See more