Microsoft Excel - Rows & columns - 30 minutes

Insert or delete cells, rows, and columns

• Excel for Office 365 Excel 2019 Excel 2016 Excel 2013 Excel 2010 Excel 2007
• Insert and delete rows, columns, and cells to organize your worksheet better.

Select cell contents in Excel

• Excel for Office 365 Excel for Office 365 for Mac Excel 2019 Excel 2016
• In Excel, you can select cell contents of one or more cells, rows and columns.

Freeze panes to lock rows and columns

• Excel for Office 365 Excel 2019 Excel 2016 Excel 2013 Excel 2010 Excel 2007 Excel Online
• To keep an area of a worksheet visible while you scroll to another area of the worksheet

Hide or show rows or columns

• Excel for Office 365 Excel for Office 365 for Mac Excel 2019 Excel 2016
• Hide or unhide columns in your spreadsheet to show just the data that you need to see or print.

Filter for unique values or remove duplicate values

• Excel for Office 365 Excel 2019 Excel 2016 Excel 2013 Excel 2010 Excel 2007
• In Excel, there are several ways to filter for unique values—or remove duplicate values

Split text into different columns with the Convert Text to Columns Wizard

• Excel for Office 365 Excel 2019 Excel 2016 Excel 2013 Excel 2010 Excel 2007
• You can take the text in one or more cells, and split it into multiple cells using the Convert Text to Columns Wizard.

Create a list of sequential dates

• Excel for Office 365 Excel for Office 365 for Mac Excel 2019 Excel 2016 More...
• You can quickly create a list of dates, in sequential order, by using the Fill Handle  Fill handle or the Fill command.