Automatically translated.View original post

Rewrite anything other than "complete"!

Follow those who want to save more time ↓

@ hiro.shigotojutsu

─ ─ ─ ─ ─ ─ ─ ─ ─ ─ ─ ─ ─ ─ ─ ─ ─ ─

Can you use this time shortening technique right away?

It seems to be usable immediately! ▶ ︎ 💯

Take your time! ▶ ︎ 💪🏻

It seems to be no good at all ▶ ︎ 😭

Let me know in the comments!

─ ─ ─ ─ ─ ─ ─ ─ ─ ─ ─ ─ ─ ─ ─ ─ ─ ─

Fulfilling your life from work

@ hiro.shigotojutsu

─ ─ ─ ─ ─ ─ ─ ─ ─ ─ ─ ─ ─ ─ ─ ─ ─ ─

# excel

# Excel Convenience

# excel _ time

# excel _ beginner

The office job

2025/8/5 Edited to

... Read moreブルーリターンの「仕訳帳入力」が進まない原因って、入力画面そのものより“元データの整形”に時間を取られることが多いな…と感じています。私も最初は、案件ごとに「作業中」「取組中」「対応中」「進行中」みたいな表記がバラバラで、集計やチェックがしづらくて仕訳の転記ミスが増えがちでした。 そこでやってよかったのが、Excel側でステータス表記を先に統一してから、ブルーリターンに入力する流れです。例えば、一覧に「完了」だけは残したいけど、それ以外は全部「進行中」に寄せたい…みたいなケース。こういう時は、置換機能と範囲選択を組み合わせるとかなりラクになります。 私がよくやる手順はこんな感じです。 1) ステータス列だけを選択(テーブル化してあると列選択が一瞬です) 2) まず「完了」を一時的に別文字に退避(例:「完了」→「完了_KEEP」) 3) 次に、残りの候補(作業中/取組中/着手中/対応中/準備中など)を「進行中」に置換して統一 4) 最後に「完了_KEEP」を「完了」に戻す ポイントは、「完了」以外を一括で…が難しいので、“完了を守ってから全体を整える”発想にすることです。これだけで、表の見た目が揃って確認が速くなるし、ブルーリターンへ入力する前のチェック(未完了だけ抽出など)も簡単になります。 もう1つ、仕訳帳入力の時短で効いたのが、入力前に「日付」「摘要(例:広告用キーワード選定、動画アップロード作業、サムネイルデザイン制作 など)」「金額」「税区分」の揺れを潰しておくこと。摘要に表記ゆれがあると、後から検索して見直す時に引っかからなくて二度手間でした。 最後に注意点。置換は便利ですが、思わぬ列まで変えると事故るので、必ず“列(範囲)を選択してから”置換するのが安全です。私は置換前にシートを複製しておくか、元データを別名保存してから作業しています。こういう下準備をしておくと、ブルーリターンの仕訳帳入力が体感でかなり軽くなります。

Related posts

T.R. Anthko - Indie Author

T.R. Anthko - Indie Author

1 like

This image shows the title slide for an article on "PRODUCTIVITY HACKS How to Get Sh*t Done!", featuring bold text over a background of a desk with handwritten notes, sticky notes, and a planner, setting the stage for productivity tips.
A hand holds a green sticky note illustrating the "EAT THE FROG" productivity hack. It features a drawing of a frog and text advising to "Do your most challenging task at the start of your day," aligning with the article's explanation.
A hand holds a green sticky note detailing the "KANBAN BOARD" method. The note displays a diagram with "To Do," "Working On," and "Complete" columns, illustrating how to categorize tasks into three groups as described in the article.
9 Productivity Hacks: Finish What You Started
There are many techniques that help you finish your coursework, home chores, or just normal life tasks. Sometimes they can pile up and become overwhelming. Here are 9 productivity hacks that help me finish things, like this blog 😊: EAT THE FROG The “frog” is considered your most important and d
Jau 🤎

Jau 🤎

