Microsoft Office Tutorials and References
In Depth Information
Working with Excel Fundamentals
You can try changing a worksheet name on your own. Do it the easy way:
1. Double-click a worksheet’s tab.
2. Type in a new name and press Enter.
You can change the color of worksheet tabs. Right-click the tab and select Tab
Color from the list.
To insert a new worksheet into a workbook, click the New sheet button, which
is located after the last worksheet tab. Figure 1-4 shows how. To delete a
worksheet, just right-click the worksheet’s tab and select Delete from the list.
Don’t delete a worksheet unless you really mean to. You cannot get it back
after it is gone. It does not go into the Windows Recycle Bin.
You can insert many new worksheets. The limit of how many is based on
your computer’s memory, but you should have no problem inserting 200 or
more. Of course I hope you have a good reason for having so many. Which
brings me to the next point.
Worksheets organize your data. Use them wisely and you will find it easy to
manage your data. For example, say that you are the boss (I thought you’d
like that!), and you have 30 employees that you are tracking information
on over the course of a year. You may have 30 worksheets — one for each
employee. Or you may have 12 worksheets — one for each month. Or you
may just keep it all on one worksheet. How you use Excel is up to you, but
Excel is ready to handle whatever you throw at it.
You can set how many worksheets a new workbook has as the default. To do
this, click the File tab, then click Options, and then the General tab. In the section
“When creating new workbooks,” use the spinner control to select a number.
Introducing the Formulas Ribbon
Without further ado, I present the Formulas Ribbon. The Ribbon sits at the
top of Excel. Items on the Ribbon appear as menu headers along the top of