excel 2013 for mac trace precedents on another sheet

Once you have selected constants, under Formulas, you will be able to check numbers, text, logicals or errors. In the Go to Special dialog box, if you select Constants and press Enter or click OK, Excel selects all cells with constants. The Go To Special dialog box appears as follows: Click Find & Select and choose Go to Special from the drop-down menu. The Go to Special command appears on the Home tab in the Editing group. Use the Find & Select drop-down menu on the Home tab in the Ribbon.Press F5 and then select Special in the dialog box.Press Ctrl + G and then select Special in the dialog box.You can access Go To Special in several ways: Constants (numbers, text, logicals, errors).Formulas (numbers, text, logicals, errors).You can use Go To Special to select cells that meet specific criteria including: Recommended article: 10 Excel Data Entry Tricks and Shortcuts Every User Should Knowĭo you want to learn more about Excel? Check out our virtual classroom or live classroom Excel courses > After you select multiple cells with Go To Special, you can enter data in the selected cells by pressing Ctrl + Enter or by apply formatting. You can find many useful things using the Go To Special dialog box including formulas, constants, blanks, visible cells and conditional formatting. Go To Special also searches within the selected range if a range has been selected.

It only selects cells in the current worksheet, not the entire workbook.

You can use Go To Special in Excel to quickly find and select cells of a specific type within your worksheet.

Formulas now become shortcuts to help you navigate large spreadsheets, allowing you to jump between and detail sections and totals.Use Go to Special in Excel to Find, Select, Replace and Format Cellsīy Avantix Learning Team | Updated May 1, 2021Īpplies to: Microsoft ® Excel ® 2010, 2013, 2016, 2019 and 365 (Windows).

If you’re thinking of deleting or changing a cell but don’t know what it will affect, Ctrl+] will tell you if it is used in any formulas.

If you want to quickly check to make sure your formula is pointing to the right cell, Ctrl+ to get back where you started. Some of you are asking why anyone would want to do that. I’ve written before about the ability to trace precedents and dependents, But I recently learned two keyboard shortcuts that take you to your current cell’s precedents or dependents.Ĭtrl+ will move your cursor to the dependent(s) of the current cell, that is, the cell or cells with a formula that uses the current cell. Conversely, the cell containing the formula is a dependent because it needs the cell containing the data to complete its function. In Excel, the other cells that are referred to in a formula are called precedents.

Excel 2013 for mac trace precedents on another sheet