Queens College Helpdesk

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

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

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 that...

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 that...

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 a f...

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...

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 the...

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 f...

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 fro...

In Excel, you can format numbers in cells for things like currency, percentages, decimals, dates, phone numbers, or social security numbers. Select...