This works for other data types too – if you enter a few dates that are a week apart and extend the box, it will keep adding dates that a week on from the last. Numbers will continue with 4, 5, 6 and so on. Google Worksheet Tips Protect your reach: Edit permissions hope it helps and comment below to discuss how useful these Google worksheet tips are or share your own favorite Google worksheet tips. Type 1, 2, 3 into the first few cells, then drag the yellow handle down. Click blank during the start of a new table at the top of the page. It's also a quick way to populate a sheet with repeating numbers. Numbers is smart enough to infer that the references to row 2 should be replaced with references to row 3 in the next cell down, and so on. Like in the example above, select the cell that contains your formula and then drag the yellow handle on the bottom edge down to fill the formula into the cells below it. The quick way to do it is to select a cell then move your mouse to the center of any of its four edges so that a yellow handle appears.
You can quickly copy the values or formulae of cells to other cells, and Numbers is smart about how it does this. After you've filled the formula once though – in row 2, say – you don't have to laboriously enter it for every other row, as you'll discover in the next step. Actually, that would give you MrChristopherPhin, so the formula needs to be =C2&" "&B2&" "&A2 to concatenate in some spaces. In column D you could use the formula =C2&B2&A2 to produce, for example, Mr Christopher Phin. Let's say you have a list of surnames in column A, forenames in B, and titles in C. Note that it's not adding them mathematically – if you have the value 3 in one cell and 4 in another, using '&' would produce the result 34 – but it's handy for grouping stuff. The ampersand symbol (&) has a special function on a spreadsheet, and that's to bring together values from other cells into one.
0 kommentar(er)
