How do I keep images from moving in Word?

Use In Line with Text for stable placement. If you need wrapping, choose Square/Tight and avoid fixed positioning until you understand anchors.

How do I make a Table of Contents in Word?

Apply Heading styles first, then go to References > Table of Contents and insert an Automatic TOC. Update it later by right-clicking the TOC and selecting Update Field.

What’s the best file format to share a Word document?

If you need others to edit, share a .docx. If you want the layout locked and view-only, export to PDF.

How do I create reusable document layouts?

Create a clean document using styles, headers, and layout, then save it as a Word Template (.dotx). This is ideal for recurring reports, proposals, and meeting notes.

Excel
Word
PowerPoint
Outlook
Google Sheets
Google Docs
Google Slides

How to Create Dropdown Lists in Excel (Windows & macOS)

Q: Is Microsoft Word different on Windows vs macOS?

The core features are the same, but menus and shortcuts can differ slightly. Most formatting, styles, tables, images, Review tools, and PDF export behave similarly across both platforms.

Q: What’s the best way to format headings in Word?

Use Word’s built-in Heading styles (Heading 1, Heading 2, etc.). Don’t manually bold and resize headings—styles keep formatting consistent and make Table of Contents work.

Q: Why does my Word document formatting break when I add new text?

Usually because spacing was created using repeated Enter presses or because headings were manually formatted. Switch to paragraph spacing and styles to stabilize the layout.

by Waheed Burna | Feb 3, 2026

Dropdown lists are one of the most effective ways to control data entry in Excel. Instead of allowing users to type anything into a cell, you can limit entries to a predefined set of values such as statuses, departments, categories, or approval states. This improves data consistency, reduces cleanup work, and makes reports more reliable.

In 2026, Excel dropdown lists are still built using Data Validation, but the experience differs slightly between Excel for Windows, Excel for macOS, and Excel for the web. The core concepts are the same, but the menus and dialogs look different, which often causes confusion when following older guides.

This tutorial walks through the complete process of creating dropdown lists in Excel, with clear steps for both Windows and macOS users. It also covers how to maintain dropdown lists as your workbook grows, how to prevent common errors, and how to design dropdowns that scale across teams and templates.

What You Will Learn

How to create a basic dropdown list using Data Validation
How to build dropdown lists from a cell range, named range, or table
How Excel dropdown setup differs between Windows and macOS
How to prevent invalid entries and guide users with messages
How to troubleshoot broken or inconsistent dropdown behavior

Prerequisites

No prior experience required.

Step-by-Step Instructions

Step 1: Plan and create the source list

Before creating a dropdown, decide where the allowed values should live. While Excel allows inline lists typed directly into Data Validation, this approach becomes difficult to maintain as lists change. A dedicated source list is strongly recommended.

Best practice is to place dropdown values in a single column on the same worksheet or on a separate worksheet named something like Lists or Data. Each value should be in its own cell, with no blank rows in between.

You can copy and paste the following example values directly into Excel to use as a dropdown source list:

Not Started
In Progress
Pending
On Hold
Completed
Cancelled

Example source list used for an Excel dropdown — A clean source list makes dropdown lists easier to manage and update.

Avoid mixing unrelated lists in the same column. Each dropdown should reference its own clearly defined range to prevent accidental changes later.

Step 2: Select the cell or range for the dropdown

Click the cell where you want the dropdown to appear. If multiple cells need the same dropdown, select the entire range before opening Data Validation. This is especially important if you are working with tables, where new rows should inherit the same validation rules.

If you apply Data Validation to only one cell and later copy it down, incorrect relative references may cause the dropdown source to shift unexpectedly.

Step 3: Open Data Validation (Windows and macOS)

The Data Validation command is located in the Data tab on both platforms, but the interface looks different.

Excel for Windows: Data > Data Validation
Excel for macOS: Data > Data Validation

Excel for Windows Data tab showing the Data Validation button — Excel for Windows: open Data Validation from the Data tab.

Step 4: Configure the dropdown list settings

In the Data Validation dialog or pane, configure the following core settings:

Set Allow to List
Click into the Source field
Select the cells containing your source list
Ensure In-cell dropdown (or In-cell drop-down on macOS) is enabled

Excel Data Validation dialog with Allow set to List on Windows — Windows Data Validation dialog configured to allow a list.

Excel for Mac Data Validation settings with Allow set to List — macOS Data Validation window showing list-based validation.

Excel typically converts the selected range into an absolute reference such as =$A$2:$A$6. This is desirable because it prevents the reference from shifting when copied.

