Learn Excel - Chapter 2
Workbook / Worksheet
Workbook :A workbook is another word for Excel file. When you start Excel, click Blank Workbook to create an Excel workbook or file. The Shortcut Command to create a new file in Excel is CTRL + N. For more Excel Shortcut Commands click Excel Shortcuts
Worksheet :A worksheet is a collection of cells where we keep and manipulate the data. Each Excel workbook can contain multiple worksheets.
Selecting A WorksheetA Excel Workbook by default has three Worksheet. When you open an Excel workbook, Excel automatically selects Sheet1 for you. The name of the worksheet appears on its Sheet Tab at the bottom of the document window.
How to Insert Worksheet in ExcelWe can insert additional worksheets whenever we require. To quickly insert a new worksheet, click the plus sign at the bottom of the document window.
Renaming A WorksheetTo give a worksheet a more specific name, do the following steps.
1. Right click on the sheet tab of Sheet1.
2. Choose Rename Command
3. For example, type January 2020.
How To Move A Worksheet in ExcelTo move a worksheet, click on the sheet tab of the worksheet you want to move and drag it into the new position.
1. For example, click on the sheet tab of Sheet2 and drag it before January 2020.
Deleting A WorksheetTo delete a worksheet, right click on a sheet tab and choose Delete.
For example, to delete Sheet2.
How To Copy A Worksheet in ExcelSometimes you need to make an identical worksheet having the same Heading and Table format. To quickly create a duplicate worksheet, we use the Move or Copy command. It's a lot easier to copy the entire worksheet and only change the numbers.
1. Right click on the sheet tab of January 2020.
2. Choose Move or Copy Command
The Move or Copy dialog box appears.
3. Select (move to end) and check Create a copy check box.
4. Click OK.
Learn Advanced Excel Whatapp/Call 8422000829. Disount Code WEBSAB501
Home Chapter 1 Chapter 3 Chapter 4 Chapter 5 Chapter 6 Chapter 7 Chapter 8 Chapter 9 Chapter 10 Excel Shortcuts