Lemon8Lifestyle community

Automatically translated.View original post

Blossombloom
Blossombloom

543 followers

Follow
Follow
Follow

7 saved
5

How to make a simple dropdown

Perfect way to add a list often. No need to edit Dropdown. Just type per line is fine.

6/1 Edited to

... Read moreในการสร้าง Dropdown ที่มีประสิทธิภาพใน Google Sheets สิ่งที่ควรรู้คือการใช้ฟีเจอร์ Data Validation ที่ช่วยให้กำหนดเงื่อนไขของข้อมูลได้อย่างรวดเร็ว โดยเฉพาะเมื่อต้องการเพิ่มรายการมาก ๆ บ่อยครั้ง การตั้งค่าที่น่าสนใจคือการกำหนดช่วงข้อมูล (range) ที่จะเป็นแหล่งของ Dropdown ทำให้เมื่อเราพิมพ์ข้อมูลใหม่ลงในช่วงนั้น รายการ Dropdown จะปรับอัตโนมัติ ไม่ต้องคอยเข้าไปเปลี่ยนแปลงตั้งค่า Data Validation ทุกครั้ง จากประสบการณ์ส่วนตัว ฉันได้ใช้งานวิธีนี้ในโปรเจคจัดการข้อมูลลูกค้าที่ต้องเพิ่มหมวดหมู่ใหม่ ๆ อยู่เสมอ การใช้ช่วงข้อมูลแบบนี้ช่วยประหยัดเวลามาก ไม่ต้องเสียเวลาคลิกแก้ไข Dropdown และลดข้อผิดพลาดในการลืมอัปเดตรายการด้วย นอกจากนี้ ควรตั้งใจจัดระเบียบข้อมูลใน Sheet ให้ดี เช่น สร้าง Sheet เฉพาะสำหรับเก็บรายการ Dropdown เพื่อไม่ให้ตารางหลักซับซ้อน และง่ายต่อการบริหารจัดการ ปรับเปลี่ยนข้อมูลได้ทันที เมื่อต้องการลิสต์ใหม่ก็แค่เพิ่มหรือแก้ไขใน Sheet นั้น รายการ Dropdown จะอัปเดตโดยทันทีอีกด้วย เมื่อใช้งานกับฟีเจอร์อื่น ๆ เช่น การกรองข้อมูล หรือการทำ Pivot Table ก็จะทำงานร่วมกันได้สะดวก ด้วยเหตุนี้วิธีทำ Dropdown โดยตรงจากช่วงข้อมูลจึงเหมาะกับทุกคนที่ต้องการความรวดเร็วและความแม่นยำในการป้อนข้อมูลแบบมีตัวเลือกอย่างมืออาชีพ

Related posts

A laptop screen displays Google Docs with colorful, organized notes on 'The Trial of Anne Hutchinson.' An overlay reads 'HOW TO MAKE GOOGLE DOC NOTES.'
A screenshot of Google Docs shows the 'Insert' tab menu open, with 'Drawing' and '+ New' highlighted, indicating the first step of the tutorial.
A screenshot of the Google Docs drawing tool shows the 'Shapes' menu open, with 'Rounded Rectangle' highlighted for selection.
Google Docs Notes Tutorial 📝💗
hey guys I’ve missed you! 😔🙏 college has been keeping me busy a lot of you asked me how I make my google doc notes so I’m finally dropping the tutorial 😏 📝 google docs tutorial 📝 step 1 (title): 1.) go into the insert tab and click drawing +new 2.) click on shapes and select “rounded r
juanita ☆

juanita ☆

29.5K likes

How To Make A Simple Content Planner on Your iPad
Here’s an easy way to make a content planner on your iPad to help you organize your content. This will be a simple, generic tutorial (you can customize it further). 📅 You will need to download Google Sheets from the App Store for this planner. 📅 Once you have Google Sheets installed, your fir
🌻ChromaGlitch

🌻ChromaGlitch

