Question about Microsoft Excel for PC

1 Answer

Additional worksheets How would I add additional worksheets on a particular file

Posted by on

1 Answer

  • Level 1:

    An expert who has achieved level 1.


    An expert who has answered 20 questions.


    An expert that hasĀ over 10 points.


    An expert whose answer gotĀ voted for 2 times.

  • Contributor
  • 39 Answers
Re: additional worksheets

Open the file
right click in the workseets (right bottom at the screen)
Choose new worksheet

Let me know if i could help you

Posted on Dec 18, 2007

Add Your Answer

0 characters

Uploading: 0%


Complete. Click "Add" to insert your video. Add


3 Points

Related Questions:

2 Answers

What is a workbook?

A workbook is a spreadsheet file. By default, each workbook in Excel contains three pages or worksheet

The term spreadsheet is often used to refer to a workbook, when in actual fact, spreadsheet refers to the computer program, such as Excel.

So, strictly speaking, when you open the Excel spreadsheet program it loads an empty workbook file consisting of three blank worksheets for you to use.

Jun 25, 2011 | Microsoft Office Excel 2007 Full Version...

1 Answer

What is default name in ms excel? how is possible excel worksheet in excel?

Book1.xls Do you mean that you can't find the worksheet you have establish and you haven't rename the file? The worksheet will be OK if it had been saved.

Feb 15, 2011 | Microsoft Office 2010

1 Answer

How many charts can put in a sheet?


In Microsoft Excel 2003 for PC, you may add at least 32 charts as as objects into a worksheet (as illustrated above), however it appears that you may add as many charts as you wish into a worksheet using this method .

Dec 10, 2009 | Microsoft Excel 2003 (06503995)

3 Answers

How can enable mail recipient as attachment excel


Apr 11, 2009 | Microsoft Office Excel 2003 for PC

1 Answer

Create batch file

Did you try the following?
  1. Open all of the workbooks that contain the scenarios you want to merge.
  2. Switch to the worksheet where you want to merge the scenarios.
  3. On the Tools menu, click Scenarios.
  4. Click Merge.
  5. In the Book box, click a workbook name.
  6. In the Sheet box, click the name of a worksheet that contains the scenarios you want to merge, and then click OK.
  7. Repeat this process if you want to merge scenarios from more worksheets.

Feb 21, 2009 | Microsoft Office Standard for PC

1 Answer


Try this:
1. Find the copy of the workbook on which you will merge the changes. In Excel, go to "File > Open" and find the file.
3. Click "Tools > Compare" and "Merge Workbooks." 4. Look for the files you want to merge and add them into the current file. 5. Click “OK” to merge the files. This is your master copy of this workbook. 6. Save the file.

Dec 21, 2008 | Microsoft OFFICE 2003 BASIC OEM ENGLISH MS...

1 Answer

Print area in worksheet

1. Select area you want to print.

2. When you click Print, you getting Print window.
In "Print what" frame choose "Selection" option.

Sep 17, 2008 | Microsoft Office Professional 2007 Full...

2 Answers

Import data from access into excel where one column go into one worksheet and other into next

Can't be done.

Access will only put the data into one worksheet. It is very picky when it comes to exporting data into an Excel spreadsheet.

There are two ways to get around it:

1) You can export the data from Access into two files. One for the the first worksheet and another file for the second workshet.

2) You can import everything into one spreadsheet and build a macro into Excel to cut the information one spreadsheet and paste it into the other if this is a redundant task to do all the time.

Hope that helps you out.

Jun 10, 2008 | Microsoft Office Access 2003 (077-02871)...

1 Answer

LINE 100

If Sale Line 100 is an Excel Template then it is simple.

The Templates are just preformatted spreadsheets which are edited just like any other spreadsheet.

If you mean that you are using the Template to create another document but wanting all the fields to be the same as the Invoice then I suggest the following method:

Copy the Template fron Worksheet 1 onto Worksheet 2.

Add and remove any fields that you wnt to add or remove (Prices would be deleted on this copy and the title would be changed from Invoice to Delivery Docket, etc)

Then (on Worksheet 2) in the fields that you want to be the same - click on the cell you want the same Data in and hit the = sign. Then go to Worksheet 1 and Click on the cell that you want the data to be the same. Hit Enter. This will send you back to Worksheet 2 and you will see that any data entered into the cell in Worksheet 1 will now also appear in Worksheet 2.

Repeat this process for all the cells you want copied from worksheet 1.

When you complete the data in Worksheet 1 (the Invoice) all the data selected will automatically appear in the cells selected on Worksheet 2.

Try this on worksheet 2 select cell A1, type =, then open worksheet 1 and select B1. You will be returned to worksheet 2 and the formula in cell A1 will now read =Sheet1!A1. Enter anything into Shhet 1 A1 and you will see that it appears in the appropriate cell on Sheet 2.

When you want to print off the Invoice and the Delivery Docket - you only have to open each Worksheet and hit Print and a copy of each worksheet will be printed giving you an Invoice and a Delivery Docket with the appropriate info on each printout (eg if you exclude prices from the Del. Docket then after completing all the details in the Invoice will create a Del Docket with all the relevant information other than the prices.

Does this answer your question?

Apr 25, 2008 | Business & Productivity Software

2 Answers

Unsure of correct formula

You can add a reference from the worksheet 1 to all other worksheets

Is it OK?

Mar 08, 2008 | Microsoft Excel for PC

Not finding what you are looking for?
Microsoft Excel for PC Logo

Related Topics:

133 people viewed this question

Ask a Question

Usually answered in minutes!

Top Microsoft Business & Productivity Software Experts

Brian Sullivan
Brian Sullivan

Level 3 Expert

27725 Answers


Level 3 Expert

18257 Answers

Sudeep Chatterjee
Sudeep Chatterjee

Level 3 Expert

3267 Answers

Are you a Microsoft Business and Productivity Software Expert? Answer questions, earn points and help others

Answer questions

Manuals & User Guides