3029 likes

Rewrite Your Mind, Rewrite Your Reality: My Identity Shift Guide 🌿✨
Ever feel like your external results aren't matching your potential? The secret is in the mental code of your identity. You are the architect of your own experience, and it starts with choosing to rewrite your mindset every single day. I use this 3-step process to stay aligned with my future s
MindsetFreedom

MindsetFreedom

1 like

A laptop screen displaying 'Complex Numbers' content, with a notebook open below it showing handwritten math notes. Text overlays read 'Rewrite my notes with me! Pre-calc edition' and 'SWIPE'.
A blue Paper Mate mechanical pencil rests on a blank sheet of loose-leaf paper. A text overlay states, 'I always do loose leaf paper and use this pencil. This is my absolute favorite pencil for math!'.
A page of neatly rewritten pre-calculus notes on complex numbers, featuring headings, definitions, and examples. Text overlays indicate writing the section name and highlighting important information.
Rewrite my notes with me!
I always take my notes in person for pre-calc but they’re always so sloppy because i’m rushing so i always rewrite them when i get home. This is how I rewrite my notes taken in class! • • • #collegediary #lemon8contest #notes #college #school
natalie

natalie

66 likes

A woman with blue eyes and curly brown hair looks directly at the camera, framed by text about 'Growing & Changing for the Better' and 'Rewriting Assumptions.' The image has a soft, warm filter with sparkling effects and floral elements at the bottom.
Rewrite your assumptions
❤ Crocketts Corner ❤ 🌻 May 29th 2026 🌻 ✨🌿 Assumptions Are Growing & Changing for the Better 🌿✨ Not every story you once believed about yourself is meant to follow you forever. There are old assumptions dissolving now — assumptions rooted in fear, rejection, disappointment, survival,
Jennafer Crockett Psychic

Jennafer Crockett Psychic

2 likes

How to rewrite 50 pages of study guides without lo
Midterms week is here and you’re trying to romanticize your 8-hour study session in the library. But boring, scratchy pens make taking notes feel like a literal chore. ❌ #summerbod #travelwithme2024 #lemon8bookclub #erasable #fashionfinds
shands.us

shands.us

1 like

Rewrite your chapter
As therapists, we hold space for everyone else’s stories—helping clients rewrite narratives shaped by trauma, survival, and old patterns. But sometimes we forget that we’re allowed to do the same for ourselves. You don’t have to keep living in chapters that no longer reflect who you are. You do
bloomingmoore

bloomingmoore

8 likes

Rewriting Everything
The version of me you underestimated is the one rewriting everything. CStar Wells ©️ 2025 #CStarWells #RewritingEverything #Underestimated #BossEnergy
cstarwells

cstarwells

0 likes

A desk setup with a laptop, journal, and flowers, featuring the text '20 Aesthetic Journal Prompts to Turn Failure Into Growth' overlayed, suggesting a guide for self-reflection.
A list of journal prompts numbered 1 through 10, designed to help individuals reflect on past failures and extract lessons for personal growth, set against a textured background.
A continuation of journal prompts, numbered 11 through 19, focusing on self-forgiveness, resilience, and turning setbacks into success stories, presented on a textured background.
Revisit Your Failures, Rewrite Your Story
Failure often feels uncomfortable to revisit, but it holds some of our most powerful lessons. ✨What “failure” still lingers in my mind the most? ✨What actually happened in that situation, without judgment? ✨What emotions did I feel during that experience? ✨What did this experience teach me ab
🫧Alisha

🫧Alisha

18 likes

A graphic titled 'QUICK TIP' advises writers not to fear rewriting entire sections or chapters. It explains that rewriting is a crucial part of the writing process, leading to unexpected discoveries. The image includes the author's handle @DANIELLEKIRBYAUTHOR and Lemon8 branding.
Embrace the Rewrite
Sometimes the key to unlocking your best work is letting go of what you’ve already written. 🔄 Don’t be afraid to totally rewrite sections or chapters if something doesn’t feel right. The first draft is just that—a draft. ✍️ It’s normal to feel like you’re hitting a wall, but remember that writing i
AuthorDanielleKirby

