|
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 tabottom 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.
|
