Questions tagged [google-sheets]
For questions about Google's web application to create and edit spreadsheets on a web browser or app. Don't use it for the Google Drive Excel files editor. Please consider adding data as markdown table to your question; this will greatly increase the chance that you get a satisfactory answer.
8,728
questions
77
votes
15
answers
114k
views
In a Google Spreadsheet, how can I force a row to be a certain height?
In a Google Doc spreadsheet I would like to have each row the same height no matter how much text is in each cell.
I have tried "resize row" but no matter how many pixels I put in, the row ...
- 3,207
2
votes
3
answers
2k
views
How to embed a Google Spreadsheet inside a post in my blog?
I have a public Google Spreadsheet in Google Drive and want to display it within my blog post (people can directly see it, not only a link to the sheet).
How can I do that? Please help!
I'm using ...
- 3,584
115
votes
2
answers
235k
views
How to convert rows into columns in Google Spreadsheets?
I have a spreadsheet in Google Docs with two data rows and lots of columns like so:
Is it possible to easily convert these rows into two columns and lots of rows (obviously retaining all information ...
- 3,748
10
votes
6
answers
30k
views
What are the refresh characteristics of the Google Spreadsheet Import functions?
The imported data is not always up to date with the source pages when I load the spreadsheet. When this happens, F5 refresh does not help. Nor does Ctl-F5. Apparently there is some kind of caching ...
- 219
4
votes
1
answer
11k
views
Figuring out who is the owner of a Google Spreadsheets form
I have noticed that Google spreadsheet form's have URLs in the form of http://spreadsheets.google.com/viewform?formkey=.... I don't see anything that relates to the Google account in the URL. There ...
- 30.7k
2
votes
2
answers
2k
views
Graphs with Google Spreadsheets - collapse data into one 'category'
I have a set of data which is similar to the following:
Groceries 5.00
Groceries 14.75
Groceries 6.37
Dinner Out 43.50
Dinner Out 15.00
I'd like to be able to use this data to create ...
- 297
8
votes
4
answers
13k
views
Creating an online form - by Importing the questions from a spreadsheet? [closed]
I've got a spreadsheet where each row of the first column is a question, and the next 4 columns are the optional 4 answers to that question.
I want to turn these questions into an online form (like ...
- 1,390
3
votes
3
answers
3k
views
Calculated range based upon some criteria
Given this layout:
+--------+ +--------+
| A | B | | A | B |
+----+---+ +----+---+
| 1 | | | 1 | 6 |
| 2 | | | 2 | |
| 3 | | => | 3 | |
| | | ...
- 5,540
19
votes
7
answers
81k
views
Google Docs Time report - How to add hours?
I use a Google Docs spreadsheet to keep track of the time I spend on projects. It's formatted in 3 columns: the time I started, the time I finished, and the total hours spent for that session (...
- 293
20
votes
2
answers
28k
views
How can I change the input format for dates in Google Docs' spreadsheet?
The input string for dates in Google Docs's spreadsheet app seems to be set to en_US, which is quite unnatural to me.
How can I change the input format?
- 1,520
5
votes
1
answer
8k
views
Google Spreadsheets Enter/Return Key Behavior
In Microsoft Excel, the default behavior of pressing the Enter (return) key is this:
If you are in a cell, and tab over as
you input data, at the end of the
series when you click Enter, the ...
- 160
5
votes
2
answers
13k
views
Plot Multiple Graph in Google Spreadsheet
I know how to plot a graph in google spreadsheet. But how to plot multiple graphs, with different X and Y values in Google Spreadsheet?
- 1,415
7
votes
6
answers
36k
views
Is there a way to link emails from Google Sheets?
I'm trying to find a way to link to an email from my Google Sheets. We use our spreadsheet as a way to track bugs, issues, to-dos, and milestone timelines (we've tried other apps, this works best). It ...
- 71
6
votes
6
answers
25k
views
How do I make a field display a calendar for picking a date
Previously, in Google Spreadsheet, I've seen date fields that, when clicked on, display a calender for selecting a date.
How can I reproduce this?
- 303
41
votes
11
answers
159k
views
Is there any way to create a timestamp in a Google Spreadsheet?
I use PSPad as a text editor, which allows you to press Alt + D to insert a timestamp, e.g.:
2010-07-17 23:45:44
Is there a way to do this in a Google Spreadsheet?
- 3,207
4
votes
1
answer
2k
views
Google Docs brings Firefox to a grinding halt
I've found recently that when I open a not-too-large* spreadsheet in Google Docs, within about 5 minutes of leaving it in a background tab, Firefox starts hogging 100% processor time. Closing the main ...
- 171
84
votes
5
answers
95k
views
Embed Google Spreadsheet in Google Document
Is it possible to embed a Google Spreadsheet into a Google Document à la Microsoft Excel and Microsoft Word? How about a chart from a Spreadsheet?
- 52.3k
4
votes
2
answers
2k
views
No force-reload tip on Google Sheets?
So I'm running nightly tasks to generate some custom statistics for my site and copy the statistics in .csv format to separate server via SCP. Then I use these .csv files in Google Sheets to display ...
- 243
1
vote
1
answer
11k
views
Take SUM of colored cells in a column in Google Spreadsheets?
I have a column of numbers, where I've changed the background color of some of the cells to blue. All of the other cells in the column have the regular white background.
Is it possible to create a ...
- 159
203
votes
8
answers
662k
views
How do I link a cell in Google Spreadsheets to a cell in another document? [closed]
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?
- 2,565
39
votes
4
answers
161k
views
How to plot time series graph in Google Sheets?
I know it is possible to plot graph or chart in Google Sheets 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 time ...
- 1,415
1
vote
2
answers
2k
views
Where is a good tutorial to use Google Sheets? [closed]
The help system of Google Sheets is a bit short on detail (to put it nicely).
Are there any good tutorials / documentation to explain to a non-Excel-savvy user how the formulas work, how one should ...
- 5,540
4
votes
2
answers
2k
views
Is there a way to limit a column's data to a list in Google Spreadsheets?
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 ...
- 30.7k
26
votes
8
answers
20k
views
What limitations does Google Sheets have in relation to Microsoft Excel? [closed]
Office licenses are expensive.
What features of Microsoft Office are missing from Google Sheets that would be of value in ordinary personal or business use?
- 1,128
16
votes
4
answers
6k
views
Is there any way to script a Google Docs spreadsheet?
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 ...
- 1,976
74
votes
8
answers
141k
views
How can I set conditional formatting on a particular cell that depends on another cell's value?
In my example I would like to conditionally format column B cells. Those marked with x should be formatted according to value in column A (in the example the value is 1):
A | B
1 | x
2 |
3 |
1 | x
...
- 2,205
58
votes
6
answers
132k
views
ISBLANK() function
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 ...
- 2,205
10
votes
7
answers
29k
views
Function to find distance between cities
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 ...
- 209