An annoyance when you have more than 3 worksheets. To view more, simply hover over the 3 dots at the left of the scrollbar. Then click and drag it to the right.
In Excel, working with your worksheets as a single group is a quicker way for applying formulas and formatting across worksheets with the same formatting. To ungroup your worksheets, you can right click and select Ungroup Sheets option. Additional information See our cell , column , excel , rows , and sheet page for further information and related links.
Microsoft Excel help and support. Was this page useful? Instead, you can simply right-click the scroll arrows in the lower-left corner, as shown below. A dialog box will appear with a list of all of the sheets in your workbook.
You can then double-click the sheet you want to jump to. You can work with each worksheet individually , or you can work with multiple worksheets at the same time. Worksheets can be combined together into a group. Any changes made to one worksheet in a group will be made to every worksheet in the group.
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. The pointer changes to a plus symbol with an eyedropper next to it.
Next, click any cell that has the formatting you want to match. Keep in mind that when you use this approach, you copy all the format settings. The Find Format dialog box shows a basic preview of your formatting choices. Excel lets you make two types of changes using its replace tool:. You can automatically change cell content. You can automatically change cell formatting. Or, you can search for every cell that uses a specific font, and modify these cells so they use a new font.
The box below gives some superhandy tricks you can do with this process. Here are just a few examples:. You can automatically delete a specific piece of text. You can change the formatting used in specific cells. You can change the formatting used in a series of cells.
0コメント