How-to basics
Everyday tasks: sorting, filtering, formatting, printing, shortcuts.
- Excel Suddenly Not Responding? Causes and FixesIf Excel suddenly stops responding, first give it a short time to finish the current task, especially if a workbook is large…
- Excel Spreadsheet Grouping Rows: How to Create and Use ItTo group rows in Excel for Microsoft 365 on Windows, select the detail rows, then choose Data > Outline > Group and…
- Excel Split Cell Into Multiple Cells: Methods That WorkYes. In Excel for Microsoft 365 on Windows, select the cell or column and choose Data > Text to Columns to split…
- Excel Split Names in One Cell Into Two CellsTo split names in Excel, select the name cells and choose Data > Text to Columns > Delimited, select Space, choose an…
- Excel Split One Cell Into Multiple Rows: How It WorksYes. If the text is in A2, enter =TRIM(TEXTSPLIT(A2,,",",TRUE)) in an empty cell to split comma-separated items into a vertical list. This…
- Excel Split Print Area Into Two Pages: Page BreaksYes. In Excel for Microsoft 365 on Windows, select the cells to print and choose Page Layout > Print Area > Set…
- Excel Split Contents of a Cell Into Two CellsYes. In Excel for Microsoft 365 on Windows, select the cell or column and use Data > Text to Columns to split…
- Excel Split Multiline Cell Into RowsYes. In Excel for Microsoft 365, enter =TEXTSPLIT(SUBSTITUTE(A2,CHAR(13),""),,CHAR(10),TRUE) in an empty cell to split the line breaks in A2 into a vertical…
- Excel Split Empty Cells Into Multiple Rows?No—an empty Excel cell contains no values to split into multiple rows. If you mean splitting delimited text, such as red,blue,green, into…
- Excel Split Cell Text Into Separate Cells: A Practical GuideYes. In Excel for Microsoft 365 on Windows, select the cells and choose Data > Text to Columns to split text using…
- Excel Split Cell Value by Delimiter: Methods and TipsTo split a cell at a comma, space, or another delimiter in Microsoft 365 Excel, enter a TEXTSPLIT formula in an empty…
- Excel Split Cells Into Multiple ColumnsTo split text from one Excel cell into separate columns, select the cells and choose Data > Text to Columns, then follow…
- Excel Split Cell Data Into Multiple ColumnsTo split cell data into separate columns in Excel for Microsoft 365 on Windows, select the cells, choose Data > Text to…
- Excel Split Cell Into First and Last Name: A Clear GuideTo split a full name in Excel, select the name cells and use Data > Text to Columns > Delimited, then choose…
- Excel Split Cell Contents by DelimiterTo split cell contents by a delimiter in Excel for Microsoft 365 on Windows, select the cells and choose Data > Text…
- Excel Split Cell by Space Delimiter: Methods and TipsTo split text at spaces in Excel, select the cells and choose Data > Text to Columns > Delimited, then select Space…
- Excel Split Cell Content Into Columns: Methods That WorkTo split cell content into columns in Excel for Microsoft 365 on Windows, select the cells, then choose Data > Text to…
- Excel Split Cell Based on Character: Methods That WorkYes. In Excel for Microsoft 365, you can split a cell at a character such as a comma using Data > Text…
- Excel Split Cell at a Specific Character?To split text at a specific character in Excel for Microsoft 365, use TEXTBEFORE for the part to its left and TEXTAFTER…
- Excel: Specify Which Duplicate to Remove?Yes—but Excel’s Remove Duplicates command does not let you click a particular occurrence to delete. You choose which columns define a duplicate,…
- Excel Solver With Binary Options: Setup and ExamplesYes. Excel Solver can handle binary options by assigning a binary constraint to decision cells, forcing each one to be either 0…
- Excel Solver With Integer Values: Setup and ExamplesYes. In Excel for Microsoft 365 on Windows, open Data > Solver, add an integer constraint to the decision-variable cells, and solve;…
- Excel Solver Tolerance Settings ExplainedIn Excel Solver for Microsoft 365 on Windows, open Data > Solver, choose Solver Parameters > Options, and distinguish Precision from Tolerance:…
- Excel Solver Syntax: Setup, Constraints, and ExamplesExcel Solver does not use a special worksheet formula: you define an objective cell, the cells Solver may change, and any constraints,…
- Excel Solver for Transportation Problems: Setup and TipsYes. Excel Solver can solve a transportation problem by choosing shipment quantities that minimize total shipping cost while meeting supply and demand…
- Excel Solver Simplex LP: When to Use It and How It WorksExcel Solver’s Simplex LP method finds the best value for a linear objective while meeting linear constraints. In Excel for Microsoft 365…
- Excel Solver Slow? Causes and Ways to Speed It UpYes, Excel Solver can be slow, especially when each trial solution forces a large workbook to recalculate or when the model includes…
- Excel Solver Sensitivity Report: How to Read ItAn Excel Solver sensitivity report shows how changes to a linear optimization model’s objective coefficients and constraint limits could affect its solution.…
- Excel Solver Simplex: When to Use It and How It WorksExcel Solver’s Simplex LP method finds the best value for a linear objective while respecting linear constraints. Choose it in the Solver…
- Excel Solver Reports: What They Show and How to Read ThemExcel Solver does not include a standard report called an Outline report. After Solver finds a solution, it can create an Answer…