Automatically translated.View original post

Bookmark Solve Workbook Problems with Multiple Sheets

2025/9/10 Edited to

... Read moreสำหรับคนที่ใช้งาน Excel บน Mac และมักจะเจอปัญหา Workbook ที่มีหลาย Sheet ให้ยุ่งยากในการจัดการ แนะนำให้ลองใช้ฟีเจอร์ Bookmark ซึ่งจะช่วยให้คุณสามารถบันทึกตำแหน่งของ Sheet ที่ใช้งานบ่อย ๆ ไว้ในช่วงการทำงาน ทำให้ไม่ต้องเสียเวลาคลิกหา Sheet ทีละแผ่น จากภาพ OCR ที่เห็นได้ว่ามีคำสั่งและฟีเจอร์ต่าง ๆ อาทิ การใช้คำสั่ง Activate, Consolidate, Sparkline, Solver และฟังก์ชันที่ช่วยจัดการข้อมูลในหลาย Sheet เช่น TEXTJOIN, VLOOKUP_left, SUMPRODUCT ซึ่งสามารถนำมาประยุกต์ใช้คู่กับ Bookmark เพื่อเพิ่มประสิทธิภาพ เทคนิคเพิ่มเติมที่อยากแชร์คือ การคลิกขวาที่มุมซ้ายล่างของ Excel เพื่อดูรายการ Sheet ทั้งหมดใน Workbook ทำให้เลือก Sheet ได้รวดเร็วขึ้น และยังสามารถใช้คีย์ลัด Cmd + คลิกซ้ายที่ลูกศรเพื่อนำทางไปยัง Sheet แรก หรือ Shift + คลิกซ้ายที่ลูกศรไปยัง Sheet สุดท้ายได้ด้วย นอกจากนั้นการสร้าง Bookmark ที่เหมาะสม จะช่วยให้การสลับหน้า Sheet เป็นหนึ่งคลิก และยังสามารถเก็บชุดสูตรหรือข้อมูลสำคัญไว้ใน Sheet ที่ทำ Bookmark เพื่อความเป็นระเบียบและสะดวกสบายในการเรียกใช้งาน ต่อให้ Workbook มี 22 Sheet หรือมากกว่านั้นก็ไม่ใช่ปัญหาอีกต่อไป หากคุณใช้ Excel สำหรับงานขายหรือจัดการข้อมูลสินค้าหลากชนิด เช่น ผ้าพันคอ, กางเกง, รองเท้า, เน็คไท การมีระบบ Bookmark ที่ดีจะช่วยเพิ่มความรวดเร็วและลดความสับสนในการสลับ Sheet ที่เก็บข้อมูลต่าง ๆ ได้ดีจริง ๆ ครับ

Related posts

(Another) Mental Health Workbook
The "Mental Health Workbook" by David Lawson, PhD, is an all-in-one guide that combines three powerful therapeutic approaches: Cognitive Behavioral Therapy (CBT), Dialectical Behavior Therapy (DBT), and Acceptance and Commitment Therapy (ACT). This book is designed to provide practical tool
Dahlia

Dahlia

900 likes

The #1 Japanese workbook to learn hiragana and kat
Learn hiragana and katakana and cover the basics of Japanese as fast as it gets! Mnemonics are the key to memorizing fast and recalling forever! #studyingjapanese #learningjapanese #learnjapanese #japanesebeginner #jlpt
Watashi Japanese

Watashi Japanese

29 likes

Tarot Mini Workbook
#tarot #tarotforbeginners #spirituality #witch #witchesoflemon8
HexAppeal

HexAppeal

279 likes

The #1 workbook to learn Japanese “letters”!
Hiragana and Katakana can be mastered in only a few days with this fun and effective workbook! Clever mnemonics make you memorize fast and recall forever! With online videos to practice listening and pronunciation! Fun reviewing exercises to reinforce memory and learn new vocabulary at the
Watashi Japanese

Watashi Japanese

26 likes

The #1 Hiragana and Katakana workbook
Learn Japanese the fast and effective way from clever mnemonic illustrations! #Japanesestudy #Japaneseletters #Japanesealphabet #japanesecharacters #nihongo
Watashi Japanese

Watashi Japanese

23 likes