AuthorDanielleKirby

5 likes

Rewrite Your Karma ✨
Your life isn’t shaped by luck or fate. It’s shaped by the patterns your soul still believes. “If you think you are beaten, you are.” That’s not just mindset…that’s your nervous system replaying old karmic programming. Most people don’t fail because they’re not capable. They fail becau
Kamela Hurley

Kamela Hurley

38 likes

Rewrite Your Narrative. Replace Old Stories.
How often do you stand in front of the mirror and speak to yourself with love? With 50 blank affirmation cards, The Things I Tell Myself When I Look in the Mirror creates space to write the words you most need to hear. Paired with a 13 oz Jasmine & Pear candle, soft floral and fruit notes hel
lightandwrite

lightandwrite

2 likes

Rewrite Your Story
Sometimes the pieces don’t fit back the way they once did… And instead of forcing them, maybe the real peace comes from creating something new. A new chapter. A new direction. A new version of you. ✨ Saving this here for anyone who needs the reminder today. 🤍 #LifeQuotes #HealingJou
journeywithjulee

journeywithjulee

1 like

You can rewrite your story at any time🖤
Forget it all. Forget all the limiting beliefs, forget what you’ve been so stressed to BE and DO to fit yourself into this box. Lose your mind and start tearing apart everything until you feel whole again. Until you come home. Until you start to feel like you. The new you, then build from there. Sto
whitneybarnette

whitneybarnette

10 likes

A motivational quote on a light background reads: "Go laugh in a place you've cried. Go win in a place you've lost. Rewrite your story." The Lemon8 logo and username @broken_swayzee are visible at the bottom left.
✨ Rewrite Your Story ✨
Life has a way of testing us in the hardest places… but you don’t have to stay stuck in the pain. Go laugh in the places you once cried. Go win where you once lost. You’re allowed to take back your power and write a brand new chapter. Healing doesn’t erase the past—it proves you survived it. 🖤🌹
Zero

Zero

25 likes

Rewrite it as many times as needed!
#youareenough #wordsthatwork #innervoice #talkpretty #rewrite
Haley Noah

Haley Noah

4 likes

Your self-hatred was never your idea babe, it’s ok to rewrite that narrative ❤️
Danielle SB

Danielle SB

71 likes

Incomprehensible- Rewrite edit
This was the second edit I made for Rewrite, best I ever made yet for TikTok ^^ #RewriteSonic #Sonicexe #Creepypasta #Fridaynightfunkn #RewriteSonicEdit
Blaze Mari

Blaze Mari

13 likes

🍋Rewrite Your Life, One Page at a Time ✨
You’re not stuck—you’re the author. 📖 Every choice, every step, every thought is a chance to turn the page and create a story you’re proud of. 💛🌈 #embraceauthority #embraceeverychapter #affirmations #Lemon8 #story
DoDigitalwithDay

DoDigitalwithDay

29 likes

A black screen displays the date and time "November 11, 2025 at 3:13 PM" and the phrase "Swipe it!". The Lemon8 logo and username "@luckylleslie" are visible at the bottom left.
Anyone else rewrite their texts over and over?
LuckyLLeslie🍀

LuckyLLeslie🍀

2 likes

Rewrite your story as many times you need to
#mindset #motivation #affirmations
Rooted.Sacred

Rooted.Sacred

4 likes

A modern glass house with a swimming pool at sunset, reflecting vibrant purple and orange hues. Overlay text reads: "DON'T BE AFRAID TO START ALL OVER AGAIN. YOU MAY LIKE YOUR NEW STORY BETTER." The Lemon8 logo and @rickthefactor handle are at the bottom left.
Rewriting Your Story: ℹ️⬇️
Embrace the Fresh Start! Ever felt like you’re stuck in a chapter that’s just not working? Maybe it’s time to turn the page! 📖✨ Example: Think about how many hit movies started with a complete rewrite. J.K. Rowling’s first “Harry Potter” draft was rejected multiple times before it became the
RoadToRiches

