Click on the cell or navigate to the cell using your keyboard’s arrow key

To finish editing:

• Click outside of the cell or

• Use the ‘Tab' key on your keyboard or

• Use the ‘Return/Enter’ key on your keyboard

Double click on the cell to select a specific position for your cursor

OR

Click on the cell or navigate to the cell and click on the text in the formula bar

To finish editing:

• Click outside of the cell

• Use the ‘Tab' key on your keyboard

• Use the ‘Return/Enter’ key on your keyboard

With your mouse, click on the first cell in the group to highlight and drag to cover all applicable cells

Right click to view a menu of options, or use keyboard shortcuts to copy, paste, or format the data.

1. Click on the cell to copy

2. Right click and select ‘Copy’ or use the Ctrl + C shortcut on your keyboard (Cmd + C for Mac Users)

3. Click on the cell to paste the data into

4. Right click and select ‘Paste’ or use the Ctrl + V shortcut on your keyboard (Cmd + V for Mac Users)

To reset the copied cells, use the Esc key on your keyboard

1. Click and highlight the cells to copy

2. Right click and select ‘Copy’ or use the Ctrl + C shortcut on your keyboard (Cmd + C for Mac Users)

3. Click on the empty area to paste the data into

4. Right click and select ‘Paste’ or use the Ctrl + V shortcut on your keyboard (Cmd + V for Mac Users)

To reset the copied cells, use the Esc key on your keyboard

1. Click on the column to copy

2. Right click and select ‘Copy’ or use the Ctrl + C shortcut on your keyboard (Cmd + C for Mac Users)

3. Click on the column to paste the data into

4. Right click and select ‘Paste’ or use the Ctrl + V shortcut on your keyboard (Cmd + V for Mac Users)

To reset the copied cells, use the Esc key on your keyboard

1. Click on the row to copy

2. Right click and select ‘Copy’ or use the Ctrl + C shortcut on your keyboard (Cmd + C for Mac Users)

3. Click on the row to paste the data into

4. Right click and select ‘Paste’ or use the Ctrl + V shortcut on your keyboard (Cmd + V for Mac Users)

To reset the copied cells, use the Esc key on your keyboard

1. Hover over the tab you would like to duplicate

2. Right click

3. Select Move or Copy…

4. Select where in the workbook you would like to place the tab/sheet

5. Select Create a copy

6. Select OK

• Right click the tab you would like to rename

• Select Rename

• Enter the name for the new sheet

• Click anywhere in the sheet or select Return on your keyboard

• Tab Names cannot include special characters such as " / \ : ? * "

• Tab Names have a character limit of 31

1. Select the cell you would like to duplicate

2. Hover your cursor over the small square in the bottom right corner of the cell

3. Click, hold, and drag down over the cells you want to fill with the text

4. Release the mouse over the last cell

5. Click anywhere in the worksheet to exit

• This process also works for autofilling horizontally across a sheet

1. Establish a sequence of numbers (or text) with at least 2 unique cells

2. Highlight all cells in the sequence

3. Hover your cursor over the small square in the bottom right corner of the last cell in the sequence

4. Click, hold, and drag down over the cells you want to fill with the sequence

5. Release the mouse over the last cell

6. Click anywhere in the worksheet to exit

7. This process also works for autofilling horizontally across a sheet

• NOTE: To create a repetitive pattern of numbers rather than continuation of numbering, establish a sequence with 2 instances of the pattern:

  • Cell A1: 1

  • Cell A2: 2

  • Cell A3: 1

  • Cell A4: 2

1. Select the cell with the number/date you would like to duplicate

2. Hover your cursor over the small square in the bottom right corner of the cell

3. Click, hold, and drag down over the cells you want to fill with the number

4. Release the mouse over the last cell

5. Click anywhere in the worksheet to exit

• This process also works for autofilling horizontally across a sheet

If the cell you are editing contains text longer than the size of the cell, you can wrap the text to show on multiple lines.

1. Select the cell to wrap

2. In the Home ribbon at the top of the page, select Wrap Text

1. Highlight the column to the right of where you would like to insert a new column

2. Right click

3. Select Insert

1. Highlight the row below where you would like to insert a new column

2. Right click

3. Select Insert

1. At the top of the sheet, hover over the line on the right side of the column

2. Click, hold, and drag the column to the desired width

OR

To expand based on the greatest length of text in the column:

1. At the top of the sheet, hover over the line on the right side of the column

2. Double click on the line. It will auto-size to the greatest length of text

1. On the left side of the sheet, hover over the line on the bottom of the row

2. Click, hold, and drag the column to the desired height

OR

To expand based on the largest paragraph of text in the column (only if text is wrapped):

1. At the top of the sheet, hover over the line on the bottom of the row

2. Double click on the line. It will auto-size to the largest paragraph of text in the row