The new feature sits in the Excel ‘Data’ tab, which now includes a new feature for transforming cells into these new data types.

Microsoft Excel offers many ways for you to manipulate and organize data, including using multiple "sheets" or tabs within the same spreadsheet file.

Discover two powerful Excel formula methods to unpivot data. Transform cross-tab layouts into analysis-ready formats without Power Query.

If you're starting a new Excel spreadsheet, you have the opportunity to make Excel data horizontal naturally. When entering data, simply press the "Tab" key to move from one cell to the one next ...

If Stock Data Types is not showing or missing in Excel, repairing Microsoft 365, or updating or reinstalling Office. Learn more.

Splitting data into multiple columns isn't the only way to rearrange data in Excel. For example, you could merge data from two columns into one column, split alternate rows into two columns, or ...

Ungrouping Excel tabs helps prevent mistakes and data loss across multiple worksheets.