Skip to content
- Excel Filter and Sort by Color: Steps, Options, and TipsIn Excel for Microsoft 365 on Windows, use the filter arrow in a column and choose Filter by Color to show rows…Formulas & functions
- Excel Filter by Color and Value: How It WorksYes. In Excel for Microsoft 365 on Windows, open a column’s filter menu and choose a color under Filter by Color; to…Formulas & functions
- How to Freeze Panes in Excel Without Freezing the First RowTo freeze rows or columns other than the first row in Excel for Microsoft 365 on Windows, select the cell immediately below…How-to basics
- Freeze Multiple Rows in Excel: Step-by-Step GuideTo freeze multiple rows in Excel, select the cell in column A directly below the last row you want to keep visible,…How-to basics
- Freeze Multiple Columns in Excel: A Step-by-Step GuideTo freeze multiple columns in Excel for Microsoft 365 on Windows, select the cell immediately to the right of the last column…How-to basics
- How to Freeze Panes in Excel: Keep Rows and Columns VisibleTo keep headings or identifying columns visible while you scroll in Excel for Microsoft 365 on Windows, select the cell immediately below…How-to basics
- Merge Cells in Excel Without Merging: Center AcrossTo make a heading look centered across several Excel columns without combining the cells, select the range, open Format Cells, and choose…How-to basics
- How to Merge Cells in Excel Without Losing Your DataTo merge cells in Excel without losing their contents, first combine the values you need into the top-left cell or a separate…How-to basics
- Merge Cells in Excel: Keyboard Shortcuts and StepsIn Excel for Microsoft 365 on Windows, select the cells and press Alt+H, M, C—one key sequence at a time—to merge them…How-to basics
- How to Merge Cells in Excel and Keep All TextTo merge cells in Excel and keep all their text, first join the contents with a formula such as =TEXTJOIN(" ",TRUE,A2:C2), paste…How-to basics
- Merge Cells in Excel and Keep All DataTo merge cells in Excel without losing their contents, first combine the contents into one cell, then merge the range. Excel’s Merge…How-to basics
- Merge 2 Cells in Excel: A Step-by-Step GuideTo merge two cells in Excel, select the adjacent cells, then choose Home > Merge & Center ▼ > Merge Cells. This…How-to basics
- Split a Cell in Excel: Columns, Formulas, and LimitsTo split text from one Excel cell into separate columns, select the column, then choose Data > Text to Columns and follow…Formulas & functions
- Split Names in Excel: Text to Columns and FormulasTo split names into separate Excel cells, select the name column and choose Data > Text to Columns > Delimited, then select…Formulas & functions
- How to Split Cell Data in Excel: Text to Columns & FormulasTo split cell data in Excel, select the cells, choose Data > Text to Columns, pick Delimited or Fixed width, set the…Formulas & functions
- Combine Cells in Excel Without Merging: Formulas and StepsTo combine the contents of cells without merging them, put the result in a separate cell with a formula. With a first…Formulas & functions
- Combine Cells in Excel With Dates Without Losing FormatTo combine a date with text without displaying its underlying serial number, use a formula that applies TEXT to the date first.…How-to basics
- Combine Cells in Excel With a Dash Between Text ValuesTo combine two cells in Excel with a dash between them, place the values in A2 and B2, then enter =A2&"-"&B2 in…How-to basics
- Combine Cells in Excel: Shortcut and Safe StepsTo merge selected cells in Excel for Microsoft 365 on Windows, select the range and press Alt, H, M, M one key…How-to basics
- Combine Cells in Excel on a New Line with CHAR(10)To combine values from A2 and B2 in one cell with a line break between them, enter =A2&CHAR(10)&B2 in another cell, then…How-to basics
- Combine Cells in Excel for Mailing AddressesTo combine address parts into one cell, put the street in A2, city in B2, state in C2, and ZIP code in…How-to basics
- How to Combine Cells in Excel Into One Cell EasilyTo combine the contents of Excel cells into a new cell, join them with the ampersand operator (&) or use TEXTJOIN; to…How-to basics
- Combine Cells in Excel for Names: Formulas and StepsTo combine a first name in A2 and a last name in B2, enter =A2&" "&B2 in C2 and press Enter; it…Formulas & functions
- How to Combine Cells in Excel and Keep All ValuesTo keep every entry, combine the cell contents into a result first, copy that result, and use Paste Values before removing or…How-to basics
- How to Combine Cells in Excel and Keep TextTo combine the text from cells without losing anything, enter a formula such as =A2&" "&B2 in an empty cell; it joins…How-to basics
- How to Combine Cells in Excel and Keep All Your DataWith “Ada” in A2 and “Lovelace” in B2, enter =A2&" "&B2 in C2 and fill it down to combine the contents with…How-to basics
- Remove Duplicates in Excel: Shortcut Keys and StepsTo remove duplicate rows in Excel for Microsoft 365 on Windows, select a cell in your data and press Alt, then A,…How-to basics
- Remove Duplicates in Excel: A Practical Step-by-Step GuideTo remove duplicate rows in Excel for Microsoft 365 on Windows, select your data, choose Data > Remove Duplicates, select the columns…How-to basics
- Remove Duplicates in Excel Filter: A Step-by-Step GuideTo remove duplicate rows in Excel for Microsoft 365 on Windows, select a cell in your data, choose Data > Remove Duplicates,…Formulas & functions
- Clear Excel Shortcut: Contents, Formats, and CellsTo clear the contents of selected Excel cells on Windows, select them and press Delete. This removes values and formulas but keeps…How-to basics