Queens College Service Desk

Create a workbook Open Excel. Select Blank workbook. Enter data To manually enter data: Select an empty cell, such as A1, a...

Insert a worksheet Select the New Sheet plus icon at the bottom of the workbook.New Sheet Or, select Home > Insert > Insert Shee...

You can move or copy a worksheet in the same workbook to organize your workbook exactly how you want. Move a worksheet within a workbook 1. Clic...

You can print entire or partial worksheets and workbooks, either one at a time or several at once. Also, if the data that you want to print is in a Microsof...

Use the Auto Fill feature to fill cells with data that follows a pattern or are based on data in other cells. Select one or more cells you want to...

Insert or delete a column Select any cell within the column, then go to Home > Insert > Insert Sheet Columns or Delete Sheet Columns....

Select one or more cells To select a range, select a cell, then with the left mouse button pressed, drag over the other cells. Or use the Shift +...

Freeze rows or columns Freeze Panes freezes the rows above and the columns left of the selected cell. Freeze the first two columns Select the th...

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

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