Distribute the contents of a cell into adjacent columns
Select the cell, range, or entire column that contains the text values that you want to split. On the Data tab, in the Data Tools group, click Text to Columns. Follow the instructions in the Convert …
Split text into different columns with the Convert Text to Columns ...
Learn how to take the text in one or more cells, and split it out across multiple cells by using Excel functions. This is called parsing, and is the opposite of concatenate. Watch more in this video.
Insert, move, or delete page breaks in a worksheet
Click the worksheet that you want to print. On the View tab, in the Workbook Views group, click Page Break Preview. You can also click Page Break Preview on the status bar. Do one of the …
Guidelines for organizing and formatting data on a worksheet
Microsoft Office Excel has a number of features that make it easy to manage and analyze data. To take full advantage of these features, it is important that you organize and format data in a …
Dynamic array formulas and spilled array behavior - Microsoft …
Excel formulas that return a set of values, also known as an array, return these values to neighboring cells. This behavior is called spilling. Formulas that can return arrays of variable …
Find or replace text and numbers on a worksheet
Use the Find and Replace features in Excel to search for something in your workbook, such as a particular number or text string. You can either locate the search item for reference, or you can …
How to correct a #REF! error - Microsoft Support
When you use explicit cell references like this (where you reference each cell individually, separated by a comma) and delete a referenced row or column, Excel can’t resolve it, so it …
Enter data in multiple worksheets at the same time
In Excel, you can enter the same data into several worksheets without retyping or copying and pasting the text into each one. For example, you want to put the same title text into all …
Apply data validation to cells - Microsoft Support
Use data validation to restrict the type of data or the values that users enter into a cell, like a dropdown list. Select the cell (s) you want to create a rule for. Select Data >Data Validation. …
Basic tasks in Excel - Microsoft Support
That allows you to add up your data, sort and filter it, put it in tables, and build great-looking charts. Let’s go through the basic steps to get you started. Get started with basic tasks in …
Automate tasks with the Macro Recorder - Microsoft Support
Applies To. To automate a repetitive task, you can record a macro with the Macro Recorder in Microsoft Excel. Imagine you have dates in random formats and you want to apply a single …