Manipulating Worksheets In Excel

Other - Computers Add comments

a href=http://www.macresource.co.uk/on-site-training-bath.asp target=_blankMicrosoft Excel 2007/a offers a number of different ways of inserting new sheets into your workbooks. One of the simplest is to use the Insert Worksheet button. This is located on the right-hand side of the worksheet tabs. Regardless of which worksheet is active, clicking this button will always insert a worksheet as the last tab in your workbook.br /
br /
It is also possible to insert a worksheet at a given position within the workbook. For example, lets say we have a workbook containing a record of the invoices issued by a company in each month of the year. There are twelve worksheets names January, February, and so forth. We now want to insert quarterly analysis sheets at the end of each quarter.br /
br /
As with columns, Excel inserts new worksheets to the left of the currently selected tab. Therefore to insert the first quarterly analysis sheet, we would select April. However, as weve seen, we cant use the Insert Worksheet button to insert the new sheet or it will always go at the end. So instead, we use the Insert command in the Cells section of the Home Tab of the Excel Ribbon.br /
br /
We could also right-click on the April tab and choose Insert. Excel then allows us to choose the type of sheet we want to insert. As well as worksheet, we can insert a chart sheet, a backwardly compatible macro sheet or dialog sheet. These are useful for Excel developers. In addition we can insert a spreadsheet solution such as the billing statement or sales report. To insert a worksheet, in the General tab of the Insert dialogue, click on worksheet then click OK.br /
br /
We would then rename the sheet; lets say Qtr1 Analysis and repeat the same procedure to insert analysis sheets to the left of the July and October tabs. The analysis sheet of the fourth quarter will be the last sheet in the workbook. We can only insert a worksheet in this position by using the Insert Worksheet button.br /
br /
You can delete the selected worksheet by using the Delete Sheets command in the Cells group of the Home Tab of the Excel Ribbon. Its also possible to delete a sheet by right-clicking on the sheet tab and choosing Delete. To delete multiple sheets, simply highlight the relevant tabs and then using the Delete Sheet command. br /
br /
Selecting multiple sheets involves the use of the classic Windows techniques of Shift-click and Control-click. To select a contiguous range of sheet tabs, click on the first, hold down the Shift key and click on the last. To select a non-contiguous range of tabs, click on the first, hold down the Control key and click on each of the others.br /
br /
To deselect a selected range of tabs, click on a tab which isnt selected. If all tabs are selected, just click on the name of any tab to select only that tab.br /
br /
The author is a trainer and developer with Macresource Computer Training, an independent computer training company offering a href=http://www.macresource.co.uk/excel-vba-training-bath.asp target=_blankExcel Training Courses in London/a and throughout the UK.br /
br /
For pragmatic tips about a href=http://www.workfromhome-business-opportunity.com/ target=_blankwork from home/a – read hyperlinked publication.

Be Sociable, Share!
Leave a Reply

You must be logged in to post a comment.

Entries RSS Comments RSS Log in