Medgar Evers College of CUNY

Hide columns Select one or more columns, and then press Ctrl to select additional columns that aren't adjacent. Right-click the selected c...

In Excel, there are several ways to filter for unique values—or remove duplicate values: To filter for unique values, click Data > Sort & Filte...

You can take the text in one or more cells, and split it into multiple cells using the Convert Text to Columns Wizard. Select the cell or column tha...

You can quickly create a list of dates, in sequential order, by using the Fill Handle  or the Fill command. Use the Fill Handle Select the cell th...

Use Cut, Copy, and Paste to move or copy cell contents. Or copy specific contents or attributes from the cells. For example, copy the resulting value of...

You can manually adjust the column width or row height or automatically resize columns and rows to fit the data. Note: The boundary is the line between ce...

Use the Find and Replace features in Excel to search for something in your workbook, such as a particular number or text string. On the Home tab, in...

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. Merge cells Select t...

Download our examples Download an example workbook with all data validation examples in this article Select the cell(s) you want to create a rule fo...

There are two ways to import data from a text file with Excel: you can open it in Excel, or you can import it as an external data range. To export data fr...