Step 3: The number 3,432 is pasted in cell C2 as a value and not as a formula. “Values” is automatically selected under “paste.” Click “Ok.” The formulas are applied to the entire range (C2:C6). The cell C2 is dependent on the cells A2 and B2.Ĭopy-paste or drag the formula to the remaining cells. Step 1: In cell C2, enter the following formula. The steps to calculate sales and apply the “paste special” shortcut are listed as follows: Use the shortcut of the “paste special” property. We want to calculate the sales figures and, instead of formulas, paste the final values in column C. The succeeding table shows the prices (in $ in column B) at which some units (column A) of a product are sold. Note: Prior to pressing the excel shortcut, the formula cell must be copied and the desired output cell (where output is required) should be selected. The excel shortcut “Alt+E+S+V” (press one by one) opens the “paste special” window and selects “values” under “paste.” read more,” it is possible to paste the value of the formula cell at the desired location. There are several ways to paste special in Excel, including right-clicking on the target cell and selecting paste special, or using a shortcut such as CTRL+ALT+V or ALT+E+S. With “ paste special Paste Special Paste special in Excel allows you to paste partial aspects of the data copied. If a formula cell is copied and pasted, its formula is pasted and not the value of the cell. To develop expertise in Excel, it is imperative to go beyond the basic cut (Ctrl+X), copy (Ctrl+C), and paste (Ctrl+V) shortcuts. However, a regular usage does allow gradual learning. It is not possible to memorize every excel shortcut. The explanation of each technique is followed by a relevant example. This article discusses the important excel shortcuts which have been consolidated keeping in mind the day-to-day needs of the user. #18–Select the Last Non-Blank Cell of a Row or Column.#16–Move Between Worksheet and Excel VBA Editor.#3–Fill the Subsequent Cell With the Fill Down.

#1–Paste as Values With “Paste Special”.

Excel page down shortcut