How-to basics
Everyday tasks: sorting, filtering, formatting, printing, shortcuts.
- Encrypt an Excel Sheet: Passwords, Limits, and Safe SharingTo encrypt an Excel workbook so someone must enter a password to open it, use Excel for Microsoft 365 on Windows: go…
- Encrypt and Password-Protect an Excel FileTo encrypt an Excel file with a password in Microsoft Excel for Microsoft 365 on Windows, open the workbook and select File…
- Encrypt Cells in Excel? What You Can Protect InsteadNo—Microsoft Excel cannot encrypt selected cells by themselves. In Excel for Microsoft 365 on Windows, you can encrypt the entire workbook with…
- How to Encrypt an Excel File With a PasswordTo encrypt an Excel file in Microsoft 365 for Windows, open it and select File > Info > Protect Workbook > Encrypt…
- Encrypt an Excel File: Steps, Limits, and Safer SharingTo encrypt an Excel file in Microsoft Excel for Microsoft 365 on Windows, open the workbook and choose File > Info >…
- Encrypt an Excel Spreadsheet: Steps and Security TipsTo encrypt an Excel spreadsheet in Microsoft Excel for Microsoft 365 on Windows, open the workbook and select File > Info >…
- Employee Time Tracking Template Excel: Setup and TipsAn employee time tracking template in Excel is a worksheet that records each person’s work date, start time, end time, unpaid break,…
- Employee Training Schedule Template Excel: Build a PlanAn employee training schedule template in Excel is a workbook that lists each learner, course, date, duration, trainer, and completion status in…
- Employee Vacation Schedule Template in Excel: Setup GuideAn employee vacation schedule template in Excel is a shared calendar that shows who is requesting or taking time off and when.…
- Employee Shift Schedule Template Excel: Setup GuideAn employee shift schedule template in Excel can be a simple weekly grid for assigning shifts, supported by a separate log for…
- Employee Schedule Format in Excel: Build a Clear RosterAn employee schedule format in Excel works best when each shift has its own row, with columns for the date, employee, role,…
- Employee Shift Schedule Template: Free Excel GuideYes. You can make a free employee shift schedule in Excel by starting with a blank workbook or an available schedule template,…
- Employee Break Schedule Template in Excel: Setup GuideAn employee break schedule template in Excel is a roster that records each worker’s shift and planned break times so managers can…
- EMI Schedule in Excel: Build and Check a Loan TableTo make an EMI schedule in Microsoft Excel, calculate the regular payment with the PMT function, then list each period’s opening balance,…
- Employee Attendance Tracker Excel Template: Setup & TipsAn employee attendance tracker Excel template is a workbook for recording each employee’s scheduled workday and attendance status. In Microsoft Excel for…
- Email Merge from Excel: Steps, Setup, and Safer SendingYes. To send personalized emails from an Excel list, prepare one row per recipient in Excel, then use Word’s Mailings > Start…
- Emergency Light Checklist Template in Excel: What to IncludeYes. An emergency light checklist template in Excel can track each fixture’s location, inspection dates, test results, defects, corrective actions, and next…
- Electronic Inventory Tracking in Excel: Setup and TipsYes. Microsoft Excel for Microsoft 365 can track inventory electronically: create an item list and a dated transaction log, calculate on-hand stock…
- Elton John at Xcel Energy Center: Date and DetailsIf you mean Xcel Energy Center in Saint Paul, Minnesota, Elton John’s Farewell Yellow Brick Road concert there was on Friday, April…
- Elton John Xcel Energy Center Parking: What to KnowFor an Elton John concert at Xcel Energy Center in Saint Paul, plan to use a nearby downtown parking ramp, with the…
- Editing a Group of Sheets in Excel: Steps and LimitsTo edit several worksheets at once in Excel for Microsoft 365 on Windows, select their tabs with Ctrl-click (or select a consecutive…
- Redo in Excel: How to Restore an Undone ActionTo redo an action in Excel for Microsoft 365 on Windows, press Ctrl+Y after you have undone something. You can also click…
- Combine Excel Spreadsheets: Easy Methods for Your DataThe easiest way to combine Excel spreadsheets depends on how many files you have: for a one-time, small job, copy and paste…
- Easiest Way to Superscript in Excel: Quick Steps and ExamplesThe easiest way to superscript text in Excel for Microsoft 365 on Windows is to select the characters inside the cell, press…
- Dynamically Resize an Excel Table as You Add New DataTo make an Excel table grow as you add data, enter or paste new records directly in the row below the table,…
- Dynamic Dependent Dropdowns in Excel: Setup and TipsA dynamic dependent dropdown in Excel changes its available choices based on a selection in another cell. In Microsoft 365 for Windows,…
- Dynamic Name Range in Excel: How to Create OneA dynamic name range in Excel is a named reference that adjusts as the data it points to grows or shrinks. In…
- Dynamic Calendar Excel Template: Build One That UpdatesA dynamic calendar Excel template updates its dates when you change a selected month, instead of requiring you to replace each date…
- Dynamic Checklist in Excel: Build One That UpdatesTo make a dynamic checklist in Excel, put task names and completion checkboxes in an Excel table, then use a spill formula…
- Excel Dependent Dropdowns: How to Create Linked ListsYes. In Excel for Microsoft 365, you can make one dropdown depend on another by using Data Validation lists and named ranges:…