Insert or delete rows and columns - Microsoft Support
To insert a single column: Right-click the whole column to the right of where you want to add the new column, and then select Insert Columns. To insert multiple columns: Select the same …
Split data into multiple columns - Microsoft Support
Power Query splits the Sales Rep names into two different columns named "Sales Rep 1" and "Sales Rep 2". To change the default names, rename them to "Sales Rep First" and "Sales …
Create a column from an example - Microsoft Support
Select the Order Date column, add a new column, enter "Day", and then select Monday from the list. Power Query fills the column with day names and renames the column "Day Name".
Present your data in a column chart - Microsoft Support
To create a column chart: Enter data in a spreadsheet. Select the data. On the Insert tab, select Insert Column or Bar Chart and choose a column chart option. You can optionally format the …
Use calculated columns in an Excel table - Microsoft Support
Calculated columns in Excel tables are a fantastic tool for entering formulas efficiently. They allow you to enter a single formula in one cell, and then that formula will automatically expand to the …
Filter data in a range or table in Excel - Microsoft Support
Use AutoFilter or built-in comparison operators like "greater than" and "top 10" in Excel to show the data you want and hide the rest. Once you filter data in a range of cells or table, you can …
Create and format tables - Microsoft Support
Learn about the many ways to create a table in an Excel worksheet, and how to clear data, formatting, or table functionality from a table in Excel. Discover more in this video.
Create a drop-down list - Microsoft Support
Ideally, you'll have your list items in an Excel table. If you don't, then you can quickly convert your list to a table by selecting any cell in the range, and pressing Ctrl+T.
Split text into different columns with the Convert Text to Columns ...
Take text in one or more cells and split it into multiple cells using the Convert Text to Columns Wizard.
Resize a table by adding or removing rows and columns in Excel
To insert a column, pick any cell in the table and right-click. In the example shown below for rows, a row will be inserted above row 3. For columns, if you have a cell selected in the table's …