DATABASE FUNDAMENTALS
HOW TO MODIFY THE WORKSHEET TAB IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
Renaming the Worksheet
|
|
|
Coloring the Worksheet Tab
|
|
|
Moving the Worksheet
|
|
|
Copying the Worksheet
|
Detailed explanation-1: -Regardless of the method you choose to rename a worksheet, Excel highlights the name on the worksheet tab and allows you to type a new name. To enter a new name, just start typing. When you press Enter or click anywhere else on the screen, the worksheet tab is renamed.
Detailed explanation-2: -You can give appropriate names to the existing worksheets by renaming a worksheet. This helps in relating the content of the worksheet with its name. For example, if we want to know which sheet has the view to know the segment wise profit then with a proper name of the sheet we can identify it.
Detailed explanation-3: -Double-click the sheet name on the Sheet tab to quickly rename it. Or, right-click on the Sheet tab, click Rename, and type a new name.
Detailed explanation-4: -You can make a reference to cells on two different worksheets by placing a colon between the two sheet names. For example, Sheet1:Sheet2! A1 refers to two cells: cell A1 in Sheet1 and cell A1 in Sheet2.