Microsoft Excel - Cells - 30 minutes

Move or copy cells and cell contents

• Excel for Office 365 Excel 2019 Excel 2016 Excel 2013 Excel 2010 Excel Starter 2010

Resize a table, column, or row

• Excel for Office 365 Excel 2019 Excel 2016 Excel 2013 Excel 2010
• You can manually adjust the column width or row height or automatically resize columns and rows to fit the data.

Find or replace text and numbers on a worksheet

• Excel for Office 365 Excel 2019 Excel 2016 Excel 2013 Excel 2010 Excel 2007
• Use the Find and Replace features in Excel to search for something in your workbook, such as a particular number or text string.

Merge and unmerge cells

• Excel for Office 365 Excel 2019 Excel 2016 Excel 2013 Excel 2010 Excel Starter 2010
• You can't split an individual cell, but you can make it appear as if a cell has been split by merging the cells above it.

Apply data validation to cells

• Excel for Office 365 Excel for Office 365 for Mac Excel 2019 Excel 2016 More...
• You can use data validation to restrict the type of data or the values that users enter into a cell. 

Import or export text (.txt or .csv) files

• Excel for Office 365 Excel 2019 Excel 2016 Excel 2013 Excel 2010 Excel 2007