Lesson 2 Part 1.4 Adding TABS to existing worksheet

• Whenever you open a new sheet in excel by default it opens a blank workbook with 3 TABS ( Sheets). In case you want to add more sheets you can do ALT+I+W which will insert a new TAB. Or SHIFT+F11 is also a function for it or right click on TAB and insert
• In case you want to change the default option of 3 TABS in a worksheet then go to TOOLS-->OPTIONS-->GENERAL-->Sheets in new workbook. Change to default setting to how much ever sheets you want.
• To move from one TAB to another rather than using mouse everytime you can use CNTRL+Pageup/Pagedown
• The TAB names are SHEET1 SHEET2 .......by default. To change it right click on the TAB name and rename. Shortcut os ALT+O+H+R
• You can also change the colours of the TAB. This helps to distinguish data very easily. To change the colours right click on the TAB name and TAB colur. Shortcut ALT+O+H+T
• In case you want to create copy a partuclar TAB again you can do that by right click on the TAB. Similarly you can delete TABS as well.
• You can also hide sheets in your workbook. This feature helps especially when you are presenting data and don't want the audience to look at the calculation or dump data. To hide a sheet go to FORMAT+SHEET+HIDE. Make sure the sheet to be hidden should be active as in the cursor should be on that sheet. Similarly you can unde sheets to check your dump FORMAT+SHEET+UNHIDE