The Flexibility Of Worksheet Tabs In Excel 2007
Go to: Previous Article Next Article
An Excel 2007 document is a container referred to as a workbook. Workbooks, in turn, contain worksheets and it is the worksheet which actually stores your information. Although the number of worksheets is technically limited only by available memory, for most computer users, there will be a practical limit of a few dozen. A workbook containing hundreds of sheets will operate extremely slowly.
The controls for navigating and manipulating worksheets are located in the bottom left of the Excel document window. Each worksheet has a named tab which identifies and is used to activate it. As well as worksheets, Excel allows the user to create chart (and other) sheets. Each of these will also have a tab of its own.
When you insert a new sheet into a workbook, Excel automatically assigns is a name consisting of the word "Sheet" followed by a number. The simplest way of changing this default name is to double-click on the worksheet tab and either edit the name or simply type a new one. You can also right-click on a sheet tab and choose rename. The Rename command is also found in the Format section of the Cells group of the Home Tab.
If you have a sheet name which is rather long or in some way difficult, it is also possible to copy and paste the name from somewhere else. Simply use Control-C to copy any piece of text, double-click on a sheet tab and use Control-V to paste the text.
Another way of making your worksheet tabs easily identifiable is to assign them colours. For example, say you have worksheets containing monthly sales figures interspersed with sheets containing quarterly analysis, you could assign a different colour to worksheets in each quarter.
You would start by selecting the quarter one sheet then, holding down the Control key, click on the tabs containing the figures for January, February and March. Next, to set the colour of the selected tabs, choose Format Colour in the Format section of the Cells group of the Home Tab. You could then do the same to the sheets in the other three quarters.
As more and more sheets are added to a workbook, the fact of having different colours for certain sheets offers us another way of identifying and finding both individual sheets and sheets of a certain type. Assigning colours to sheet tabs also allows users to conform to standards which may already exist within their organisations, whereby a given colour is used to represent a certain type of information.
Article Source: Articlelogy.com
Insurance Comparison Quotes - Selected Insurance Carriers eager to quote you a price, fast!-
Word Count: 433
Reduce Your Debts Without Bankruptcy. See How Much You Can Save. Free Debt Analysis