Step 5: Control how Excel handles invalid entries

By default, Excel allows users to type values that are not in the dropdown list. To enforce data consistency, configure the Error Alert settings.

Stop: Blocks invalid entries completely
Warning: Warns users but allows exceptions
Information: Displays guidance without enforcement

For most business templates, the Stop option is recommended. Pair it with a clear message such as “Please select a value from the list.”

Step 6: Test the dropdown behavior

Click the validated cell and confirm that the dropdown arrow appears. Expand the list and verify that all expected values are present and displayed in the correct order.

Excel dropdown list expanded inside a cell on Windows — Final result on Windows: users select values from the dropdown.

Excel dropdown list expanded in a cell on macOS — Final result on macOS: dropdown list expanded inside a cell.

Step 7: Make dropdown lists easier to maintain

Range-based dropdowns work, but they require manual updates when new items are added. Two techniques significantly improve long-term maintainability:

Named ranges: Assign a name to the source list and reference it in Data Validation using =NameHere.
Excel Tables: Convert the source list to a Table so new entries are automatically included.

Tables are especially effective in shared workbooks because they reduce the risk of broken validation when rows are inserted or deleted.

Common Mistakes and Fixes

Dropdown arrow is missing: Confirm the cell is not merged and that In-cell dropdown is enabled.
Blank options appear: Remove blank cells from the source range.
Validation error appears unexpectedly: The value is not in the list; update the source list if needed.
Dropdown breaks when copied: Use absolute references or named ranges.
Different behavior on web vs desktop: Always save the workbook after editing Data Validation in desktop Excel.

Tips and Best Practices

Keep all dropdown source lists in one dedicated worksheet.
Use clear, human-readable values rather than abbreviations.
Lock dropdown cells in protected sheets to prevent accidental changes.
Apply Data Validation to table columns so new rows inherit rules automatically.
Document dropdown logic for complex templates used by teams.

Practical Use Cases

Project status tracking and reporting
Expense categorization and approvals
HR onboarding and training tracking
Academic grading rubrics and evaluations
Operational dashboards with standardized inputs

Conclusion

Dropdown lists are a foundational Excel feature that dramatically improves data quality with minimal effort. By combining Data Validation with well-structured source lists, named ranges, or tables, you can build spreadsheets that scale cleanly across teams and platforms. Whether you are working on Windows or macOS, the principles remain the same: define trusted values, enforce selection, and design for maintainability.

Frequently Asked Questions

Is Microsoft Word different on Windows vs macOS?

The core features in Microsoft Word are the same on Windows and macOS, including formatting tools, styles, tables, headers, page numbers, Track Changes, and PDF export. However, menu layouts and keyboard shortcuts can differ slightly. Most beginner-level and intermediate features behave consistently across both platforms.

Can I use the same formatting rules in Google Docs?

Yes. Concepts like paragraph spacing, heading styles, tables, image wrapping, comments, and exporting to PDF work similarly in Google Docs. While the interface looks different, the formatting principles remain the same. If you understand styles and spacing in Word, you can apply the same logic in Google Docs.

What’s the best way to format headings in Word?

Use Word’s built-in Heading styles (Heading 1, Heading 2, Heading 3, etc.). Avoid manually bolding and resizing text for headings. Styles keep formatting consistent, enable the Navigation Pane, and allow you to generate an automatic Table of Contents.

Why does my Word document formatting break when I add new text?

Formatting usually breaks because spacing was created using repeated Enter presses or because headings were manually formatted instead of using styles. Switching to paragraph spacing settings and proper heading styles keeps your layout stable and easier to update.

How do I keep images from moving around in Word?

Set images to “In Line with Text” for maximum stability. If you need text wrapping, use Square or Tight wrapping carefully. Avoid using fixed positioning unless you understand anchors and layout behavior.

How do I create a Table of Contents in Word?

First apply Heading styles to your section titles. Then go to References > Table of Contents and choose an Automatic Table. You can update it anytime by right-clicking the Table of Contents and selecting Update Field.

What is the best file format to share a Word document?

If others need to edit the file, share the document as a .docx file. If you want the layout locked and consistent across devices, export the document as a PDF. PDF format prevents accidental formatting changes.

How do I create reusable templates in Microsoft Word?

Create a properly formatted document using styles, headers, spacing, and layout. Then go to File > Save As and choose Word Template (.dotx). Templates are ideal for recurring documents like reports, proposals, meeting notes, and standard operating procedures.