Top Answer
User Avatar
Wiki User
Answered 2011-05-15 04:47:05

Yes in a workbook each worksheet must have unique name, you cant have two worksheets with the same name.

User Avatar

Your Answer

Still Have Questions?

Related Questions

When you save a workbook each worksheet will have a different file name?

No. The workBOOK is saved as a single file including every workSHEET.

What does a new worksheet icon looks like in Excel?

There is a specific icon for a new workbook, which is a whole new file, but not a worksheet. To add a worksheet to the existing workbook, go to the Insert menu and choose Worksheet.

What is an Excel file referred to as?

You could refer to it as a spreadsheet, workbook or a worksheet if the workbook consists of a single sheet.

What are Excel workbook windows?

A workbook is an Excel file, containing worksheets. Normally a worksheet is viewed in a single window. You can however, split the worksheet window so that you can have more than one window and look at different parts of the same worksheet at the same time.

A worksheet is always stored in a workbook?

Yes. Every workBOOK contains one or more workSHEETs. The saved file is the workBOOK. Al

What does Excel store in documents?

Excel stores worksheet and workbook data in a file.

How can you separate the worksheets within a workbook into their own files in excel?

There is no automatic method to save each worsheet as a separate file, you need to do that manually. If you have three worksheets, then save the file two more times, so you have three worksheets instead of only one. Open each workbook and delete the worsheets you do not want in that file. Repeat the process until you have only one worksheet in each workbook.

What is the difference between a worksheet and a workbook?

A workbook contains worksheets, in the same way that a book contains pages. A workbook file consists of one or more worksheets.

What is the difference between worksheet and workbook?

The worksheets are the individual sheets that you work on. A workbook contains all the individual worksheets. It is the file that you save.

Wheres a worksheet file that is active?

It is the worksheet that you are looking at and working on at any given time. You may have many worksheets in a workbook and even many workbooks open, each with many worksheets, but you can only have one active worksheet, which is the one you are currently working in.

What is the difference between a worksheet and a workbook in Excel?

A worksheet is a single spreadsheet page and a workbook is a collection of all the worksheets in a single file. A workbook contains worksheets, in the same way that a book contains pages. A workbook consists of one or more worksheets.For example, if you had one sheet that was a table with information and another sheet with a pie chart, you would have a workbook. On the other hand, a worksheet is one spreadsheet in Excel that you are working on.

What is the difference between sheet and Work book?

Imagine the workbook to be a physical file/folder and the worksheet is a single page within this file/folder.

What are workbooks and worksheet?

A workbook is the MS Excel file in which you enter and store related data.A worksheet is a collection of cells on a single "sheet" where you actually keep and manipulate the data.

Can part of data in excel be saved as a file?

If you only want part of a worksheet to be saved, then copy the section you would like to save, open a new workbook, paste the section into a worksheet, and save the new file.

What is a link in Excel?

A link in Excel can be like a link on a webpage. By clicking on it, it can enable you to jump to different parts of the worksheet, different parts of the workbook, to a different workbook, to another kind of file and to a webpage. Another type of link is where data in one workbook is linked to data in another workbook or other kind of document. When data is updated in one, it will also change in the other document, as it is looking at data it is linked to.

What is a workbook in Microsoft Excel?

A workbook is the MS Excel file in which you enter and store related data.A worksheet (also known as a spreadsheet) is a collection of cells on a single "sheet" where you actually keep and manipulate the data.Each workbook can contain many worksheets. (It's a lot like a book. One book contains an entire story. Each page of the book contains part of the story.)Often one workbook has a single theme, such as a personal budget. Each worksheet would then have a part of the theme, such as the budget broken down by month.

What is a workbook in Excel?

A workbook in Excel is a collection of worksheets. A worksheet is an arrangement of rows and columns, making up cells into which various types of data and formulas can be entered. Each row is numbered. Each column is headed by a letter or combination of letters.An Excel workbook is basically an Excel file, containing one or more Worksheets. They are individual spreadsheets in your document.

What are the names for a spreadsheet in Microsoft Excel?

An individual sheet is known as a worksheet. A file which contains one or more worksheets is known as a workbook.

Where can I find this worksheet online?

Unless there is a URL at the bottom of the page it might be hard to find the worksheet again. If it is from a specific workbook you might need to order another or see if the school has one on file.

What is the Microsoft spreadsheet called?

Your question is not clear. The program is called Excel. The file is called a workbook. The individual spreadsheet page is called a worksheet.

How do you link to another excel file in a formula?

Include the external workbook (surrounded by []) and worksheet names (followed by !) in the formula:=SUM([workbook.xls]worsheet!A1:A23)

In Excel a collection of worksheets is referred to as a?

WORKBOOKWorkbook.Assuming all of the worksheets are in the same file, the term is workbook.A workbook.workbook

Difference between spreadsheet and worksheet?

Spreadsheet and worksheet both are different. Spreadsheet is a file which contains multiple worksheets. A single worksheet has information's. Or we can say that a spreadsheet have one or more worksheet.

Still have questions?

Trending Questions
Who was Anna Kreisling? Asked By Wiki User
Unanswered Questions
What plug replaces l8rtc? Asked By Wiki User
Who are perceptual region's? Asked By Wiki User