Microsoft Excel workbooks enable you to organize date easily using a blank workbook or a template.
Create a Blank Microsoft Excel Workbook
1. Open Microsoft Excel
2. Click on 'Blank workbook'.
Create a Microsoft Excel Workbook Using a Template
1. Open Microsoft Excel
2. Click on 'More templates'.
On the Desktop App
Click on 'More templates', click on a template, then click 'Create'.
On Microsoft 365 Online
Click on 'More templates' and then just click on the template.
Enter Data into a Workbook
1. Click into an empty cell.
2. Type in the letters, numbers, or words you wish to add.
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. Hover over 'Insert' and when a new menu appears, click on 'Sheet Columns' 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. Hover over 'Delete' and when a new menu appears, click on 'Sheet Columns' 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. Hover over 'Insert' and when a new menu appears, click on 'Sheet Rows' 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. Hover over 'Delete' and when a new menu appears, click on 'Sheet Rows' 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, click on 'Edit' and click on '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, click on 'Edit' and click on 'Paste'.
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 on a PC or press Cmd (command) + C on a Mac.
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 on a PC or press Cmd (command) + V on a Mac.
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, click on the clipboard icon 
and select '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, click on the clipboard icon 
and select '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. Click on the clipboard icon in the top navigation
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 on a PC or press Cmd (command) + V on a Mac.
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, click on 'Edit' and click on 'Cut'.
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, click on 'Edit' and click on 'Paste'.
5. Your cells will now appear in the new cells selected.
Cutting and Pasting Cells Using Short Cut Keys On the Desktop App
1. Highlight the cells you want to move.
2. Press Ctrl (control) + X on a PC or press Cmd (command) + X on a Mac.
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 on a PC or press Cmd (command) + V on a Mac.
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, click on the clipboard icon 
and select 'Cut'.
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, click on the clipboard icon 
and select 'Paste'.
5. Your cells will now appear in the new cells selected.
Copying Cells Using Short Cut Keys On Microsoft 365 Online
1. Highlight the cells you want to move.
2. Press Ctrl (control) + X on a PC or press Cmd (command) + X on a Mac.
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 on a PC or press Cmd (command) + V on a Mac.
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.