RoadToRiches

3 likes

Rewriting the narrative: You’re not too old.
Let’s rewrite the rules. ✍🏾 They said 60 was the end of something. But I know better—it’s the beginning. New dreams. New energy. New purpose. You're not too old, and it’s not too late. What chapter are you starting? #19sixtiesgirl #60isthenew40 #nevertoolate #rewriteyourst
19sixtiesgirl

19sixtiesgirl

2 likes

No More Excuses—It’s Time to Rewrite Your Story
You’re not broken. You’re just overdue for a breakthrough. This isn’t the time to play small—this is your wake-up call. Get up. Heal louder. Move different. Follow @healingisstillmessy if you’re ready to stop surviving and start owning your next chapter. #trustthejourney #embracevulnera
Lyric Reign

Lyric Reign

48 likes

You can always rewrite your life story
QueenDee

QueenDee

1 like

🌞 Rewrite the Story 💜
Trauma leaves fingerprints on the nervous system, but healing teaches your spirit to hold the pen. Every breath you take in safety rewrites a line the pain once authored. Every boundary drawn replaces a paragraph of chaos with calm. Every tiny act of self-kindness edits the chapter the pa
Grace & Growth N’ Her Healing

Grace & Growth N’ Her Healing

4 likes

Rewrite Your Ending
You can’t rewrite the past, but you hold the pen for what comes next. Today is a new chance to choose differently, to heal boldly, and to write an ending you’re proud of. 💫 💭 What chapter are you ready to rewrite in your life? Drop a ✍🏽 in the comments if you’re choosing growth over guilt. Ta
Brave Voyce

Brave Voyce

146 likes

Rewriting Your Past Failures✒️
🔒Failure doesn’t mean the end—it often means something unfinished within you. When you revisit it with honesty, it becomes clarity instead of pain. 1. What failure still affects me emotionally today? 2. What story have I been telling myself about that failure? 3. What actually happened vs what
🫧Alisha

🫧Alisha

18 likes

A light blue graphic displays the motivational quote: 'Stop blaming your past for your present. You're the one holding the pen now.' It includes 'Lemon8 @mlym2024' and an 'MLYM' logo, reinforcing self-empowerment.
Rewrite Your Story ✍️✨
You are not defined by your past. Every moment is a chance to take back control and shape your future. What chapter will you write today? #MindfullyLovingYourMindset #PositiveThinking #RewriteYourStory #SelfEmpowerment #MindfulLiving
MLYM

MLYM

33 likes

A motivational quote on a light background with abstract peach shapes, titled "STARTING A NEW CHAPTER." The text explains that a new chapter means finding closure, supporting who you're becoming, and writing a new ending instead of repeating old stories or dialogues.
Rewriting Your Story
Starting a new chapter signifies embarking on a new phase in your life by letting go of the past. It involves acknowledging that the old experiences and lessons have served their purpose and that it's time to move forward. Finding closure allows you to let go of the old patterns, relationships
Bryona

Bryona

231 likes

A light brown sticky note with handwritten dark text reads: "YOU'RE ALLOWED TO REWRITE YOUR STORY AT ANYTIME. LET'S BEGIN NOW!". The note is on a light, textured background, with "Lemon8" and "@the.quietarrival" in the bottom left.
You’re Allowed to Rewrite Your Story
You don’t need permission. You don’t need to wait until you feel ready. You’re allowed to begin again — in the middle of your life, in the middle of your story, in the middle of a quiet afternoon. Save this for the moment you remember who you are. The door is in my bio.
The Quiet Arrival

The Quiet Arrival

12 likes

Rewrite
KatK

KatK

1 like

