Where is go to in excel 2010

You may have many reasons, but after reading this tutorial you should be able to use it flawlessly. Please comment below. Hello, I am an 'Excel enthusiast' and early adopter of technology.

Subscribe to our: Newsletter Know more: About Me. Excel Go to Special command has a special focus in the industry, do you know why..? To do so, you can copy entire pivot table and do paste special values.

Many users find that using an external keyboard with keyboard shortcuts for Excel helps them work more efficiently. For users with mobility or vision disabilities, keyboard shortcuts can be easier than using the touchscreen, and are an essential alternative to using a mouse. The shortcuts in this topic refer to the US keyboard layout. Keys for other layouts might not correspond exactly to the keys on a US keyboard. This article describes the keyboard shortcuts, function keys, and some other common shortcut keys in Excel for Windows.

To quickly find a shortcut in this article, you can use the Search. If an action that you use often does not have a shortcut key, you can record a macro to create one. Download our 50 time-saving Excel shortcuts quick tips guide. Get these keyboard shortcuts in a Word document: Excel for Windows keyboard shortcuts.

Frequently used shortcuts. Ribbon keyboard shortcuts. Use the Access keys for ribbon tabs. Work in the ribbon with the keyboard. Keyboard shortcuts for formatting cells.

Keyboard shortcuts in the Paste Special dialog in Excel Keyboard shortcuts for making selections and performing actions. Keyboard shortcuts for working with data, functions, and the formula bar. Keyboard shortcuts for refreshing external data. Power Pivot keyboard shortcuts. Keyboard shortcuts in Office Add-ins task panes. Function keys. Other useful shortcut keys.

The ribbon groups related options on tabs. For example, on the Home tab, the Number group includes the Number Format option. Press the Alt key to display the ribbon shortcuts, called Key Tips, as letters in small images next to the tabs and options as shown in the image below. You can combine the Key Tips letters with the Alt key to make shortcuts called Access Keys for the ribbon options.

Press Alt again to see KeyTips for the options for the selected tab. In Office and Office , most of the old Alt key menu shortcuts still work, too. However, you need to know the full shortcut. A notification pops up saying you're using an access key from an earlier version of Microsoft Office.

If you know the entire key sequence, go ahead and use it. If you don't know the sequence, press Esc and use Key Tips instead. To go directly to a tab on the ribbon, press one of the following access keys. Additional tabs may appear depending on your selection in the worksheet. Move to the Tell me or Search field on the Ribbon and type a search term for assistance or Help content.

Open the Insert tab and insert PivotTables, charts, add-ins, Sparklines, pictures, shapes, headers, or text boxes. Open the Page Layout tab and work with themes, page setup, scale, and alignment. Open the Formulas tab and insert, trace, and customize functions and calculations. Open the Data tab and connect to, sort, filter, analyze, and work with data. Open the Review tab and check spelling, add notes and threaded comments, and protect sheets and workbooks.

Open the View tab and preview page breaks and layouts, show and hide gridlines and headings, set zoom magnification, manage windows and panes, and view macros. Enter the End mode, move to the next nonblank cell in the same column or row as the active cell, and turn off End mode. If the cells are blank, move to the last cell in the row or column.

Move one cell to the right in a worksheet. Or, in a protected worksheet, move between unlocked cells. Edit the active cell and put the insertion point at the end of its contents. Or, if editing is turned off for the cell, move the insertion point into the formula bar.

If editing a formula, toggle Point mode off or on so you can use arrow keys to create a reference. Use the Fill Down command to copy the contents and format of the topmost cell of a selected range into the cells below. Apply the Number format with two decimal places, thousands separator, and minus sign - for negative values. In Excel , you can paste a specific aspect of the copied data like its formatting or value using the Paste Special options.

To pick an option in the dialog, press the underlined letter for that option. For example, press the letter C to pick the Comments option. Extend the selection of cells to the last nonblank cell in the same column or row as the active cell, or if the next cell is blank, to the next nonblank cell. Select the current region if the worksheet contains data. Press a second time to select the current region and its summary rows. Press a third time to select the entire worksheet.

