I have a monthly spreadsheet that relies on figures from the previous month. I'd like to import these values dynamically rather than cutting and pasting them. Is this possible? How do I do it?
I know it is possible to plot graph or chart in Google Spreadsheet. But the problem with current plotting way is that you can only specify the Y, but not the X. And as such, there is no way to plot a ...
The help system of Google Spreadsheets is a bit short (to put it nicely). Are there any good tutorials / documentation to explain a non-Excel-savy user how the formulas work, how one should use them ...
I'm looking for a way to create a drop-down combobox for a column, so that it easier for data entry. I know about using a form, but are there any other ways to do this in spreadsheet view? For ...
Office licenses are expensive. What features of Microsoft Office are missing from Google Spreadsheets that would be of value in ordinary personal or business use?
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 ...
How can I set conditional formatting on a particular cell that depends on another cell's value? A | B 1 | x 2 | 3 | 1 | x 1 | x 4 | 8 | // X can be any value and is here merely to // mark the ...
Is there any way I can check whether a cell is empty? There is a function ISBLANK() but it returns false when there's a formula in a cell even thought the formula doesn't return anything (or an empty ...
I'm working with Google Docs and want to create a spreadsheet of the following form: Point A Point B Mileage Los Angeles Miami 292100 Palo Alto San Francisco ...