I have a row of percent values. In the last of the row (Column E) I want the text to appear, that is in the very first row above the values: A B C D E ———————————– foo bar test foobar ———————————– 10% 13% 3% 1% bar ———————————– 1% 13% 30% 1% test ———————————– 9% … Read more
In Google Sheets, GOOGLEFINANCE returns an array of values, like so: The formula is entered in A1 but the result extends into other rows and columns. I would like to “select” (not sure what the exact term is) a subset of this data. For example, I would like to select only the prices, without header … Read more
I have a really complex spreadsheet in Google Docs, and while it works, having the ability to script it a bit (à la VBA in Microsoft Office) would make it a lot cleaner. I heard that this is doable in Google Apps, but I can’t find it in Google Docs. Is this possible? Or is … Read more
I want to bring in data from a separate sheet and filter it. I can get IMPORTRANGE to work like this: =IMPORTRANGE(“URL”,”A:J) But that doesn’t filter. I can only get FILTER to work in the same sheet like this: =FILTER(Sheet1!A:J, C:C=”Yes”) Is there anyway to bring these two functions together and FILTER data from another … Read more
I sometimes double-click on a cell to see the formula or whatever, or I just accidentally start typing in the cell. How do I cancel the edits? Esc and Ctrl+Z don’t work, so I typically hit Enter and then Ctrl+Z, but that seems clunky. EDIT: Chrome on Ubuntu Answer Wow, a year later I had … Read more
I’m on a Macbook Pro, working quite a lot in Google Sheets. I’ve deactivated the F-keys (so it’s not an option to use F2). I can’t find a shortcut for editing a cell with text in it. If it’s an empty cell I can just start typing. But if I want to edit a cell … Read more
I have a Google Sheets document with four columns of data. I have a chart on the right side. When you scroll down to see all the data, the chart scrolls up off the screen. Is there a way to make it static or float? Answer If the chart is fairly simple, you can use … Read more
In Google Sheets, I want to decimal-align numbers without adding trailing zeros in the fractional part. Instead of: I want: +——+ +——+ | 56.0| | 56 | | 27.0| | 27 | | 83.0| | 83 | | 2.4| | 2.4| | 1.2| | 1.2| | 120.0| | 120 | +——+ +——+ The format of … Read more
I have seen this question and altough I face the same problem, the answer to that question is not helpful to my case. I have large spreadsheets which are changed frequently. So, according to the solution accepted to that question, it is hard to duplicate all populated columns and it is cumbersome to edit one … Read more
The usual way to reference a sheet is here but how do you reference a sheet when the sheet’s name is a value in a cell? For example, A1 = “Sheet number two” B1 = A1&”!B4″ Here I want B1 to display the value in ‘Sheet number two’!B4 but it’s not working for me. Any … Read more