The cover of 'Mental Health Workbook' by Emily Attached, Marzia Fernandez, and Gino Mackesy. It features a stylized brain illustration, with one half detailed and the other half abstract and colorful, representing the six books in one covering various mental health topics and therapies.
The Mental Health Workbook
The "Mental Health Workbook" by Emily Attached, Marzia Fernandez, and Gino Mackesy is a comprehensive guide designed to help individuals understand and manage various mental health issues. Covering six key areas in one book, it includes topics such as attachment theory, abandonment anxiety,
Dahlia

Dahlia

286 likes

The Workbook I Needed!
I have such overactive thoughts and put myself in unnecessary panics. I just think….. too much 😂 after being diagnosed with cancer I literally freak out over any and everything! 100X more than before! I always need something to keep my brain busy. These type of workbooks keep my mind busy thinking
💗

💗

491 likes

Korean Calligraphy Workbook
Korean language Korean study Korean app Korean learners #language #studygram #koreanlanguage #japanese #hangul
cozy_anni

cozy_anni

1279 likes

Workbook prompts for
cultivating a growth mindset.
Primal Presence

Primal Presence

8 likes

This workbook teaches Hiragana and Katakana fast!
The forever Japanese workbook is the fast and fun way to kickstart your Japanese language journey! #learningjapanese #hiragana #katakana #jlptn5 #workbook
Watashi Japanese

Watashi Japanese

13 likes

NeuroSpiritual Awakening Workbook:Heal Your Nervous System & Awaken Spiritually
A powerful, science-backed workbook designed to help you regulate your nervous system, heal trauma patterns, and reconnect with your authentic self. This guide blends neuroscience, spirituality, and shadow work/psychological healing to support deep transformation from the inside out. Inside you’
withlovefromchelle

withlovefromchelle

3 likes

