DATABASE FUNDAMENTALS
HOW TO MODIFY THE WORKSHEET TAB IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
Right-click the worksheet name and select Rename
|
|
|
go to File, select Info, and change the Title property
|
|
|
Type the name of the worksheet in cell A1 and add the Title style to the cell
|
|
|
Enter the name of the worksheet in the Name Box
|
Detailed explanation-1: -On the Sheet tab bar, right-click the sheet tab that you want to rename, and then click Rename Sheet. Select the current name, and then type the new name. Tip: You can include the name of the sheet when you print the worksheet. On the Insert tab, in the Text group, click Header & Footer.
Detailed explanation-2: -Renaming sheets in Excel one can do from the taskbar below the worksheets by double-clicking on them. But in VBA, we use the Sheets or Worksheet property method to rename the sheet. The syntax to rename a sheet is as follows: Sheets(“Old Sheet Name”). Name = “New Sheet name.”
Detailed explanation-3: -These names (Sheet1, Sheet2, Sheet3, and so on) are not very descriptive; you might want to rename your worksheets to reflect what they contain. For instance, if your workbook contains your annual budget, each worksheet within the workbook might contain budgets for individual months.
Detailed explanation-4: -Simply hold down the Ctrl key and press either the Page Up or Page Down key to move to the previous or next sheet, respectively. You can also use the Ctrl + Arrow keys to move between sheets. Another great shortcut for quickly changing sheets in Excel is Ctrl + Tab.