Calculate all worksheets in all open workbooks, regardless of whether they have changed since the last calculation. Check dependent formulas, and then calculate all cells in all open workbooks, including cells not marked as needing to be calculated. Display the Function Arguments dialog when the insertion point is to the right of a function name in a formula.

Insert argument names and parentheses when the insertion point is to the right of a function name in a formula. Invoke Flash Fill to automatically recognize patterns in adjacent columns and fill the current column. Cycle through all combinations of absolute and relative references in a formula if a cell reference or range is selected.

Use the following shortcuts keyboard shortcuts with Power Pivot in Microsoft , Excel , Excel , and Excel Move to the last cell in the lower right corner of selected table the last row of the Add Column. Recalculate all formulas in the Power Pivot window. For more information, see Recalculate Formulas in Power Pivot. F2 alone: edit the active cell and put the insertion point at the end of its contents.

F3 alone: displays the Paste Name dialog. Available only if names have been defined in the workbook. When a cell reference or range is selected in a formula, F4 cycles through all the various combinations of absolute and relative references. F6 alone: switches between the worksheet, ribbon, task pane, and Zoom controls. In a worksheet that has been split , F6 includes the split panes when switching between panes and the ribbon area.

F7 alone: Opens the Spelling dialog to check spelling in the active worksheet or selected range. Use the arrow keys to move the window, and when finished press Enter, or Esc to cancel. F8 alone: turns extend mode on or off. In extend mode, Extended Selection appears in the status line, and the arrow keys extend the selection.

Left or Right arrow key selects the tab to the left or right when the ribbon is selected. When a submenu is open or selected, these arrow keys switch between the main menu and the submenu.

When a ribbon tab is selected, these keys navigate the tab buttons. Down or Up arrow key selects the next or previous command when a menu or submenu is open. When a ribbon tab is selected, these keys navigate up or down the tab group.

In a dialog, arrow keys move between options in an open drop-down list, or between options in a group of options. Removes the cell contents data and formulas from selected cells without affecting cell formats, threaded comments or notes.

End turns End mode on or off. In End mode, you can press an arrow key to move to the next nonblank cell in the same column or row as the active cell. Highlighting all constants is a great way of checking the structure of your spreadsheet.

I normally format inputs with a white background and blue font. A great tool for auditing — select all constants and change the fill colour. This instantly gives you visibility of your model inputs and flags any inconsistencies. Benefit: Highlighting all of the formulas within your spreadsheet is a great way of checking the structure and consistency of your spreadsheet. Benefit: A quick way to select all blank cells. This is useful if you want to quickly format all blank cells or as a way of identifying cells that look blank but actually contain a constant or formula i.

Related: Fill Blank Cells. Comment: I have never used this option but would be very interested to hear if anyone has. Benefit: A simple way to select all objects. This could be useful if you wanted to quickly delete all objects in the worksheet. Single row : Selects the cells that are different from the active cell within the selected row.

Multiple rows : The comparison is made for each row independently. The cell used for comparison for each row is the cell in the same column as the active cell. Benefit: This is a very useful auditing tool for highlighting inconsistent formulas in a row. It also offers a quick and easy way to spot differences across multiple rows. Single column : Selects the cells that are different from the active cell within the selected column.

Multiple columns : The comparison is made for each column independently. The cell used for comparison for each column is the cell in the same row as the active cell. Benefit: This is a very useful auditing tool for highlighting inconsistent formulas in a column. It also offers a quick and easy way to spot differences across multiple columns. Benefit: Provides an alternative to Trace Precedents in the formula auditing bar. Personally I prefer using this tool to select and then colour-fill the precedent cells as it allows you to select the precedents for a range of cells rather than just one.

I also find that the arrows in Trace Precedents can get a little messy. Benefit: As above this provides an alternative to Trace Dependents in the formula auditing bar. Action: Selects the last used cell within your worksheet containing data or formatting. Benefit: A quick way to locate your last cell. This is a very effective way of identifying the range of cells used of the worksheet.

