Sometimes when writing an ad hoc query you might want to take the results of one query and put them into an IN() statement of another query. Your browser does not support the video element. Add results of one query into the IN() statement If we copy cell C2 and select the range of cells from A2:A6, it will add 6 to all the existing values from A2 to A6.1. For example, we have a value of 6 in cell C2. In the below image, we have values from A2 to A6. Shortcut #7 – Paste as Add (ALT + E + S + D) Shortcut #6 – Second Part of the Validation Tab. Now, the result will be like the one below. If we need to paste the same validation from cell A1 to C1, Look into the below image where we have validation of YES and NO. Similarly, we can paste the validation too. We can paste the values, formulas, and format. Shortcut #5 – Paste as Validation (ALT + E + S + N) You can either right-click on the required cell, click on “Insert Comment” & type the comment, use the shortcut key, i.e., Shift+F2, or click on the Review Tab & select “New Comment”. ” Now, we need to insert the same comment Insert The Same Comment In Excel, Insert Comment is a feature used to share tips or details with different users working within the same spreadsheet. For example, look at the below image where we have a comment, “Sum Formula is Applied. Like how we did in the previous example, we can copy and paste only the comments too. Shortcut #4 – Paste as Comment (ALT + E + S + C) But, we need to paste only the cell format, neither the formula nor the value. In the below image, we need to copy cell A5, which contains the formula. Shortcut #3 – Paste as Format (ALT + E + S + T) Even the boldness of the character will not be pasted. It will apply the only formula to the selected cell. Now, copy cell A5, select C5, and press ALT + E + S + F. To avoid that, we must use Paste as Formulas. But, it will change the color of cell C5. Even if we copy and paste, we may get the result. We want to copy the formula from that cell and paste it into cell C5 without changing the color of the cell. Shortcut #2 – Paste as Formulas (ALT + E + S + F) Now, we get the value of 45 in cell 45 without changing cell B8.Press the shortcut keys “ALT + E + S.” It will open the below dialog box.That means character size, the boldness of the font, font name, font color, font size, the border of the cell, etc. When you copy the above image value and paste it into another cell, it copies the entire thing associated with that cell. In general, what happens if you copy a cell and paste it? First, look at the below image. For example, take a look at the below image.

Also, we need to copy and paste only values without bringing anything else.

For example, sometimes we need to copy a cell or range of cells to some other cells or range of cells along with formatting, formulas, etc. Sometimes in Excel, we need to perform some very real, quick things. Lastly, we can use the “ALT + E + S + V” shortcut keys for values only. 'Alt + E + S + V' is the shortcut key for pasting values. Furthermore, we can use the Excel shorcut of paste values Use The Excel Shorcut Of Paste Values Pasting values is a common procedure that allows us to eliminate any formatting and formulas from the copied cell and paste them into the pasted cell. They are available by right-clicking on the target cell and selecting “Paste Special” or by keyboard shortcut as “CTRL + ALT + V.” Else, we can press the “ALT + E + S” shortcut keys. There are various methods to Paste Special in Excel. Paste Special in Excel means we use this option when we want to paste only some aspects of the data rather than the original data.

How to paste values shortcut