Part of the Google Docs suite, a web app that allows you to create and edit worksheets
34
votes
3answers
36k 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
6answers
62k 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?
23
votes
8answers
7k views
What limitations does Google Spreadsheets have in relation to Microsoft Excel
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?
20
votes
3answers
19k 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 ...
16
votes
7answers
10k 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 ...
13
votes
2answers
5k 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?
12
votes
8answers
15k 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?
12
votes
3answers
2k 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 ...
11
votes
3answers
25k views
Conditionally formatting a cell based on another cell's value in Google Spreadsheet
I did some searching on this and came across this post
However, this solution uses an onEdit() trigger. I would like to see a solution that uses a formula approach, so in the OP's example from that ...
9
votes
5answers
8k 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 ...
9
votes
2answers
15k views
Is it possible to add a checkbox/button equivalent to a Google Docs spreadsheet?
I know there's no checkbox functionality in a Google Docs spreadsheet but I was wondering if there's a way to get equivalent functionality somehow. What I'm looking for is a one click enable/disable ...
8
votes
5answers
5k views
How to remove answers from a Google form?
I wanted to tabulate our lunch break hearts scores on a Google form, so I sent it to the guys I play with and one of them entered his name as winning 20 times and I want to get rid of that. I removed ...
8
votes
2answers
10k views
How does one add a new line in a cell in a Google doc spreadsheet?
I pressed return to make a new line in a cell of my Google docs spreadsheet.
That just moved to the next cell. How does one add a new line in a cell in a Google doc spreadsheet?
8
votes
2answers
1k 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.
...
8
votes
3answers
2k views
Google Docs Spreadsheet - Multiuser filter issue
When two or more users view the same Google Docs spreadsheet and one of them filters the data by a column, that filter is immediately applied for the other users as well.
Is there a way to avoid this ...
7
votes
3answers
23k views
How to alter text orientation to vertical in Google Spreadsheet document?
Using MS Excel I can go to Format of the cell and choose the text orientation from horizontal to vertical fairly easy. How do I alter text orientation to vertical in Google Spreadsheet document?
7
votes
3answers
13k views
How can I make some data on a Google Spreadsheet auto-sorting?
Let's say I want Google Doc to automagically sort some data, for example Coloumn C. How do I do that?
I know that I can manually sort data by right-clicking and selecting "sort data", but this is not ...
7
votes
2answers
14k views
Link to specific sheet in Google spreadsheet
I have a complicated Google spreadsheet with many sheets and a table of contents. Is there some way to create a link to the sheet names so that with a click one can go directly to the sheet? That is: ...
7
votes
1answer
6k 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
2answers
4k views
Text to columns conversion in Google Spreadsheets
How do you do a text-to-columns conversion in Google Spreadsheets?
For example, I have the following data string in one cell:
5,233,6,2,6,7,2,2,6,6
I want to break it apart by the comma separator ...
7
votes
4answers
3k views
How to pass a range into a custom function in Google Spreadsheets?
I want to create a function which takes in a range... something like:
function myFunction(range) {
var firstColumn = range.getColumn();
// loop over the range
}
A cell would reference it using:
...
7
votes
5answers
308 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 ...
7
votes
1answer
196 views
How do I decimal-align numbers in Google Sheets
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| ...
6
votes
6answers
18k views
How to lock/protect cells in Google Apps?
I created very simple spreadsheet application in Google Apps (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 ...
6
votes
3answers
14k views
Google Spreadsheet formatting a cell with wordwrap without switching modes?
How can one format a cell to have wordwrap in Google Spreadsheets?
I've tried Shift+Enter, but that doesn't seem to work.
One thing I know works is to place the Spreadsheet into List Mode and then ...
6
votes
1answer
8k views
How do I lookup a value from another sheet in Google Docs?
I have a page which looks like this:
╔═══╦════════╦══════╦═══╗
║ A ║ B ║ C ║ D ║
╠═══╬════════╬══════╬═══╣
║ 1 ║ User A ║ 144 ║ ║
║ 2 ║ User B ║ 5478 ║ ║
║ 3 ║ User A ║ 2156 ║ ║
...
6
votes
1answer
7k views
How to easily select multiple cells in Google Spreadsheets?
How do I select multiple cells in Google Spreadsheets (non related cells, other cells between them)? In MS Excel I just press Ctrl and click on all the cells, in Google Spreadsheets it doesn't work. ...
6
votes
2answers
4k views
Sum of all cells in Google Spreadsheet where matching row fits a value
I want to return the sum of all cells in ColumnA only if the value of a cell on the same row is equal to a specific value.
For example, sum C4 if D4 = "Bob". Assuming there are six rows whereby ...
6
votes
2answers
379 views
Analyse frequencies of date ranges in Google Spreadsheet
I have a Google Spreadsheet where I would like to compute occurrences of date ranges. As you can see in my sheet, there is a column date_utc+1 which contains almost random date data.
What I would ...
6
votes
1answer
3k views
Disable Default Word Wrap in Google Spreadsheets
Does anyone know how to make it so that Word Wrap is OFF by default in Google Spreadsheets?
6
votes
3answers
411 views
Sorting data in Google Spreadsheet by cell entry
I have a Google Spreadsheet that lists various events. Students have entered their name next to events that they would like to sign up for. It looks like this:
Each student may sign up for more ...
5
votes
4answers
6k views
In a Google spreadsheet, how can I refer to two different columns in a COUNTIF function?
I'll try my best to explain. Say I've got a sheet that looks like this (in this contrived example, let's say I'm sending marketing emails to various people, I know their ages and zip codes, and I ...
5
votes
2answers
875 views
How do I link text to a URL in a Google Docs spreadsheet? [duplicate]
Possible Duplicate:
How do I add a hyperlink to a cell in Google Spreadsheets?
When I paste a URL into a cell in a Google Docs spreadsheet, it turns into a nice blue, underlined hyperlink. ...
5
votes
3answers
4k views
Build a cell reference without knowing Row # (number)
This can't be a more basic spreadsheet question but I have always been a SQL kinda guy...
How do I build a formula where a value will be pulled from another column on the current row. Can't be the ...
5
votes
2answers
4k 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...
5
votes
2answers
3k 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 ...
5
votes
2answers
985 views
Google Spreadsheet Comments
I have a Google Spreadsheet with several boxes with the little orange triangle indicating a comment associated with that cell. Unfortunately, I haven't made any comments, so cannot delete these ...
5
votes
1answer
1k views
Google Spreadsheets: format cells as plain text
I'm gathering some data in a Google Spreadsheet, there's a column for phone numbers and when trying to enter a phone number (e.g., +54 11 4785 7992) the spreadsheet automatically tries to make a ...
5
votes
1answer
945 views
Using data from another sheet in Google Spreadsheet
I'm trying to write a SUM function in sheet B, summing all the data from sheet A in specific rows. I can't find a good explanation of how to do this.
5
votes
1answer
171 views
Including option descriptions for a Google Docs Spreadsheet form
Usually, the options for a form are pretty self-intuitive, but sometimes, you need to explain each of the individual options. In close proximity to the actual question. However, the options for a ...
5
votes
3answers
5k views
Adding a datepicker in Google Spreadsheet
Is it possible to insert a datepicker in every cell of a column in Google Spreadsheet so that anyone can click (with a single click) on that cell and get a datepicker calendar to select a date?
5
votes
1answer
670 views
How to label points in a scatter plot in Google Docs
I've tried using the built-in scatter plot chart, and the Google scatter plot gadget. I haven't been able to figure out how to get either one to allow me to label the points in the chart. I have data ...
4
votes
3answers
6k views
Alternating colors for lines in Google docs spreadsheet
I have a shared Google spreadsheet where several users have already filled out parts.
It would be useful to have alternately colored lines to facilitate correct placement of additional data.
Is ...
4
votes
3answers
4k views
Google Spreadsheet: How to prevent cut and paste data changing references in formulas?
Google Docs has a feature where if you have a reference to a data cell in a formula, and you cut the data from that cell and paste it in a new location, the reference in the formula is updated to ...
4
votes
3answers
8k views
Can I add an autoincrement field to a Google Spreadsheet based on a Google Form?
I use a Google Form to retrieve feedback from our customers. I then download this info into our offline system.
Is it possible in Google Form to give a unique value to each row it inserts into the ...
4
votes
1answer
312 views
How Do I Create a Google Spreadsheet Formula to SUM data based on two variables
DATA SECTION:
So I have data in one sheet like this:
TYPE AMOUNT YES/NO
Pig 20 Y
Pig 30 N
Pig 10 Y
Cow 20 Y
Cow 30 N
Cow ...
4
votes
1answer
465 views
Generating Google Spreadsheet hyperlinks from cell contents
I have a column of cells in a Google Spreadsheet with values such as:
37683
36583
38637
32391
What I would like to do is generate a hyperlink for each cell like:
http://mywebsite.com?id=xxxxx
...
4
votes
2answers
5k views
How to sum values in a range of dates in Google Docs Spreadsheets?
I have a Google Docs spreadsheet in the format below — here's an example.
Column A → Dates
Column B → Numbers
I'd like to sum values in column B in a range of dates in column A.
Example:
...
4
votes
1answer
196 views
Retrieve a cell having a column and a row header in Google Spreadsheets
I have a spreadsheet in Google Docs like this:
Johan Mark Gil Pablo
Course 1 45 50 80 50
Course 2 250 300 50 270
Course 3 19 50 ...
4
votes
3answers
2k views
How can I get GoogleFinance to return only the historical price of a stock and not an array?
I'm trying to figure out the cost basis of some stock that I sold last year and I can't quite get GoogleFinance to do what I want. The stock was purchased through a DRIP so there are about 5 shares ...
