How-to basics
Everyday tasks: sorting, filtering, formatting, printing, shortcuts.
- 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 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 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…