237 likes

Here's how I do the Barbell rows in 5 simple steps
Here's how I do the Barbell rows in 5 simple steps.Try this out for a stronger and safer now! Cc:@Jeremyethier #barbellworkout #backworkout #armworkout
StrikeFit

StrikeFit

20 likes

Learn how to buy ETFs in your Roth IRA with this simple, beginner-friendly walkthrough. This is on the Fidelity app since that’s who I use, BUT you can use similar steps no matter where you have your account. 👏🏼 Education only. The ETF used in this video is an example and not a recommendation to pu
Mallory, CFP® Personal Finance

Mallory, CFP® Personal Finance

21 likes

A laptop screen displays a Canva design. An arrow highlights the "Template link" option within the "More ways to publish" menu, instructing the user to click it to generate a shareable template link.
A laptop screen shows a Canva design. An arrow points to the "Share" button in the top right corner of the Canva interface, indicating the first step to share the design.
A laptop screen displays the Canva share menu. An arrow points to the "See all" option, with a text overlay warning not to use the "Collaboration link" when sharing a template.
How to save & 🤑 your Canva templates or PLRs
Quick Steps to Sell a Template in Canva 1. Create Your Template: Design the product you want to sell, ensuring it’s editable for your buyers in Canva. 2. Generate the Template Link: Click the Share button at the top right. Select More… or See all from the dropdown menu. Find the Templ
Bri | Canva👑

Bri | Canva👑

388 likes

How I Take Notes with Google Docs ✨
As someone with ADHD, staying organized while studying is key! I love using Google Docs to keep my notes tidy and visually engaging. I spice up my titles with cute fonts and designs, and color-code key information to make it pop. Breaking down my notes into main topics and subtopics helps me stay f
Ethereal Studio

Ethereal Studio

151 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
KasuallyKat

KasuallyKat

365 likes

A Google Sheets-based 2025 content calendar for January and February, displaying an annual summary, monthly summaries for various platforms, and a published posts breakdown, with the overlay text "effective content planning tips."
A close-up of the 2025 content calendar setup for January, overlaid with the text "1. Use answerthepublic.com to brainstorm content ideas" and a screenshot of the answerthepublic.com website showing search results for "google sheets."
A close-up of the 2025 content calendar setup for January, with the text "2. Record your ideas so you don't forget!!!" and "I use Google Sheets & this is me setting up my content calendar," showing a dropdown list of items.
How I Content Plan In Google Sheets 🤌
(and post consistently while staying motivated) When I first started posting on L8, I had tons of idea for creating content but would hit a sluggish period like having a writers block when deciding what content should I post & when. A lot of it was trial and experimenting to understand what
TheHappyPlanner

TheHappyPlanner

101 likes

Shopify menu customization tutorial
Here is how to create a dropdown menu on Shopify, this is a great method for if you’re looking for a Shopify menu customization tutorial. The Shopify theme in this video is on my page 🤍 #shopify #makemoneyfromhome #shopifytips #startabusiness #viral
McKenna Beverly

McKenna Beverly

1 like

Drop down chips
Drop down chip tutorial. Add drop down options to your spreadsheet like this #tutorial #googlesheets #exceltips
Excel tips at XecuteTheVision

Excel tips at XecuteTheVision

37 likes

Blank EXCEL template for school nurses!
As a school nurse this isn’t perfect but I wanted to share it anyways. It is a BLANK excel template for students with health conditions. Just click and request access. Is there any other templates you’d like to have access to or need ? 1. Click my link tree in my bio!!! Click on drop down arrow
Officialtiktoknurse

Officialtiktoknurse

78 likes