I’m not here to fit in—I’m here to rewrite the rul
I built this brand from rock bottom. Not from strategy first—but from story. And now? I help women turn their struggles into personal brands that pay them to show up exactly as they are. This is your reminder that messy, real, and powerful are allowed to exist at the same time. Let’s make bold
Tara Lynn 17

Tara Lynn 17

30 likes

A handwritten note on white paper lists 'The worse thing we can do to a people' with four points: denying spiritual identity, turning them against mental capabilities, physical prowess, and intent to live. Bible verses Philippians 4:13 and Romans 8:31-39 are cited. Part of a printed text is visible in the background.
YOU CAN! REWRITE IT!.
BOBBY/CLIVE.

BOBBY/CLIVE.

2 likes

Rewrite your story
You have the pen to rewrite your story #mindfulness #mindset
Mind Fuel Daily Alchemy

Mind Fuel Daily Alchemy

0 likes

Rewriting
So, I was supposed to rewrite Courtney’s Redemption starting today. Unfortunately, I got sleepy and tired from doing my daily chores that I didn’t have the energy to write. Oh well, I will try again another day. #trusonsetseries #rewrites #indieauthor #books
Dominique Gibson Author

Dominique Gibson Author

3 likes

King Richard III's DNA Reveals a Shocking Truth That Rewrites 500 Years of History #KingRichardIII #DNADiscovery #ShockingTruth #HistoricalRevelation #RewriteHistory
Kyle Le

Kyle Le

17 likes

When They Hurt You… Then Rewrite You…
Some people will hurt you… and then act confused when you heal. So they rewrite the story. Not because you changed— but because the truth would require accountability. If someone is telling a version of you that doesn’t match your heart, your effort, or your growth… let them. You don’t
Cindy

Cindy

6 likes

Rewrite your story
You’re allowed to be any version of you you want. You don’t need permission or approval. Live out loud and be the author of your story. #selflovealways #selflovemotivation #motivationdaily #beyou #lemon8
lovemeco

lovemeco

5 likes

A purple image displays text for 'MAY 4, 2025 BY MONET MITCHELL' and 'Today's Word: REWRITE'. It includes a message about divine plot twists, a Bible verse (Romans 8:28 NLT), a prayer, and a call to 'Let God rewrite your story.' A Lemon8 logo and 'MOMO'S INTERCESSION MINISTRIES' are at the bottom.
Momos intercession

Momos intercession

7 likes

Rewrite the Thought, Rewire the Feeling
The stories we tell ourselves shape how we feel. When you change the thought, the emotion follows. Cognitive restructuring isn’t denial — it’s redirection. It’s choosing peace over the pattern that once protected you. Your brain can’t tell the difference between a remembered thought and a presen
Soul Sync

Soul Sync

8 likes

Rewrite your heart with Jesus
#heart #jesusfollower #biblestudy #fyp #godisgood #christian #jesuslovesyou #bible
Lex💐🌞💗✝️

Lex💐🌞💗✝️

78 likes

Rewrite Your Narrative
#moonritual #shadowwork #mirrormagic
sahreintalora

sahreintalora

1 like

Rewrite Your Story
With every sunrise, you’re given a new chance to rewrite your story. Each day is a blank page. What will you write today? Hashtags: #NewDayNewStory #SunriseVibes #RewriteYourLife #FreshStart #justbestfinds
JustBestFinds

JustBestFinds

6 likes

10 Small Ways To Be Kinder To Yourself
The way you talk to yourself is the longest conversation of your life. Track your self care daily in @Psyfy. Showing up for yourself counts as much as showing up for anyone else. Save this for later  |  Follow for more #selflove   #selfcare   #psyfy   #mentalhealth   #buildhabits
Lucia💕

Lucia💕

8 likes

Rewrite
Arielle Lynn

Arielle Lynn

25 likes

Have the courage to rewrite your life...
What if you rewrote the ending? One year from now, who could you be? Write it down and begin that version today. What title would your next chapter have? Share below. #rewritemystory #nextchapter #authoryourlife #manifestyourfuture #selflove
Alegna

Alegna

0 likes

See more