Healing Workbook for $2.22 ✨
If everything feels heavy, overwhelming, or like you’re not yourself anymore, my workbook is a place to start. WHAT IT IS: “Come Back to Yourself” is a guided digital workbook designed to help you: * feel immediate relief when everything feels like too much * understand what changed in you (w
withlovefromchelle

withlovefromchelle

2 likes

A hand holds the cover of "THE AUTISTIC BURNOUT WORKBOOK," which offers guidance on sensory self-care, masking, spoon theory, and nervous system regulation. Overlay text reads "BOOKS That shaped me" with star ratings.
An open page of the workbook displays "CHAPTER 1 What Is Autistic Burnout?" in large blue text. The page number 11 is visible at the bottom.
A page from the workbook details "The Impact of Autistic Burnout on Your Life," covering effects on physical health, relationships, mental health, quality of life, daily living, and work/academics.
Workbook Review: Autistic Burnout 🥵
This workbook has truly been such a validating read for me. It breaks down masking, spoon theory, sensory overwhelm, and nervous system regulation that makes everything feel “human” instead of clinically overwhelming. What I appreciate most is how deeply relatable it is. There were so many mome
thaawhispersong

thaawhispersong

15 likes

The cover of 'The Ultimate Men's Self-Care Workbook' features a man writing in a notebook in a sunlit room, with a sign reading 'I AM HEALING CONSTANTLY'. It promotes a journey to prioritize, reconnect, and thrive.
A guide titled 'The Ultimate Solo Experience Guide' lists alphabetical self-care activities for men, from Adventure Day to Zen Day, covering physical, mental, and social well-being.
This section provides 'Self-Care Reminders' with daily, weekly, monthly, and yearly practices. It includes routines like skincare, cleaning, connecting with loved ones, scheduling health check-ups, and taking vacations.
The Ultimate Men’s Self-Care Workbook
If you’re looking for a self-care workbook for a male friend, brother, cousin, or yourself. Look no further. My men’s self-care workbooks are available for purchase on my Etsy shop. Clink the link in bio✨🫶🏾 Self-care isn’t Selfish #selfcareformen
Mkayy

Mkayy

12 likes

GROWTH MINDSET WORKBOOK
‘𝑩𝒆𝒊𝒏𝒈 𝑨 𝑩𝒍𝒂𝒄𝒌 𝑾𝒐𝒎𝒂𝒏' This workbook has everything! Do you want to break bad habits and gain healthy lifestyle habits? Get this workbook! Are you trying to budget, have better money management? Get this workbook! Are you trying to pray, seek, and find? (Workbook includes scriptures.) GET THIS
APRIL DANNI 🪻

APRIL DANNI 🪻

7 likes

This workbook teaches Japanese the smart way!
Learn hiragana and katakana in just a few days with the forever remember Japanese workbook!
Watashi Japanese

Watashi Japanese

0 likes

🇯🇵Japanese🇯🇵🧠Mnemonics🧠✏️workbook✏️
This #workbook is the smart way to learn how to read and write #japanese fast! Learn #hiragana and #katakana from a proven effective #studymethod !
Watashi Japanese

Watashi Japanese

30 likes

The #1 workbook to learn Japanese characters fast!
Learn #hiragana and #katakana fast with this beginner friendly #japanese workbook. #mnemonics are the trick to memorize fast and recall forever.
Watashi Japanese

Watashi Japanese

1 like

This workbook teaches hiragana smart!
Learn reading and writing Japanese fast with this workbook! #japanese #hiragana #katakana
Watashi Japanese

Watashi Japanese

4 likes

The #1 workbook to remember Japanese characters!
Learn Japanese Hirgana and katakana fast with the forever remember Japanese workbook! Clever mnemonics to make you never forget Japanese again! #hiragana #studyjapanese #learnjapanese #jlpt #nihongo
Watashi Japanese

Watashi Japanese

23 likes

Powerful Workbook & Planner
I'm so excited to share with you all that I created & carefully designed a 130+ page all-in-one Manifestation & Self development printable workbook, and this is a worksheet from the Workbook I created! It combines goal-setting, organization, visualization, affirmations, daily plannin
soulfulmanifest

soulfulmanifest

24 likes

The front cover of the "Self-Love Workbook for Women" by Megan Logan, MSW, LCSW, featuring colorful abstract designs and the title. Text overlays read "HAPPY MIND HAPPY LIFE" and "Swipe."
The back cover of the "Self-Love Workbook for Women," detailing its purpose, a two-part approach, proven techniques, and the author's professional background.
The table of contents page for the "Self-Love Workbook for Women," listing sections like "LET'S TALK ABOUT SELF-LOVE" and "LOVE YOURSELF MORE" with chapter titles.
Self Love Workbook 🌸
I ordered this book last year and finally finished it. Highly recommend to any woman who is wanting to shift her focus back to self and dig deeper into their healing journey. I learned alot of hard truths about myself and working towards being much better not only to myself but to others. Y
DIVINELYMADETAROT

DIVINELYMADETAROT

165 likes

Decluttering with ADHD Workbook for Women
“And, in a moment that would mark the turning point of my clutterless crusade, I found not one, but three expired cans of cat food for a cat I never owned.” - Decluttering with ADHD Workbook for Women Hi lovelies! What an introduction eh? 😅 My new book “Decluttering with ADHD Workbook for Wom
✨Alea

✨Alea

7 likes

The clever hiragana and katakana workbook
Learn Japanese the fast and efficient way from mnemonics. #learningjapanese #japanesebeginner #hiragana #katakana #japanese
Watashi Japanese

Watashi Japanese

1 like

This workbook is just AMAZING! 🌸
Este libro de crecimiento personal fue recomendado por una YouTuber a la cual he seguido y mirado por más de un año y me atreví a comprarlo para ver qué tal era y realmente es increíble! Es como tener terapia pero en vez de tener a alguien en frente de ti, las preguntas te las hace el libro. Honest
Gigi Garcia🍒

Gigi Garcia🍒

10 likes

This workbook teaches how to read Japanese fast!
Mnemonics are the trick to cover the Japanese basics in just a few days! This workbook is the fast and fun way to kickstart your language learning journey! #learningjapanese #hiragana #katakana #japanese #jlpt n5
Watashi Japanese

Watashi Japanese

4 likes

This Japanese workbook plays it smart!
#learnjapanese #hiragana and #katakana from clever #mnemonics .
Watashi Japanese

Watashi Japanese

0 likes

Do You Feel Like Your Mind Creates Problems Early?
Sometimes your mind tries to solve problems before they even happen. This often comes from a desire to avoid disappointment, feel prepared, or stay emotionally safe. But instead, it can create stress, overthinking, and unnecessary worry. Learning to pause and recognize when your thoughts are
QuietClarity

QuietClarity

18 likes

Come Back to Yourself: A Guided Workbook for Healing & Self-Discovery 🌿✨
If you feel disconnected, overwhelmed, or unsure of who you are anymore, this workbook is your starting point. “Come Back to Yourself” is a gentle but powerful guide to help you reconnect with your emotions, rebuild self-trust, and feel grounded in who you are. Inside you’ll: * Process emo
withlovefromchelle

withlovefromchelle

2 likes

A hand holds a Highlights preschool workbook, with a child in the background. The workbook is for preparing children for preschool, covering various foundational skills.
An open page of the workbook shows a 'Kitty Toys' activity, where children trace lines and identify the smallest toy, demonstrating teacher-approved fine motor skill activities.
An open workbook page displays activities for tracing uppercase and lowercase letters, along with emergent writing exercises, covering ABCs, 123s, counting, colors, shapes, and matching.
Highlights Preschool Workbook
My daughter just turned three, and I am absolutely loving this age. It’s so fun to see her learn new things every single day. I can’t imagine how much new information and knowledge she’ll come home to tell me about once she’s actually in preschool! Until then, I love introducing age appropriate
Olivia Harper

Olivia Harper

15 likes

MEL ROBBINS WORKBOOK TO MAKE 2024 THE BEST YEAR ✨
My favorite podcast is for sure the Mel Robbins podcast ! I have been listening to soooo many episodes so when I saw that they were giving away this workbook I did not hesitate a second and printed it ! It was such a great way to do a little reset. This beginning of 2024 was not so fun for me a
Ines blond

Ines blond

19 likes

A hand with white-tipped nails rests on an open workbook titled "SPIRITUAL SELF CARE FOR BLACK WOMEN." Overlay text reads "Before this New year starts..." with a Lemon8 watermark.
A hand with white-tipped nails covers part of a "SELF CARE ASSESSMENT" page in a workbook, listing spiritual self-care activities. Overlay text says "Help yourself" with a red heart and prayer hands emoji.
A workbook page titled "SELF DISCOVERY QUESTIONNAIRE" with questions about values and dream life. A light-colored book cover with a gold circular design and barcode is partially visible.
Self Care Workbook
Link in my amazon storefront under self help.🤌🏽 Transparent moment, I have had this workbook for about two years.. Picked it up one day, filled out a page and did not go back to it until a few days ago. It really makes you think about who you are, what you want, and what you are lacking sp
Princess Damii

Princess Damii

11 likes

Two spiral-bound workbooks for toddler learning activities are displayed on a wooden table. The front workbook is themed "October Peek-a-BOO" with Halloween illustrations, while the one behind it is for "September" with a farm theme. The overall title is "Monthly Theme WORKBOOK Toddler Learning Activities."
Two open workbooks display "Color of the Month" pages. The front page focuses on "RED" with a red barn and farm elements. The page behind it focuses on "BLACK" with a spooky Halloween theme, including a haunted house and bats. The text highlights learning colors.
Two open workbooks show "Letters of the Month" pages. The front page features a large red apple for "A" and a red barn for "B." The page behind it displays a black cat for "C" and a dalmatian dog for "D." The text emphasizes learning new words.
Monthly Theme Workbook for Toddler Learning
As a stay at home mom, I wanted to incorporate more learning opportunities into my toddler’s day now that she’s starting to say words. I came up with the idea to start homeschooling and do theme months to make it fun! I created a workbook on Canva and shared it on my TikTok page. It got so much
Samantha Gail

Samantha Gail

175 likes

Teens Budget Workbook
Typically teens start working around 14/15, and most will tell you it's their money they worked for. Though true the importance of budgeting and saving is essential. #teenfinance #budgetingguide #financialliteracy #lifeskills #teenbudgeting
Unique| Multifaceted

Unique| Multifaceted

2 likes

Becoming her 7 day devotional workbook
Some weeks don’t need pressure — they need prayer, reflection, and grace. 7 Days of Becoming Her is a gentle devotional created for women choosing God, growth, and softness one day at a time. If you’re ready to slow down, realign, and grow with intention, this is for you 🤍 Link in bio to be
Ramona

Ramona

11 likes

Self Love Workbook 🌸
VetteRene💗

VetteRene💗

166 likes

burnout Armor workbook
Burnout Armor is a practical guide for protecting your energy and reinforcing boundaries when you’re already tired. No calls. No emotional labor. No pressure to “fix yourself.” Just tools that help you feel steady again. Burnout Armor is available digitally and instantly downloadable, li
AuraLuxe888

AuraLuxe888

2 likes

The image shows the cover of 'How to Meet Your Self: The Workbook for Self-Discovery' by Dr. Nicole LePera, 'The Holistic Psychologist' and #1 New York Times Bestselling Author. The dark blue cover features white and yellow lightning-like patterns.
Self discovery workbook✨
A very powerful tool, to help you understand yourself on a better level. You will meet yourself You will meet your habit self You will meet your emotional self You will meet your authentic self #selfhelpbooks #fyp #selfdiscovery #workbook
Hali Shanyfelt

Hali Shanyfelt

9 likes

A MINDFUL Workbook for your healing journey ✨❤️‍🩹
Hey guys! So can we talk about how important it is to journal/write? If you’re going through your healing journey or trying to live a more mindful life definitely look into getting some sort of self awareness/mindful journal. This book has helped me in so many ways and I’m not even done rea
ZoyaRainn🪐

ZoyaRainn🪐

35 likes

Hebrew Free Guide & Workbook
Received this picture from a student who is using my Hebrew 1 Workbook teaching the Print letters AND have also printed out my FREE GUIDE which will have you speaking Hebrew in as little as 4 Hours! (If you want to learn all about the number 4 just scroll down to this mornings video lesson 4️⃣)
Hebrew by Inbal

Hebrew by Inbal

6 likes

Korean Vocabulary Workbook on Amazon
You can learn 240 Korean Words and practice handwriting recognition #workbook #kpop #newjeans #illit #bts #kdrama #koreanlanguage #kawaii #korean #aesthetic 💰Price on USA Amazon: 19.99$ 🧼🌸Available in Amazon in other countries 💜: search 🔍 Korean 240 Vocabulary Words
Lilac Ann

Lilac Ann

21 likes

7 Stages of Grief Healing Workbook
HealingJourneyForward

HealingJourneyForward

3 likes

A Japanese language learning guide showing mnemonic illustrations for Hiragana characters か (KA), き (KI), く (KU), け (KE), and こ (KO). It also features the cover of 'The Forever Remember Japanese Workbook' by Watashi Japanese, designed for beginners to learn Hiragana and Katakana from visuals.
The #1 workbook that teaches how to read Japanese🇯🇵
✏️Learn how to read and write Japanese fast! 💨The Forever Remember Japanese workbook by watashi Japanese is the fun and effective way to learn all hiragana and katakana fast! 🧠Kickstart your Japanese language journey with this new mnemonic study book! #learnjapanese #japanesestudy #j
Watashi Japanese

Watashi Japanese

5 likes

Cultivate Your Purpose Workbook
How are you moving in your purpose?
purpose_koach

purpose_koach

1 like

A watercolor painting in a spiral-bound sketchbook depicts a palm tree with green fronds and a brown trunk, standing on brown land next to blue water. A Lemon8 watermark is visible at the bottom left.
Watercolor Workbook!🌊🌴
I have been dying to try something creative and finally bought a watercolor workbook and a watercolor set. This workbook is so fun and I don’t think the first painting turned out too bad! #watercolorpainting #emilylexstudio #watercolor #cozyhobbies #cozygirl
Taylor 🖤

Taylor 🖤

15 likes

Where the Screaming Ends Workbook
the workbook I wrote for people to help them better understand their emotions, triggers, why they feel certain ways, why they react how they react, etc. I’ve included a couple blurbs from my past experiences for each section, to try to make it feel like you’re not alone, and to reassure others that
mvelvetbruises

mvelvetbruises

1 like

I Published My First Self-Reflection Workbook
I did it… I officially published my first book—and it’s not just something you read… it’s something you experience. Return to Yourself is an interactive self-reflection workbook designed for anyone who feels overwhelmed, stuck in their thoughts, or mentally drained. This isn’t just reading.
PsycHolistic Synergy

PsycHolistic Synergy

10 likes

See more