A Google Sheets tab titled 'My Courses' displaying course codes and names, with an overlay indicating 'MY UPDATED ASSIGNMENT Master list' for academic organization.
A Google Sheets view showing a 'Course Schedule' by semester and year, alongside 'Course Progress' tracking finished assignments and completion percentages for various courses.
A Google Sheets 'Course Progress' section demonstrating auto-colored boxes (green, yellow, red) based on assignment completion percentages, with 0% completion being blank.
How to Create A Masterlist in Google Sheets
Starting template: https://docs.google.com/spreadsheets/d/1MrxXG08PumhN1c5z5-3_kUA1_H5-z9OJFzSz0c_BVUQ/edit. I recently updated my Google Sheets Masterlist and filmed a tutorial of the process a too. My Masterlist and Calendar has kept me on top of all my readings, homework, exams, and I also ad
TheHappyPlanner

TheHappyPlanner

476 likes

Simple weight loss meal plan for busy women!
For access to more weight loss & PCOS-friendly meal plans, please check the link in my bio! If you need quick and easy meals that the whole family can enjoy, the meal prep bundle would be a great option for you! I know trying to get more protein in your diet while being mindful of your c
Dr. Salako

Dr. Salako

1930 likes

An iPad displaying Goodnotes with notes on real estate, overlaid with text 'how to change a goodnotes notebook cover'.
An iPad screen showing the Goodnotes 'Documents' view with pink folders and notebooks, indicating to 'CREATE A NEW NOTEBOOK'.
An iPad screen showing an open Goodnotes notebook with a blank lined page, instructing to 'CLICK HERE TO SEE PAGE THUMBNAILS'.
how to change a goodnotes notebook cover 📒
Changing your notebook covers in Goodnotes is one of the cutest ways to make everything match the same aesthetic! You can make all your notebooks look the same like mine, or give each one their own individual look. It's such a cute way to make everything look neat and organized! #goodnotes
Madeline 🤎

Madeline 🤎

272 likes

A close-up of an armpit with visible hair, featuring orange overlay text that reads "HOW TO: SUGAR WAX" and sparkling graphic elements. A hand with painted nails is visible at the bottom.
A hand holds a clear plastic container filled with amber-colored sugar wax. Overlay text states, "1. Grab your $20 jar of sugar wax from Amazon."
Hands are shown pinching a portion of the amber-colored sugar wax from its container. Overlay text reads, "2. With clean hands, pinch the section you'll be using into the edge of the jar."
How to Sugar Wax in 7 Simple Steps with $20
I grew my armpits just for this blog 🥴🥲lol I have sugar waxed for about 8 years now and nothing compares. It’s gentle, super affordable, easy to use, and highly effective. It can be used in all areas 🤌🏾. Great for dark armpits, ingrown hairs, and sensitive skin. 🔅Step 1: Prep and Cool Down
Jau 🤎

Jau 🤎

766 likes

A MacBook displays a forest wallpaper with the text '3 Must-Have Mac Tools That Instantly Boost Productivity'. A small laptop icon with a lightning bolt is shown above the illuminated keyboard.
A MacBook screen shows the App Store featuring 'Raycast', described as a powerful launcher for searching apps, running shortcuts, and controlling functions from the keyboard.
A MacBook screen displays the App Store featuring 'Notion Web Clipper', described as a digital brain for creating dashboards, tracking habits, and planning content.
Work Smarter on Your Mac with These 3 Simple APPS
My Mac used to just look good… now it works like a boss too. 🧠💻 If you’re always bouncing between tabs or just want to feel more organized, these 3 tools changed everything for me. They’re fast, simple, and feel like secret weapons I wish I knew about sooner. Let me know if you want a full set
CozyGirlMama 😎

CozyGirlMama 😎

314 likes

Upgrade your Goodnotes Aesthetic 🔥
I LOVE😍 this Goodnotes feature❣️ This video teaches you how to change the color of your folders in Goodnotes 6. Follow to learn more Goodnotes tips🤎 #goodnotes6 #ipadapp #digitalorganization #studyaesthetic #digitalplanning
Chaffanie | Digital Planning

Chaffanie | Digital Planning

90 likes

Day 4 of 31; 31 days to a safer you. How you can delete all your data online “Incogni” 👇🏼 Follow for more #IncogniPartner
Cybersecurity Girl

