Samudranesia.id – Among the various basic concepts in Excel, the definition of a worksheet is one of the earliest to learn. The reason is, you will find this worksheet immediately as soon as you open the Microsoft Excel application on the device you use for work.
Worksheets are an important component that must be understood to make it easier for you to use Excel. The worksheet also has important sections that you will often use in your daily work. Each of these parts has its own function.
In addition to learning the functions of the worksheet, you also need to know what activities you can do using this worksheet. By knowing the steps you can do these activities easily and quickly.
Getting to Know Worksheets in Excel
To make it easier to understand what a worksheet is and use it properly, here are some important things you should know about worksheets.
1. Understanding Worksheets
Worksheet refers to the page view in Excel in the form of a worksheet for typing numbers and letters. A worksheet is made up of small boxes called cells that make up rows and columns. A worksheet is part of a workbook because it only consists of one worksheet.
Workbook itself is an Excel workbook consisting of several worksheets. This workbook can include various worksheets with different titles, but still on the same theme or topic. Excel files that are saved with the .xls extension are called workbooks.
2. How to Use Worksheets
After understanding what a worksheet is, then the next thing you need to know is how to use the existing worksheets in Excel.
- First, select the sheet that you will use. by defaulta worksheet in Excel consists of three sheets, namely sheet1, sheet2, and sheet3.
- Place the cursor in the cell where you want to start work. Type something into the cell, for example by naming each range in the table. Type the word or number in the cell until you’re done.
- If you want to type something in the cell below it, you just have to press the Enter key on the keyboard or you can also click on the cell with the mouse. Meanwhile, to move to the cell next to it, you can press the right or left arrow keys on the keyboard.
3. How to Add a Worksheet
Adding a worksheet can be done in two ways, namely by using the mouse or using a shortcut. To add a new worksheet using the mouse, you just need to click on the + sign to the right of the sheet row at the bottom of the worksheet.
After that, a new sheet will appear and you can name it or use it right away. Meanwhile, to add a worksheet with a shortcut, you simply press the Shift + F11 keys simultaneously to bring up a new worksheet.
4. How to Choose a Worksheet
If you are working with several worksheets in one workbook, then you need to select a specific worksheet to work on first. The easiest way to select a worksheet is to use the mouse.
Just click on the sheet that you want to use and you will be immediately directed to the worksheet in that sheet. If you want to use a shortcut, press Ctrl + pageup to move the active worksheet to the left or Ctrl + pagedown to select the worksheet to the right.
Selecting a worksheet with a shortcut is indeed longer because it cannot immediately move to the desired worksheet. For example, if you want to move from Sheet1 to Sheet 3, then you have to go through Sheet2 first.
5. How to Change the Worksheet Name
In addition to understanding the meaning of a worksheet, you also need to know how to rename a worksheet. You can rename a worksheet with the mouse or a shortcut. To rename a worksheet with the mouse, right-click on the sheet you want to rename.
Then, select the option Rename in the dialog box that appears on the screen. Type the name you want on the sheet, then press Enter. The sheet name will change according to what you typed. If using a shortcut, you need to press the / + H + 0 + R keys at the same time.
After that, type the name of the worksheet you want and press Enter to complete the command.
6. How to Copy a Worksheet
Copying a worksheet can be done on the same or different workbooks. To copy a worksheet to a workbook, right-click on the sheet to be duplicated first. Then, select an option Move or Copy in the on-screen dialog box.
You will be directed to the next dialog box to choose which sheet to duplicate. After selecting the sheet, put a check mark on Create a Copy. The results of the coffee will usually be placed before the sheet being copied. If you want to put at the end, select the option move to end and end by clicking OK.
To copy a worksheet in another workbook, the steps are not much different. However, in the dialog box Move or Copythe difference is in the options move selected sheets to book. If previously the destination was sheet, here the choice is book.
To copy a worksheet to another workbook, select a book other than the active one. You can also choose options new book to copy the worksheet into a new workbook. End the command in the dialog box by clicking the OK button.
7. How to Move Worksheets
The steps for moving a worksheet are almost the same as for copying a worksheet. The difference is that you don’t need to tick the option Create a Copy. This method of moving worksheets can be used in either the same or different workbooks.
To move a worksheet to a different workbook you only need to change the options in the section Move selected sheet to book.
8. How to Delete a Worksheet
Deleting a worksheet can be done easily with the mouse. Right click on the sheet to be deleted and select options Delete in the dialog box that appears. If the worksheet is empty, it will automatically be deleted immediately. However, if it contains data then a delete confirmation dialog box will appear.
If you are really sure to delete it, you can click on the button Delete. You can also delete a worksheet with a shortcut. Just press the / + H + D + S keys simultaneously to bring up the delete dialog box. If you are sure press Enter to delete the worksheet.
9. How to Hide Worksheets
To hide, right click on a specific sheet and select Hide in the dialog box that appears. After that, the worksheet will not be visible. To bring it back, right-click on any sheet, then select options Unhide on the dialog box.
There will be displayed the names of the sheets that you can display. Select a sheet that you want to return to the active worksheet, then click OK to end the command.
To be able to do various activities in Excel easily, you not only need to know the meaning of a worksheet, but also how to use and operate it for various needs.
