One of productivity apps in Google Drive, that allows you to create and edit worksheets

learn more… | top users | synonyms (1)

3
votes
1answer
3k views

Pass Data to Form to Store in Google Spreadsheet

I am collecting addresses in a Google Spreadsheet using a web form. But I am collecting those addresses for multiple purposes. I would like to store an "identifier" in the spreadsheet which I can pass ...
2
votes
2answers
5k views

Password protect Google Spreadsheet

Is there a way to secure a Google Spreadsheet in Google Docs?
8
votes
7answers
25k views

How to lock/protect cells in Google Spreadsheets

I created very simple spreadsheet application in Google Spreadsheet for my mom. But I really need to lock/protect the cell with formulas so she cannot edit them. Every time I told her to try new ...
3
votes
1answer
4k views

Google Docs question: How do I specify “everything except the top row” as a range?

I have Sheet1, which is automatically being updated via form entries. I'm making Sheet2, which is a self-sorting version of Sheet1 (it intended to be a copy of Sheet1 but sorted by a column). Ideally ...
1
vote
1answer
87 views

How to dash a whole row if a cell is OK?

I have a cell that can be OK, ERROR or WARNING. When it is changed to OK I want to modify the whole row in some way. I was thinking about to dash all cells. Is it possible? Or is there something I ...
1
vote
1answer
657 views

How can I charts based on day and month using dates in google spreadsheet?

I have a Google spreadsheet that has values like 1/1/10 0 1/2/10 43 1/3/10 17 etc. I want to be able to visualize the data on a day-by-day basis and on a month by month basis. I managed to create ...
8
votes
2answers
5k views

Inserting a New Sheet in a Google Spreadsheet

How can I insert a new blank sheet (a new tab) into an existing Google Spreadsheet? I'm able to duplicate those that already exist on the bottom, but I can't find the menu option to insert a sheet. ...
3
votes
1answer
234 views

What would I use to write a formula only once and have it work on multiple sheets? Google Docs

I want to write a formula once in one sheet and have others call that formula and do calculation in their own sheet. I want to do this because calculations need to be done in 100 other sheets within ...
0
votes
1answer
1k views

Embedding an excel like spreadsheet with formula calculations?

I wish to create an Excel-like spreadsheet which gets a few simple inputs (let's say 3 cells with the input of a number), where then a fourth cell will calculate the sum of the square of the three ...
2
votes
1answer
367 views

How can I make tabs show in Google Spreadsheet?

I copy code from an editor into a Google Spreadsheet cell. Unfortunately, it left-aligns the code making it hard to read. However, when I double-click on it to edit it, the tabs are still there ...
16
votes
4answers
37k views

How can I make some data on a Google Spreadsheet auto-sorting?

Let's say I want Google Spreadsheets to automagically sort some data, for example column C. How do I do that? I know that I can manually sort data by right-clicking and selecting Sort data, but this ...
0
votes
2answers
3k views

Laying out dates in Google Spreadsheet charts

I have a Google spreadsheet with measurements made at different dates. How can I make a chart with the dates spread along the x axis properly? The data looks like this 2010-09-01 80 2010-09-02 79 ...
3
votes
1answer
2k views

Why doesn't Google Spreadsheet graphs layout my points correcty?

When I try to make a simple graph of some points in a Google spreadsheet said points does not end up where I want them to in the graph. Using data like this I expect a straight line in my graph: col ...
10
votes
4answers
13k views

Can I change cell padding in Google Spreadsheets?

I don't want to stretch all rows and columns to make them more readable than they are by default...
4
votes
1answer
3k views

Google Spreadsheet: Use cell referencing in “Change Color Based on Rules”

In "Change Color Based on Rules", one can specify the text color to be any color as long as certain rules are followed: My question is, instead of hard-coding the values, can I use cell reference? ...
22
votes
10answers
26k 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 expands ...
2
votes
2answers
2k views

How to display google's 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! [Edit] I'm ...
15
votes
2answers
20k 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 ...
7
votes
4answers
5k 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 ...
4
votes
1answer
3k 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 ...
3
votes
2answers
703 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 ...
5
votes
4answers
2k views

Creating an online form - by Importing the questions from a spreadsheet?

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 ...
2
votes
3answers
822 views

Calculated range based upon some criteria

Given this layout: +--------+ +--------+ | A | B | | A | B | +----+---+ +----+---+ | 1 | | | 1 | 6 | | 2 | | | 2 | | | 3 | | => | 3 | | | | | ...
10
votes
6answers
19k 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 ...
6
votes
2answers
3k 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?
2
votes
1answer
955 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 ...
4
votes
2answers
1k 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?
4
votes
4answers
3k views

Is there a way to link E-mails from Google Docs/Spreadsheets?

I'm trying to find a way to link to an e-mail from my Google Spreadsheet. We use our spreadsheet as a way to track bugs, issues, to-dos, and milestone timelines (we've tried other apps, this works ...
5
votes
4answers
14k 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?
14
votes
8answers
30k 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?
7
votes
5answers
343 views

Web apps for managing financial portfolios [closed]

I've been looking for a decent online portfolio manager for a while and not found anything. I'd like something that: Is UK based, i.e. can price in GBP and can get UK fund prices Can access a large ...
27
votes
2answers
17k 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?
3
votes
2answers
793 views

No force-reload tip on google spreadsheets?

So I'm running nightly tasks to generate some custom stats for my site and copy the stats in csv format to separate server via scp. Then I use these csv files in google spreadsheets to display them in ...
2
votes
1answer
7k 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 ...
62
votes
6answers
141k views

How do I link a cell in Google Spreadsheets to a cell in another document?

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?
7
votes
2answers
11k views

How to Plot Time Series Graph in Google Spreadsheet?

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 ...
3
votes
3answers
1k views

Where is a good tutorial to use Google Spreadsheets?

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 ...
2
votes
2answers
354 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 ...
26
votes
8answers
13k views

What limitations does Google Spreadsheets have in relation to Microsoft Excel [closed]

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?
12
votes
4answers
3k 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 ...
52
votes
4answers
84k views

Google Spreadsheets conditional formatting based on another cell's content

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 ...
28
votes
3answers
56k views

Google Spreadsheets ISEMPTY() formula 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 ...
3
votes
6answers
9k views

Google Spreadsheets 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 ...