Cybersecurity Girl

862 likes

Create a dynamic colored dropdown in 30 seconds
Spice up your spreadsheets! Learn how to create dynamic colored dropdowns in Googie Sheets in 30 seconds! This easy trick adds a pop of personality and organization to your data. #googlesheets #spreadsheets #dropdown #colorcoding #productivity
SheetsbyOlan

SheetsbyOlan

5 likes

A desk setup with a laptop and a monitor displaying a calendar interface, illustrating time blocking tips for better organization and productivity.
A screenshot of calendar settings for event notifications, demonstrating how to set up default reminders for events at 30 and 60 minutes.
A screenshot of calendar settings for time zones, illustrating how to add and display a secondary time zone, such as Pacific Time, for easier management.
Time Blocking Tips to Organize Your Calendar
Make your calendar work “for you”—not the other way around! ⏰  From setting up auto-reminders to tracking multiple time zones, these quick hacks are here to simplify your life.  Just tweak a few settings, and you'll have reminders that pop up automatically, custom views that fit your day,
Reverelia

Reverelia

169 likes

A Google Sheets dashboard titled 'Cost Splitter Dashboard' with financial summaries for multiple individuals. Large text overlay reads 'GOOGLE SHEETS HOW TO ADD IMAGES'.
A Google Sheets screenshot showing the 'Insert' menu with 'Image' highlighted, demonstrating the first step to add images. The text overlay says '1. INSERT > IMAGES'.
A Google Sheets screenshot showing the 'Image' submenu with 'Insert image in cell' and 'Insert image over cells' highlighted. The text overlay says '2. INSERT IMAGE IN CELL OR INSERT IMAGE OVER CELLS'.
👇🏻How I add images in Google Sheets
First Method: 💻 1. Copy and Paste OR Second Method: 🖥️ 1. Go to Insert > Images 🖼️ 2. Insert images ✅ 3. Upload and browse for image from computer These are the steps on a laptop and steps for the Google Sheets App are slightly different but I’ll bring sharing more tips on using
TheHappyPlanner

TheHappyPlanner

286 likes

Loungewear must haves 🌼💕
all of my favorite amazon loungewear finds! 📍 Find everything 🔗 on my amazon storefront in my bio (use dropdown links)! - 8 pack headbands, so trendy! - softest crewnecks ever, size up 1 if you want it extra comfy! - Aritzia quality cargo sweatpants, NEED in more colors - Lulu inspired mat
Katie Clark

Katie Clark

794 likes

Two brown throw pillows with subtle piping rest on a white textured sofa, introducing a collection of Amazon home finds.
A cream-colored stacking jewelry box with a clear lid displays various accessories, accompanied by a pearl-decorated hair claw clip on a white surface.
A tall artificial olive tree with green leaves and small olives stands in a light gray pot next to a white dresser and a window with horizontal blinds.
AMAZON HOME FINDS 🤎
amazon finds in my apartment! These are SO good & great for those on a budget!! ALL 🔗’s IN BIO IN DROPDOWN LINKS #amazondecor #amazonhomefinds #amazonapartmentfinds #neutralapartment #homedecorfinds
Katie Clark

Katie Clark

960 likes

