Queens College Service Desk

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

Use the Fill Handle Select the cell that contains the first date. Drag the fill handle across the adjacent cells that you want to fill with sequential...

After you create an Excel table in your worksheet, you can easily add or remove table rows and columns. You can use the Resize command in Excel to add row...

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

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

Select the cell(s) you want to create a rule for. Select Data >Data Validation.Data Validation On the Settings tab, under Allow, sel...

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

Conditional formatting provides visual cues to help you quickly make sense of your data. For example, it’ll clearly show highs and lows, or other data trend...

Change the orientation of text in a cell Select a cell, row, column, or a range. Select Home > Orientation , and then select an option. ...

Format cells To change cell formatting without using predefined styles, take these steps.   Select a cell or multiple cells. Multi...