How-to basics
Everyday tasks: sorting, filtering, formatting, printing, shortcuts.
- Excel Named Ranges in Data Validation: How to Use ThemYes. In Excel for Microsoft 365 on Windows, create a named range for the cells that contain your choices, then set the…
- Excel Unable to Remove Duplicates? Common Causes and FixesIf Excel cannot remove duplicates, select a cell in the complete data range, choose Data > Remove Duplicates, confirm the columns that…
- Excel Text to Columns: How to Undo and Restore DataTo undo Text to Columns in Excel for Microsoft 365 on Windows, press Ctrl+Z immediately after running it; on a Mac, press…
- Excel Pasting: Stop Tab-Delimited Text Splitting on PasteExcel has no global switch that turns off column splitting when you paste tab-delimited text. For a small amount of text, edit…
- Excel Unable to Merge Cells? Causes, Fixes, and AlternativesIf Excel is unable to merge cells, first check that you selected one continuous range, the cells are not inside an Excel…
- Excel Text to Columns Wizard: Split Data EasilyExcel’s Text to Columns wizard splits the contents of one column into separate columns. In Microsoft Excel for Microsoft 365 on Windows,…
- Excel Text to Columns: Split Data Cleanly and SafelyTo transform text into separate columns in Excel for Microsoft 365 on Windows, select the cells, choose Data > Text to Columns,…
- Excel Text to Columns: Why Leading Zeros DisappearYes. Excel’s Text to Columns can remove leading zeros when a column is set to General, because Excel interprets digit-only entries such…
- Excel Text to Columns: What the Text Qualifier DoesIn Excel for Microsoft 365 on Windows, the Text qualifier in Data > Text to Columns tells Excel which character can enclose…
- Excel Text to Columns: Split at the First DelimiterNo: Excel’s Text to Columns wizard splits at every occurrence of the delimiter you select; it has no setting to split only…
- Excel Text to Columns: Use a Line Break DelimiterTo split a cell at each embedded line break in Excel for Microsoft 365 on Windows, select the cells, choose Data >…
- Excel Text to Columns: Split at the Last SpaceNo—Excel’s Text to Columns command cannot split at the last space only; when you choose space as a delimiter, it splits at…
- Excel Text to Columns: Split at Line BreaksTo split text at line breaks in Excel for Microsoft 365 on Windows, select the cells, choose Data > Text to Columns,…
- Excel Text to Columns Greyed Out? Causes and FixesIf Text to Columns is greyed out in Excel for Microsoft 365 on Windows, first select a cell in the worksheet and…
- Excel Text to Columns: How to Split DataIn Excel for Microsoft 365 on Windows, select the cells you want to split, then choose Data > Text to Columns and…
- Excel Text to Columns: How to Enter a DelimiterIn Excel for Microsoft 365 on Windows, go to Data > Text to Columns, choose Delimited, and click Next. Select a listed…
- Excel Text to Columns: Can It Split Capital Letters?No: Excel’s Text to Columns command cannot automatically split a cell wherever a capital letter appears. It splits text at a delimiter…
- Excel Text to Columns: Split a Cell at Line BreaksTo split text at an in-cell line break in Excel for Microsoft 365 on Windows, select the cells and choose Data >…
- Excel Text to Columns: How to Split Data Into FieldsIn Excel for Microsoft 365 on Windows, select the cells you want to split, then choose Data > Text to Columns. In…
- Excel Text to Columns: Split Cell Text at Line BreaksTo split cell text wherever it contains an in-cell return, use Data > Text to Columns, choose Delimited, select Other, then press…
- Excel Text to Columns: Find It and Split Data CorrectlyIn Microsoft Excel for Microsoft 365 on Windows, find the Text to Columns button on the Data tab, in the Data Tools…
- Excel Text to Columns: Advanced Options and UsesYes—Excel’s Text to Columns tool has advanced controls for choosing delimiters or fixed-width breaks, handling quoted text, setting each output column’s data…
- Excel Text to Columns: Split Alt+Enter Line BreaksTo split text entered with Alt+Enter in Excel, use Data > Text to Columns, choose Delimited, select Other, and press Ctrl+J in…
- Excel Text to Columns and Rows: How to Split DataIn Excel, use Data > Text to Columns to split one cell into several columns, choosing a delimiter such as a comma…
- Excel Text to Columns: How to Make Results VerticalExcel’s Text to Columns feature splits text across columns, not down rows. To make the split results vertical, split the text first…
- Excel Table Structured References: Rules, Examples & TipsAn Excel table structured reference uses the table name and a bracketed column or row specifier. Assuming a table named Sales has…
- Excel Take Data From a Table: Methods and ExamplesYes. Excel can take data from a table by referencing its columns in a formula, filtering or looking up matching rows, summarizing…
- Excel Table Data Filtering: How to Narrow RowsTo filter an Excel table in Microsoft 365 for Windows, click a dropdown arrow in its header row, select or search for…
- Excel Table Data Sorting: Steps, Options, and FixesTo sort data in an Excel table, click a cell in the column you want to sort, then choose Data > Sort…
- Excel Spreadsheet Not Responding? Causes and FixesIf an Excel spreadsheet is not responding, first stop clicking and give it a few minutes: a large calculation, refresh, or save…