A Google Sheets bingo card template titled 'MY 2024 BINGO' with a 5x5 grid, checkboxes, and a color dropdown set to 'Coral'. Overlay text explains 'How to make A bingo card In google sheets'.
A laptop screen displaying Google Sheets, illustrating steps to create a bingo card. It shows merging 4 rows (C15 to C18) and adding a checkbox from the 'Insert' menu, with instructions to repeat for a 5x5 grid.
A laptop screen showing Google Sheets, demonstrating how to add a dropdown in cell G2 and populate it with various color names like Aqua, Coral, Green, and Teal for customization.
✨ Use Google Sheets like a Pro - goals bingo card
This is how you can create an interactive Goals Bingo Card in Google Sheets: 1. Merge 4 rows 2. Add a dropdown below it 3. Outline all 5 rows (outer edges only) 4. Add a dropdown for changing color 5. In one of the boxes, add conditioning formatting using this custom formula: =AND(G2=&#3
TheHappyPlanner

TheHappyPlanner

39 likes

A Google Sheets budget calendar for 2024, titled 'How to zero-based Budget for beginners w/Google Sheets', showing monthly summaries, fixed and variable bills, income, savings, and spending categories for January and February.
Four steps for setting up a budget calendar: selecting the starting weekday and month, adding incomes, bills, and spending, and ensuring all funds are allocated, displayed on a Google Sheets interface.
Illustrations of budget allocation statuses: no income added, funds remaining to allocate, overspending, and achieving zero-based budgeting, each with a 'Left to Budget/Allocate' amount.
How to 0 based budget for Beginners 🤌
1. Write it down - use paper and pen, digital journals, or Google Sheets like one I’m using here 2. Start with monthly fixed bills (rent, auto payment, student loans, phone, internet,etc) and dates 2. Next are variable bills (electricity, water, medical bills, etc) and due dates 3. Plan when y
TheHappyPlanner

TheHappyPlanner

1455 likes

A hand holds a smartphone displaying the title slide for a tutorial: "Notion for Caregivers: A Step-by-Step Tutorial." The text "Life of Caregiver" is at the top left, and a "SWIPE" arrow is at the bottom right, indicating more content.
Three Notion mobile screens show the initial steps of a caregiver tutorial. The first covers getting started and creating a dashboard. The second details setting up a Medication & Health Tracker. The third explains setting up reminders and a Doctor Appointments & Medical Notes page.
Three Notion mobile screens continue the caregiver tutorial. The first shows details for Doctor Appointments & Medical Notes. The second outlines setting up a Daily Care Schedule using a Kanban board. The third demonstrates creating an Emergency Contacts & Important Information table.
Notion for Caregivers: A Step-by-Step Tutorial
Caring for a loved one can be overwhelming, with medications, appointments, daily routines, and emotional well-being all needing attention. Notion, a powerful and flexible organization app, can help caregivers manage responsibilities, track health updates, and stay organized. This tutorial will
GrievingGracefully | 💎4life

GrievingGracefully | 💎4life

16 likes

The image is a title card for an article about downloading MP3s directly to an iPhone. It features a music note with 'MP3' and a lightbulb icon, stating 'Download MP3 Directly to iPhone [3 Easy Methods]' and inviting users to learn effective methods.
🎵 How to Directly Download MP3 Files to iPhone
Want to add MP3 music to your iPhone without complicated syncing? This video shows fast and simple ways to download and transfer MP3 files to your iPhone for offline listening anytime. #applemusic #mp3 #musictrend #iphonetricks #TechTips
XanthusTechCore

XanthusTechCore

10 likes

How to Make Simple Perfect Salmon
Salmon is a great go to dinner that will keep you full #salmonrecipeideas #salmonrecipesideas #salmonbowlrecipe #salmonrecipe #food #cooking #easyrecipe #easydinneridea
Shenice at Home

Shenice at Home

19 likes

Stop Starting Over: Simple Tips to Build a Habit🫶
If you’re reading this, you’re probably ready to make the gym a part of your life—and not just for a couple of weeks, but for the long haul. I get it; staying consistent can feel impossible sometimes. But the good news is that consistency isn’t about willpower; it’s about understanding how human be
Chalie_Baker

Chalie_Baker

88 likes

An outdoor dining scene with people seated at tables, featuring the overlaid text "Freeze the Top Row in Excel." A purple glass is visible in the foreground on a black mesh table.
A light beige background with black text asking, "Do you ever have hundreds of rows of data and when scrolling down, you loose sight of the column header and forget which column/field is which?"
A light beige background with black text stating, "This is when freezing your top row is crucial! I will show you how!"
HOW I FREEZE THE TOP ROW IN EXCEL
The ability to freeze that first row of my column headers has been a lifesaver, allowing me to scroll through thousands of rows of data without losing sight of my column headers/fields. By simply selecting the row below the one you want to freeze, heading to the "View" tab, and clicking
Peyton’s Place

Peyton’s Place

105 likes

This is your sign to start planning out content
Go get the Social Media Calendar now it’s only $3.99 https://brookproducts.etsy.com/listing/1643592466 #contentcreator #contentcreatortips #newcreator #howtostartayoutubechannel #consistency #contentcreatorlemon8 #blackgirlcreator #blackgirlvlogs
Jani

Jani

1 like

A laptop screen displays a customized Google Docs notes page for 'Calc 3' with a pink title, class announcements, main topic, and class topics featuring colored dropdowns for understanding levels.
A laptop screen shows the Google Docs 'Page setup' menu, where the user is changing the page color to a whitish magenta, demonstrating the first step in customizing the notes page.
A laptop screen displays the Google Docs 'Drawing' tool, showing the creation of a pink, outlined 'Calc 3' title, illustrating how to make a fun title for the notes page.
Google docs custom notes page 💕
I love making these notes pages!! It really makes taking notes fun! The one thing I will say is that I do not do all my notes here, I mostly use them as keeping track of topics, announcements, and to make study schedules. The drop down menu is my favorite part; it is a must! It is super e
Sarah :)

