Optional To save your workbook in a format other than the default. NOTE: This is an important consideration if you want your document to be able to open in Excel From the File menu, select Save. The file is saved. Was this article helpful? Yes No. This article is based on legacy software. Creating a Workbook An Excel file is called a workbook. Entering Text Excel allows you to enter text into cells. Select the cell where you want to enter text. Type text into the cell.
Entering Numbers Numeric cells can be used for calculations and functions. Select the cell where you want to enter numbers.
Not enough information. Not enough pictures. Any additional feedback? Submit feedback. Thank you for your feedback! Between and , depending on the language version of Excel that you have installed. Limited by available memory; a summary report shows only the first scenarios. Maximum limits of memory storage and file size for Data Model workbooks. January 1, January 1, , if date system is used. Colors used to identify changes made by different users when change highlighting is turned on.
Users who can open and share the workbook at the same time. The number of cells , columns , rows , and sheets supported by a spreadsheet depend on the software used, and the data contained in the spreadsheet.
Below is a list of the maximum number of rows, columns, cells, and individual sheets supported by various spreadsheet software. The below values are the theoretical limits. If you group all 10 worksheets together, and then format just the first one, Excel formats all the worksheets in exactly the same way. Or say you group Sheet1 and Sheet2, and then change the font of column B in Sheet2—Excel automatically changes the font in column B in Sheet1, too.
The same is true if you change the formatting of individual cells or the entire worksheet—Excel replicates these changes across the group. For example, if Sheet1 and Sheet2 are grouped, you can modify the formatting in either worksheet. Excel automatically applies the changes to the other sheet. With grouped worksheets, you can also modify the contents of individual cells, including entering or changing text and clearing cell contents.
For example, if you enter a new value in cell B4 in Sheet2, Excel enters the same value into cell B4 in the grouped Sheet1. Similar behavior occurs when you delete cells. Once again, it makes most sense when all the worksheets have the same structure.
For example, imagine that you move to cell A3 on Sheet1, which happens to be empty. If you click Delete, you see no change. However, if cell A3 contains data on other worksheets that are grouped, these cells are now empty. Grouper beware. Cut and paste operations work the same way as entering or modifying grouped cells. Whatever action you perform on one grouped sheet, Excel also performs on other grouped sheets.
The same action takes place in Sheet2—in other words, the contents of cell A1 in Sheet2 is copied to cell A2 also in Sheet2. Obviously, Sheet1 and Sheet2 might have different content in cell A1 and A2—the grouping simply means that whatever was in cell A1 will now also be in cell A2.
Excel keeps track of printing and display settings on a per-worksheet basis. 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.
0コメント