Skip to content
- Excel New Paragraph in Cell: Line Breaks ExplainedTo start a new paragraph inside an Excel cell in Microsoft 365 for Windows, edit the cell, place the cursor where the…How-to basics
- Excel New Line in Cell: Add Line Breaks and Fix ThemTo start a new line inside an Excel cell, edit the cell, place the cursor where the break should go, and press…Errors & fixes
- Excel New Blank Workbook: Create, Save, and Set It UpTo create a new blank workbook in Excel for Microsoft 365 on Windows, press Ctrl+N, or select File > New > Blank…How-to basics
- Excel New Note Shortcut: Add and Edit Notes QuicklyIn Excel for Microsoft 365 on Windows, select a cell and press Shift+F2 to create a new note; if the cell already…How-to basics
- Excel: How Many Complete Months Are Between Two Dates?To find the number of complete months between two dates in Excel, use =DATEDIF(A2,B2,"m"), with the earlier date in A2 and the…How-to basics
- Date Excel Shortcut: Insert Today’s DateIn Excel for Microsoft 365 on Windows, press Ctrl+; (semicolon) to insert today’s date as a fixed value in the selected cell.…How-to basics
- Excel: How Many Days Between Dates? Simple FormulasTo find how many days separate two dates in Excel, subtract the start date from the end date: with the start date…Formulas & functions
- Excel Date Conversion Methods for Text and Serial ValuesTo convert dates in Excel, first determine whether the cells contain real date serial numbers or text: format real dates with Home…How-to basics
- VALUE Excel Cell Reference: Convert Text to NumbersIf A1 contains number-like text such as 42, enter =VALUE(A1) to convert it into the numeric value 42. A cell reference by…How-to basics
- Text in Excel: Translate It Into EnglishYes—Excel for Microsoft 365 can translate text into English with the TRANSLATE function or the Translate command on the Review tab. If…How-to basics
- Search Excel Shortcut Keys: Find Cells, Values, and FormulasIn Excel for Microsoft 365 on Windows, press Ctrl+F, enter the word, number, or phrase you want, then choose Find Next or…Formulas & functions
- Search Excel Cells for Specific Text: Methods and FormulasTo search Excel for specific text, press Ctrl+F on Windows (Command+F on Mac), type the text, and choose Find Next or Find…Formulas & functions
- Find Excel Workbook Links in Microsoft ExcelTo find links to other Excel workbooks in Microsoft 365 for Windows, open Data > Workbook Links if that command is available,…How-to basics
- 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…How-to basics
- 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 basics
- 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…How-to basics
- 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…How-to basics
- Replace an Excel Cell Value: Methods, Formulas, and TipsTo replace a value in one Excel cell, select the cell, type the new value, and press Enter; this overwrites its existing…Formulas & functions
- Excel SUBSTITUTE in VBA: Replace or WorksheetFunctionTo substitute text in Excel VBA, use VBA’s built-in Replace function; it replaces every matching occurrence by default. To replace only a…VBA & macros
- Excel SUBSTITUTE Shortcut: Function and Replace KeysExcel has no dedicated keyboard shortcut for the SUBSTITUTE function. To replace text in cells with a formula, enter =SUBSTITUTE(...); to open…Formulas & functions
- Excel SUBSTITUTE Multiple Values: Formulas and TipsTo substitute multiple values in Excel, nest the SUBSTITUTE function for each old-to-new text pair, or use a replacement list with a…Formulas & functions
- TRIM Excel Not Working? Fix Spaces That TRIM MissesIf TRIM appears not to work in Excel, the text may contain a character that TRIM does not recognize as a regular…Errors & fixes
- 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…How-to basics
- 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…How-to basics
- Excel MID Function: Extract Text From the Middle of TextExcel’s MID function extracts a chosen number of characters from the middle of a text value. With the full text in A2,…Formulas & functions
- 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…How-to basics
- Excel Not Letting You Filter? Fix the Common CausesIf Excel is not letting you filter, first select a cell in the data and choose Data > Sort & Filter >…Errors & fixes
- Excel Freeze Panes Not Working? Fix the SelectionIf Excel is not freezing the rows or columns you selected, click the cell immediately below the rows and to the right…Errors & fixes
- Excel Not Filling Sequential Numbers? Fix the SeriesIf Excel repeats a number instead of counting, enter the first two numbers, select both cells, and drag the fill handle down…Errors & fixes
- VLOOKUP Excel Using Two Spreadsheets: Steps and TipsYes. VLOOKUP can find a value in one Excel workbook and return related information from another; the workbooks do not have to…Formulas & functions