How-to basics
Everyday tasks: sorting, filtering, formatting, printing, shortcuts.
- Find an Excel Password in a Protected File? Safe OptionsYou usually cannot find or reveal a password from inside a protected Excel file: Excel does not display a forgotten password. If…
- Find Excel Spreadsheet Not Saved? Recovery Steps That WorkIf you closed an Excel workbook without saving, open Excel and select File > Info > Manage Workbook > Recover Unsaved Workbooks,…
- How to Find Excel Spreadsheets on Your ComputerOn Windows, open File Explorer with Windows key + E, select This PC, and search for *.xlsx to find Excel workbooks across…
- Excel Replace Shortcut: Use Ctrl+H and Find & ReplaceIn Excel for Microsoft 365 on Windows, press Ctrl+H to open Find and Replace on the Replace tab. Enter the text to…
- Excel Middle Align Shortcut: Center Text VerticallyIn Excel for Microsoft 365 on Windows, select the cell or cells and press Alt, H, A, then M to apply Middle…
- Excel: Calculate the Length of Time Between Two DatesTo find the elapsed number of days between two dates in Excel, subtract the earlier date from the later one: with the…
- Excel Not Letting You Copy and Paste? Fixes That WorkIf Excel will not copy and paste, first press Esc, select one ordinary cell, copy it with Ctrl+C, then select a blank…
- Excel Not Clicking the Correct Cell? Causes and FixesIf Excel is not clicking the correct cell, first press Esc, set the worksheet zoom to 100%, and click a clearly visible…
- Excel Copy and Paste Rows Into Columns: 3 Easy MethodsTo copy a row into a column in Excel for Microsoft 365 on Windows, select the row cells, press Ctrl+C, click a…
- Excel Not Responding: Should You Wait or Close It?Usually, wait briefly before closing Excel: the Not Responding message means Windows is not receiving a response from the app, but Excel…
- How to Split First and Last Name in ExcelSplit first and last names in Excel with Text to Columns, formulas, or Flash Fill. Handle extra spaces and middle names with…
- How to Freeze Top Row and First Column in ExcelFreeze the top row and first column together in Excel with Freeze Panes, plus fixes for common issues and tips so labels…
- Excel conditional formatting based on another cell?Learn Excel conditional formatting from another cell with formula rules, reference examples, and fixes for common problems, so your highlights stay useful.
- How to Calculate Age in Excel from Date of BirthCalculate age in Excel with DATEDIF, handle blank or invalid dates, and format results correctly. Follow the steps for a reliable age…