Worksheets

Renaming, Formatting, Inserting Worksheets in Excel 2007
When you start Excel you will observe that your Excel workbook contains three sheets named Sheet1, Sheet2 and sheet3. Also you will see a sign of another sheet with no name. If you move your mouse cursor over this sheet like item you will see a tooltip ‘insert worksheet (shift+F11) ‘ . The latter only implies that instead of using the mouse you can press the ‘shift’ and the ‘F11’ keys together from the keyboard to insert another worksheet. Now let’s say you wish to do some accounting work in Excel for your business; maybe just see quickly what is the ‘profit/loss’ situation. You can rename the first sheet to ‘income’, the second sheet to ‘expense’ and the third sheet to ‘profit-loss’. This makes your data more manageable due to the renaming and formatting using different backgrounds. Since the individual data is in separate sheet tabs you can add or delete data without disturbing the other important data. You can now add more worksheets or delete the ones you don’t need by right-clicking on the ‘unnamed’ sheet and selecting ‘insert’ or ‘delete’ from the pop-up menu. Coloring the sheet tabs in your Excel workbook make the presentation of the data beautiful and easily accessible. In fact, using colors you can visually group data like ‘expense’ and ‘depreciation’. Calculations on the data also becomes quicker and easier because you can access the data in the different cells in the workbook by using sheet names like ‘income’, ‘expense’, etc. The tab scrolling buttons located at the left bottom of your Excel workbook help you to navigate to different tabs. You can go to the first sheet tab, last tab, previous tab or next tab by clicking on the appropriate button. Watch the training video below to see how you can rename, format and insert sheet tabs in Excel.

Leave a Reply

Your email address will not be published. Required fields are marked *