If your simple spreadsheet suddenly becomes very large in MB terms this can be due to Excel incorrectly thinking that you are using a lot more of the cells than you actually are.

A good indicator of this is that the right hand scroll bar slider becomes very small. Benefit: Useful if you only want to change the non-hidden cells and leave the hidden cells unchanged. Same: Selects all cells that have the same conditional formatting as is applied to the active cell.

Benefit: An easy way to quickly identify all of the cells with conditional formatting applied to them. A useful tool for understanding the formatting applied to a spreadsheet. You need to be aware that, depending on the conditional formatting set, you may not be able to highlight the cells using a fill colour as the conditional formatting may override it.

Comment: The manage rules option within the conditional formatting menu also enables you to identify cells with conditional formatting applied. Same: Selects all cells that have the same data validation as is applied to the active cell.

Benefit: An easy way to quickly identify all of the cells with data validation applied to them. This is particularly useful from an auditing perspective or if you want to clear the validations in these cells. In order to give you some examples of how to use the Go To Special tools covered above I have put together a list of actions for you to run over the attached spreadsheet.

Have a play and see what you discover:. Failing to do this will restrict the new search to the currently selected range. I have recorded the above steps into a macro to give you a useful audit macro that could be adapted for future use. Click on the button on the Info tab to run the macro. I use go to special both dialog box and keyboard shortcuts all the time. It is a really easy way to navigate a complex workbook and quickly select what you want. My favorite uses of Go to special are, selecting blank cells, finding data validations, locking formula cells, formatting input cells constants.

What about you? Have you used Go to Special? What are your favorite features? Please share using comments. Formulas with only Numbers checked and press Enter or click OK, Excel selects all cells that return a number. Formulas with only Text checked and press Enter or click OK, Excel selects all cells that return text Formulas with only Logicals checked and press Enter or click OK, Excel selects all cells that return logicals true or false.

Formulas with only Errors checked and press Enter or click OK, Excel selects all cells that return errors. That can be a great way to find and then fix errors. This can be very useful if you want to quickly format or fill blank cells. Finding and selecting the current region or array In the Go to Special dialog box, if you select: Current Region and press Enter or click OK, Excel selects all cells in the current region.

Current Array and press Enter or click OK, Excel selects the entire array if the active cell is within the array. Finding and selecting row and column differences In the Go to Special dialog box, if you select: Row differences and press Enter or click OK, Excel selects all cells that are different from the active cell in the selected row.

To use this, first select the cells you want to compare, tab to the cell you want to use as the basis for comparison and then select Go to Special. If more than one row is selected, the comparison is performed for each row based on the cell in the same column as the first active cell.

Column differences and press Enter or click OK, Excel selects all cells that are different from the active cell in the selected column.

If more than one column is selected, the comparison is performed for each column based on the cell in the same row as the first active cell. Finding and selecting precedents and dependents In the Go to Special dialog box, if you select: Precedents and press Enter or click OK, Excel selects the cells that are referenced by the formula in the active cell.

Under Dependents, if you selected Direct only, Excel finds only cells that are directly referenced by formulas. If you clicked All levels, Excel would find all cells that are directly or indirectly referenced by the cells in the selection.

You could then apply a fill color or other formatting to the precedent cells. Dependents and press Enter or click OK, Excel selects the cells that are affected by changes in the active cell. Under Dependents, if you selected Direct only, Excel finds only cells that are directly affected by changes in the active cell.

If you clicked All levels, Excel would find all cells that are directly or indirectly affected by changes in the active cell. You could then apply a fill color or other formatting to the dependent cells. Finding and selecting the last cell In the Go to Special dialog box, if you select Last cell and press Enter or click OK, Excel selects the last cell that contains data or formatting.

Finding and selecting visible cells In the Go to Special dialog box, if you select Visible cells only and press Enter or click OK, Excel selects only the visible cells in a selection where there are hidden cells. This can be useful for formatting only visible cells or copying only visible cells.