Sarah :)

77 likes

Excel Trick:Create an Interactive Project Tracker😎
✨ Welcome to Our Excel Mini-Class! ✨ Hey Excel Pros!😉 Want to take your project management skills to the next level? Want to stay organized and on top of your projects like a true professional? Let's create a super simple yet interactive project tracker in Excel that'll keep you focused
WPS Office

WPS Office

6 likes

XLM and XRP as the future currency
XLM and XRP as the future currency that will be used after the global currency reset. Everyone is advised to start converting their money at the bank to XLM and XRP because very soon money at the bank will have no value again only XLM and XRP will be used for payment #works with any currency #fu
Happy Daddy

Happy Daddy

1 like

Simple Chocolate Crinkle Cookie Recipe
Is there anything better than a gooey, chocolate cookie? 🤎 • 1 Cup Unsweetened Cocoa Powder • 2 Cups Granulated Sugar •1/2 Cup Vegetable Oil (can use Canola or Light Olive) • 4 Large Eggs • 2 Teaspoons Vanilla Extract • 2 Cups All Purpose Flour • 2 Teaspoons Baking Powder • 1/2 Teaspoon
Keisha Painter

Keisha Painter

18 likes

Organized way to keep track of co-parenting
Keep track of visits, calls, schedule changes, and shared expenses in one organized place. This spreadsheet includes dropdown menus, auto-updating calendars, monthly summaries, and space for notes — no formulas needed. Works in Excel & Google Sheets. Just open it and start logging things as the
Loving.Templates

Loving.Templates

2 likes

A person with dark hair leans over a desk filled with various journals and stationery. The image has text overlays: '10 Simple and fun ways to use your journal Journal ideas' and 'lemon8 @haley.ledford2'.
An open journal page features decorative stickers, including a butterfly and a woman's torso with flowers. Handwritten text expresses aspirations like writing a book and being an author, alongside a large heart drawing with a personal message.
A hand writes in a lined notebook, creating a 'Brain dump' list. The list includes tasks like 'take Pics For blog', 'write out Shopping List', and 'Clean out Kids toys'. A pink heart emoji is overlaid.
10 simple and fun ways to use your journal
1. Morning Pages: This concept comes from the book written by Julia Cameron called The Artist way. It’s basically as soon as you wake up you’re gonna write three pages of a brain dump. It doesn’t need to make sense it just needs to be something to clear your mind first thing in the morning, and I’
Spookyymama

Spookyymama

15 likes

See more