Microsoft Excel workbooks enable you to organize data easily using a blank workbook or a template.
Create a Blank Microsoft Excel Workbook
1. Open Microsoft Excel
2. Click on Blank workbook/Create blank workbook.
Desktop App:
Microsoft 365 Online:
Create a Microsoft Excel Workbook Using a Template
1. Open Microsoft Excel.
On the Desktop App:
2. Click on More templates, click on a template, then click Create.
3. Click on a template and then click Create.
On Microsoft 365 Online:
2. Scroll through the templates using the over arrow on the right or use the tabs to explore different template categories.
3. Click on the template you want to create.
Enter Data into a Workbook
1. Click into an empty cell.
2. Type in the letters, numbers, or words you wish to add.
Sometime information you enter will reformat in a way different than how the data is meant to be display. if this happens, highlight the cell, row, or column you need to change and then make sure you are on the Home tab. Under the Number section, click the drop-down menu.
Select the format you want to data to appear.
3. Click Enter or Tab to go to the next cell.
To Insert a Column
On the Desktop App:
1. Click on a letter at the top of the workbook and right-click on it.
2. Select Insert and a column will be inserted.
On Microsoft 365 Online:
1. Click on a letter at the top of the workbook and right-click on it.
2. Click on Insert 1 Column Left or Insert 1 Column Right and a column will be inserted.
To Delete a Column
On the Desktop App:
1. Click on a letter at the top of the workbook of the column you wish to delete and right-click on it.
2. Select Delete and that column will be deleted.
On Microsoft 365 Online:
1. Click on a letter at the top of the workbook of the column you wish to delete and right-click on it.
2. Click on Delete Column ... and that column will be deleted.
To Insert a Row
On the Desktop App:
1. Click on a letter at the left side of the workbook and right-click on it.
2. Select Insert and a row will be inserted.
On Microsoft 365 Online:
1. Click on a letter at the left side of the workbook and right-click on it.
2. Click on Insert 1 Row Above or Insert 1 Row Below and a row will be inserted.
To Delete a Row
On the Desktop App:
1. Click on a letter at the left side of the workbook on the row you wish to delete and right-click on it.
2. Select Delete and a row will be deleted.
On Microsoft 365 Online:
1. Click on a letter at the left side of the workbook on the row you wish to delete and right-click on it.
2. Click on Delete Row ... and that row will be deleted.
Copying, Pasting, and Moving Cells
Copying and Pasting Cells on the Desktop App:
1. Highlight the cells you want to copy.
2. In the Excel top navigation bar, be sure to be on the Home tab. Click on the drop-down menu for the Copy icon and click Copy.
3. Highlight the cells that you want to paste them on (be sure to highlight the same amount of cells that you copied).
4. In the Excel top navigation bar, be sure to be on the Home tab. Click on the drop-down menu for the Paste icon and click the Paste icon.
5. Your cells will now appear in the new cells selected.
Copying and Pasting Cells Using Short Cut Keys on the Desktop App:
1. Highlight the cells you want to copy.
2. Press Ctrl (control) + C.
3. Highlight the cells that you want to paste them on (be sure to highlight the same amount of cells that you copied).
4. Press Ctrl (control) + V.
5. Your cells will now appear in the new cells selected.
Copying and Pasting Cells on Microsoft 365 Online:
1. Highlight the cells you want to copy.
2. In the Excel top navigation bar, be sure to be on the Home tab. Click on the Copy icon.
3. Highlight the cells that you want to paste them on (be sure to highlight the same amount of cells that you copied).
4. In the Excel top navigation bar, be sure to be on the Home tab. Click on the drop-down menu for Paste and click Paste.
5. Your cells will now appear in the new cells selected.
Copying and Pasting Cells Using Short Cut Keys on Microsoft 365 Online:
1. Highlight the cells you want to copy.
2. Press Ctrl + C.
3. Highlight the cells that you want to paste them on (be sure to highlight the same amount of cells that you copied).
4. Press Ctrl + V.
5. Your cells will now appear in the new cells selected.
Cutting and Pasting Cells on the Desktop App:
1. Highlight the cells you want to move.
2. In the Excel top navigation bar, be sure to be on the Home tab. Click on the Cut icon (scissors).
3. Highlight the cells that you want to move them to (be sure to highlight the same amount of cells that you cut).
4. In the Excel top navigation bar, be sure to be on the Home tab. Click on the drop-down menu for the Paste icon and click the Paste icon.
5. Your cells will now appear in the new cells selected.
Cutting and Pasting Cells Using the Short Cut Keys on the Desktop App:
1. Highlight the cells you want to move.
2. Press Ctrl (control) + X to cut the data.
3. Highlight the cells that you want to move them to (be sure to highlight the same amount of cells that you cut).
4. Press Ctrl (control) + V to paste the data.
5. Your cells will now appear in the new cells selected.
Cutting and Pasting Cells on Microsoft 365 Online:
1. Highlight the cells you want to move.
2. In the Excel top navigation bar, be sure to be on the Home tab. Click on the Cut icon (scissors).
3. Highlight the cells that you want to paste them on (be sure to highlight the same amount of cells that you copied).
4. In the Excel top navigation bar, be sure to be on the Home tab. Click on the drop-down menu for Paste and click Paste.
5. Your cells will now appear in the new cells selected.
Cutting and Pasting Cells Using Short Cut Keys on Microsoft 365 Online:
1. Highlight the cells you want to move.
2. Press Ctrl (control) + X to cut the data.
3. Highlight the cells that you want to move them to (be sure to highlight the same amount of cells that you cut).
4. Press Ctrl (control) + V to paste the data.
5. Your cells will now appear in the new cells selected.
To learn more information on Microsoft Excel Basics, please visit: Free Excel Tutorial at GCFGlobal.