How-to basics
Everyday tasks: sorting, filtering, formatting, printing, shortcuts.
- Calculate Age Between Two Dates in ExcelTo calculate a person’s completed age in years between two dates in Excel, enter the birth date in A2 and the date…
- Highlight Duplicates in Excel Lists: Step-by-StepTo highlight repeated values in an Excel list, select the cells you want to check, then choose Home > Conditional Formatting >…
- Calculate Age in Excel for a Specific DateTo calculate age in Excel on a particular date, put the birth date in A2 and the date to calculate against in…
- How to Calculate Percentage in Excel With a ShortcutIn Excel for Microsoft 365 on Windows, select the cells and press Ctrl+Shift+% to display their values as percentages; this shortcut formats…
- Conditional Formatting in Excel With ColorsIn Excel for Microsoft 365 on Windows, select the cells, then choose Home > Conditional Formatting and pick a rule; set its…
- Excel Conditional Formatting: How to Set It UpTo add conditional formatting in Excel for Microsoft 365 on Windows, select the cells you want to format, choose Home > Conditional…
- Excel Conditional Formatting for Yes/No Red and GreenYes—Excel can automatically color “Yes” green and “No” red with conditional formatting. For a status list in B2:B100, select that range, choose…
- Conditional Formatting Excel: Color an Entire RowYes. To color an entire row in Excel based on one cell, select the rows you want formatted, create a formula-based conditional…
- How to Add a Drop-Down List in Excel: Step-by-Step GuideTo add a drop-down list in Excel for Microsoft 365 on Windows, select the cell or cells, choose Data > Data Validation…
- Conditional Formatting Excel Dates Overdue: How to Set It UpTo highlight overdue dates in Excel, select the cells to format and create a formula-based conditional formatting rule. With due dates in…
- Yes or No Drop-Down in Excel: How to Set It Up FastTo add a Yes or No drop-down in Excel for Microsoft 365 on Windows, select the cell or cells, then choose Data…
- How to Add a Drop-Down List in Excel: Step-by-StepTo add a drop-down list in Excel for Microsoft 365 on Windows, put the choices in cells, select the cell or cells…
- How to Add a Drop-Down in Excel with Custom OptionsTo add a drop-down in Excel, select the cells, go to Data > Data Validation, choose List under Allow, and enter your…
- How to Add a Drop-Down List to an Excel TableTo add a drop-down list to an Excel table, select the cells in the table column, open Data > Data Validation, choose…
- Excel Header Drop-Downs: Add Filters or Choice ListsTo add a drop-down arrow for sorting or filtering, turn your data into an Excel table: select the data, choose Insert >…
- How to Add a Drop-Down List in Excel on SharePointTo add a drop-down list to an Excel workbook stored on SharePoint, open the workbook in Excel, select the cells that should…
- How to Add a Drop-Down in Excel Using Keyboard ShortcutsTo add a drop-down in Excel for Microsoft 365 on Windows, select the cell or cells, press Alt+D, L, choose List under…
- How to Add a Drop-Down List to an Excel Column Step by StepTo add a drop-down list to an Excel column, select the cells that should contain it, then choose Data > Data Validation.…
- How to Add a Drop-Down List in Excel for Easy EntryTo add a drop-down list in Excel for Microsoft 365 on Windows, select the cell or cells, choose Data > Data Validation,…
- Add a Drop-Down List in Excel or Google SheetsTo add a drop-down list, select the cell or cells where choices should appear, then create a list using Excel’s Data Validation…
- How to Add Color to a Drop-Down List in ExcelTo add color to a drop-down list in Excel, create the list with Data Validation, then use conditional formatting to color the…
- How to Add Colour to a Drop-Down List in Excel AutomaticallyTo add colour based on a drop-down choice in Excel, select the cells with the list, then create a separate conditional formatting…
- Excel Color-Coded Drop-Down Lists: Setup and RulesTo make a color-coded drop-down in Excel for Microsoft 365 on Windows, create a list with Data Validation, then use Conditional Formatting…
- How to Add a Calendar Drop-Down in ExcelTo add a usable date drop-down in Excel for Microsoft 365 on Windows, put a date list on a helper sheet, name…
- Create a Yes/No Drop-Down in Excel: Setup, Tips & FixesTo create a Yes/No drop-down in Excel for Microsoft 365 on Windows, select the cells, choose Data > Data Validation > Data…
- Excel Drop-Down Lists: How to Add and Manage Them EasilyTo add a drop-down list in Excel for Microsoft 365 on Windows, select the cells, choose Data > Data Validation, set Allow…
- Delete Blank Rows in Excel: Keyboard Shortcut GuideTo delete blank rows quickly in Excel for Microsoft 365 on Windows, select a column that should contain a value in every…
- How to Delete Blank Rows in an Excel Table SafelyTo delete blank rows in an Excel table, first identify rows that are genuinely empty, then remove the table rows rather than…
- Add a Drop-Down List in Excel: Setup, Tips, and FixesTo add a drop-down list in Excel for Microsoft 365 on Windows, select the cells, choose Data > Data Validation > Data…
- How to Delete Blank Rows in ExcelTo delete completely empty rows without removing records that have a few blank cells, add a helper column that counts each row’s…