Google-sheets – In Google Sheets, how can paste a copied cell/value into several selected cells at once

google sheets

What I need to do is to first copy a cell (or the value of the cell), then select a number of other cells (not necessarily in a continuous range), then I want to paste that cell or value into all the selected cells at once.

What happens is the value gets pasted only into the first selected cell, and not to any of the others.

How can I do this?

I'm not super familiar with the intricacies of this product. I've tried searching, but maybe I'm not very good at it because I couldn't find anyone with the same problem exactly.

Best Answer

method 1:

select desired cell
press SHIFT + ARROW KEY
- or SHIFT + CTRL + ARROW KEY
and then CTRL + ENTER

method 2:

select desired cell
press CTRL + C
then select multiple cells where you want to paste by holding CTRL
press CTRL + V
- or CTRL + SHIFT + V for values only
- or CTRL + ALT + V for format only
- for more options see image

Related Solutions

Google-sheets – How to use a dropdown menu in a cell to populate other cells with information

See this example spreadsheet. Sheet Countries contains source data (instead of prices and products, I've used countries, population and other data, but the concept is the same). Sheet Dropdown contains the example. In that latter sheet, cell C1 and E1 are dropdown menus (use the Data→Validation… menu to see how data validation works, or look at the explanations at the bottom of this answer).

Then, in cell A2, you have a query that fetches data from the Countries sheet, based on the values present in your dropdown menus. The trick is to build the query string using the string concatenation operator (&). What the query string says is: fetch data from columns A to E of the Countries sheet, where column C is lower than Dropdown!C1 and column E is lower than Dropdown!E1.

Note that you will need to copy the example spreadsheet to play with it (you can only comment the original).

Explanations To set a cell as a drop down menu, select the cell, then use the Data→Validation… menu. For instance, for cell C1 of the Dropdown sheet, you can enter the list of values you want users to select from by setting the Criteria to List of items and then enter comma separated values in the input box right next to it. Other options of this validation menu are self explanatory.

Another common dropdown menu is where you want users to select values from a range within the spreadsheet: list from range As you can see here, the Criteria is now set to List from a range. You enter the range itself by clicking on the grid within the input box, and then by selecting the range of cells you want to use as your selectable items. In the case of our examples, the values come from the sheet Population range where I made some computations to generate a log scale list of values between the smallest country population and the largest.

Hope this helps.

Google-sheets – How to duplicate two cells from a column to rows in a particular order

This can be done with a single array formula such as

={A1:A5, A2:A6}

(assuming the dates you've shown are in the range A1:A6).

If you expect more dates to be added, and don't want to specify the last row, then two separate arrayformulas should be used for two columns: ={A1:A} and ={A2:A}.