Excel 2016

How to turn on/off the Quick Analysis feature

When you select a range of data, Excel may display the Quick Analysis icon in the lower-right corner of the range. After clicking this icon, you will see a list of analysis options that can be quickly applied to the selected data.

How to select row and column by keyboard

If you work with large amounts of data in Excel, quickly selecting the entire row, column, table, data range helps a lot.
To quickly select different areas of data, use the following hotkeys:

Saving workbooks

Saving your workbook to the same location with the same name is extremely easy. However, you need to take additional actions to put your copy in another place or with a different name.

6 ways to open an Excel workbook

The Open dialog box is your key to finding and retrieving Excel workbooks.

Modify cell data

To enter a value in the cell, activate it by selecting with the mouse or moving the cursor into the cell using the navigation keys, enter the value or type the text, and press the Enter key or one of the navigation arrow keys. See how to change the direction of the cursor after pressing the Enter key.

Recalculating the worksheet

By default, Excel automatic recalculation feature is enabled. Thus, all formulas in the workbook sheets recalculate immediately after data dependencies change. Automatic recalculation of all formulas also occurs when opening a workbook.

How to insert fractions

Fractions represent equal parts of a whole object or a collection of items. This tip describes how to use fractions simply. For example:
  • I paid the third part, that is, I paid 1/3 of the transaction,
  • Five of our group of 17 wore yellow dresses, which means 5/17 of our group were in yellow,

How to turn on or off Mini Toolbar

Excel displays a popup menu when you right-click the cell or the selected range. In addition, the Mini toolbar appears above or below the popup menu. The Mini toolbar in Excel contains commonly used tools from the Home tab. The Mini toolbar is especially useful when a tab other than Home is displayed.

How to change number, currency, or accounting format

International accounting and currency formats in non-current locale can become a problem in Microsoft Excel. You can apply a number, accounting, or currency format to some cells in Excel, but the default format may not be suitable for large ranges.

Viewing a worksheet in multiple windows

When working with multiple tables and large amounts of data, when designing or analyzing charts or diagrams, you may need to view two or more parts of the worksheet simultaneously.