Excel file how many sheets

The Share Workbook button is now at the top of the Excel window. Note: A workbook that contains one or more Excel tables cannot have the Allow changes by more than one user This setting is enabled when using Shared Workbooks.

Feature Maximum limit Users who can open and share the file at the same time Personal views in the workbook Limited by available memory Days that change history is maintained 32, default is 30 days Workbooks that can be merged at one time Limited by available memory Cells that can be highlighted in the workbook 32, Colors used to identify changes made by different users when change highlighting is turned on 32 each user is identified by a separate color; changes made by the current user are highlighted with navy blue Excel tables in the workbook 0 zero Note: A workbook that contains one or more Excel tables cannot have the Allow changes by more than one user Feature Maximum limit Users who can open and share the workbook at the same time Personal views in the workbook Limited by available memory Days that change history is maintained 32, default is 30 days Workbooks that can be merged at one time Limited by available memory Cells that can be highlighted 32, Colors used to identify changes made by different users when change highlighting is turned on 32 each user is identified by a separate color; changes made by the current user are highlighted with navy blue Excel tables in the workbook 0 zero Note: A workbook that contains one or more Excel tables cannot have the Allow changes by more than one user Need more help?

Expand your skills. Get new features first. A subscription to make the most of your time. Try one month free. Was this information helpful?

In other words, when you set the zoom percentage Section 7. Once you get the hang of creating different worksheets for different types of information, your Excel files can quickly fill up with more sheets than a linens store. What happens when you want to shift some of these worksheets around? For instance, you may want to move or copy a worksheet from one Excel file to another.

Open both spreadsheet files in Excel. The file that contains the worksheet you want to move or copy is called the source file; the other file where you want to move or copy the worksheet to is known as the destination file. Go to the source workbook. Right-click the worksheet you want to transfer, and then, from the shortcut menu that appears, choose Move or Copy.

If you want, you can transfer multiple worksheets at once. Just hold down the Ctrl key, and select all the worksheets you want to move or copy. Excel highlights all the worksheets you select and groups them together.

Right-click the selection, and then choose Move or Copy. Here, the selected worksheet is about to be moved into the SimpleExpenses. Excel inserts the new worksheet just before the first sheet. Excel also lets you move your worksheets to a new workbook, which it automatically creates for you.

Specify the position where you want the worksheet inserted. Excel places the copied worksheets just before the worksheet you select. Click OK. For example, if you try to copy a worksheet named Sheet1 to a workbook that already has a Sheet1, Excel names the copied worksheet Sheet1 2. And if you need to make changes to a bunch of identical items, the find-and-replace option can be a real timesaver. With the advanced options turned on, you can do things like search for cells that have certain formatting characteristics and apply changes automatically.

The next few sections dissect these features. The difference is that Go To moves to a known location, using the cell address you specify. Excel searches by comparing the content you enter with the content in each cell. For example, if you searched for the word Date , Excel identifies as a match a cell containing the phrase Date Purchased.

When searching cells that contain numeric or date information, Excel always searches the display text. For more information about the difference between the way Excel displays a numeric value—the underlying value Excel actually stores —see Section 2. For example, say a cell displays dates using the day-month-year format, like 2-Dec You can find this particular cell by searching for any part of the displayed date using search strings like Dec or 2-Dec A similar behavior occurs with numbers.

However, the search string 3. Excel searches one cell at a time, from left-to-right. When it reaches the end of a row, it moves to the first column of the next row. To perform a find operation, follow these steps:. Move to the cell where you want the search to begin. If you select a group of cells, Excel restricts the search to just those cells. You can search across a set of columns, rows, or even a non-contiguous group of cells. To assist frequent searches, Excel lets you keep the Find and Replace window hanging around rather than forcing you to use it or close it, as is the case with many other dialog boxes.

Click Find Next. Excel jumps to the next matching cell, which becomes the active cell. Keep clicking Find Next to move through the worksheet. Enter the Find All feature. With Find All, Excel searches the entire worksheet in one go, and compiles a list of matches, as shown in Figure However, Excel does keep the text and numbers in your found-items list synchronized with any changes you make in the worksheet.

For example, if you change cell D5 to Total Price, the change appears in the Value column in the found-items list automatically. This tool is great for editing a worksheet because you can keep track of multiple changes at a single glance. Finally, the Find All feature is the heart of another great Excel guru trick: it gives you another way to change multiple cells at once. Click in the formula bar, and then start typing the new value. Basic searches are fine if all you need to find is a glaringly unique phrase or number Pet Snail Names or 10,,, You can set any or all of the following options:.

If you want your search to span multiple worksheets, go to the Within box, and then choose Workbook. The standard option, Sheet, searches all the cells in the currently active worksheet.

If you want to continue the search in the other worksheets in your workbook, choose Workbook. Excel examines the worksheets from left to right. When it finishes searching the last worksheet, it loops back and starts examining the first worksheet.

The Search pop-up menu lets you choose the direction you want to search. The standard option, By Rows, completely searches each row before moving on to the next one. On the other hand, if you choose By Columns, Excel searches all the rows in the current column before moving to the next column. That means that if you start in cell B2, Excel searches B3, B4, and so on until it reaches the bottom of the column and then starts at the top of the next column column C.

However, the search will still ultimately traverse every cell in your worksheet or the current selection. Thus, searching for Date matches the cell value Date , but not date. Excel ordinarily looks to see if your search term is contained anywhere inside a cell. Similarly, numbers like 32 match cell values like , , and 1.

Power searchers will be happy to know that Excel lets you use wildcards in your searches. Wildcards are search symbols that let you search for variations on a word. The question mark? For example, a search for f?

To use formatting details as part of your search criteria, follow these steps:. Launch the Find tool. The Find Format dialog box appears Figure It contains the same options as the Format Cells dialog box discussed in Section 5. Checkboxes are a little trickier. In other versions of Windows, it looks like the checkbox is dimmed and checked at the same time. Specify the format settings you want to look for.

Using the Find Format dialog box, you can specify any combination of number format, alignment, font, fill pattern, borders, and formatting. Chapter 5 explains all these formatting settings in detail. You can also search for protected and locked cells, which are described in Chapter To remove these formatting restrictions, click the pop-up menu to the right of the Format button and then choose Clear Find. Rather than specifying all the format settings manually, you can copy them from another cell.

Note The below values are the theoretical limits. Additional information See our cell , column , excel , rows , and sheet page for further information and related links. Microsoft Excel help and support. It is called freezing panes. When you freeze panes, you select rows or columns that will remain visible all the time, even as you are scrolling. This is particularly useful when working with large spreadsheets.

Excel Working with Worksheets. Next: Using Templates.