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

learn more… | top users | synonyms (1)

63
votes
6answers
144k 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?
52
votes
4answers
85k 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 ...
48
votes
2answers
98k views

How can I create a fixed column header in Google Spreadsheet like the first sheet?

How can I create a fixed column header in Google Spreadsheet like the first sheet?
31
votes
1answer
40k views

How does one add a new line in a cell in a Google Spreadsheet?

I pressed return to make a new line in a cell of my Google Spreadsheet. That just moved the cursor to the next cell. How does one add a new line in a cell?
29
votes
2answers
52k 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 ...
28
votes
3answers
57k 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 ...
28
votes
2answers
18k 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?
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?
23
votes
6answers
37k 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 ...
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 ...
17
votes
7answers
60k 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?
17
votes
2answers
50k 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: ...
17
votes
2answers
21k 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 ...
16
votes
4answers
38k 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 ...
15
votes
2answers
14k views

Google Docs date in “dd/MM/yy” format [duplicate]

Is there any way to use date in format dd/MM/yy? The Google Docs support only MM/dd/yy and it cause us problems to use it (we can't sort the date column).
14
votes
2answers
15k views

How to group data in a Google Spreadsheet?

I have the following table in a Google Spreadsheet: Name | Value A | 10 B | 100 A | 20 B | 200 C | 1000 How can I create another table based on a query: select name, sum(value), ...
14
votes
8answers
31k 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?
14
votes
4answers
7k views

Multi user filter issue in Google Spreadsheets

When two or more users view the same Google 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 and ...
14
votes
5answers
16k 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 ...
13
votes
2answers
49k 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 ...
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 ...
12
votes
1answer
10k views

How to add days to a date

I'm using a Google Spreadsheet to perform calculations and I'd like to do some simple date math. For example, TODAY() add 7 days. I don't see any functions to do it and some quick stabs in the ...
12
votes
2answers
6k views

Complete reference documentation for Google Spreadsheets formulae?

As a programmer, I find myself somewhat frustrated when trying to use Google Spreadsheets, because there seems to be no definitive description of the syntax that I can use for formulae. For instance, ...
12
votes
3answers
14k views

Display Sheet Name in Google Spreadsheet

Is there any way to display a sheet name as the result of a function in a google doc spreadsheet (exactly like this question, except in gspread)?
12
votes
5answers
51k 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 ...
11
votes
6answers
9k 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: ...
11
votes
3answers
14k views

Auto-updating column in Google Spreadsheet showing last modify date

Trying to figure out a way to have column two auto-update to show a timestamp of the last update. I realize the doc shows a timestamp of the last modification, but we have a lot of clients accessing ...
10
votes
5answers
20k 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 ...
10
votes
1answer
7k views

Sum on condition?

I have set up a form with Google Spreadsheet where I want to collect grocery expenses for different people. How can I sum the expenses for different persons? Each row has a column with the person's ...
10
votes
1answer
15k views

IF OR Statements

How do you do an IF ... OR ... THEN statement in a Google spreadsheet? In PHP I would do this: if($C7 == "U.S.A." || $C7 == "Canada"){ ... How to do the same as a spreadsheet formula? At the ...
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 ...
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...
9
votes
7answers
13k 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 ...
9
votes
1answer
23k 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 ║ ║ ...
9
votes
2answers
2k views

Cumulative Sum without Script

For this question, I've created a Google Apps Script function, that calculates the cumulative sum of a range. Martin Hawksey on Google+ made a comment about a more efficient way of calculating the ...
9
votes
1answer
7k 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?
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 ...
8
votes
4answers
28k views

How do I calculate a time delta in my Google Spreadsheets?

I've got a Google Spreadsheet that looks roughly like this: Date | Start | End | Minutes ------------+-------------+-------------+------------------------- 1/11/2012 | 11:39 ...
8
votes
7answers
7k views

How to calculate weighted averages in Google Spreadsheets?

I have a Google Docs Spreadsheet where products are listed as rows and attributes as columns. Each product's attribute is rated on a scale of 1-10. My last column is an average of these values (i.e. ...
8
votes
2answers
4k views

Link to a cell in a Google Spreadsheet via URL?

One can link to a Google Spreadsheet via key, and via key and worksheet id: https://docs.google.com/spreadsheet/ccc?key=SOME_KEY ...
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. ...
8
votes
2answers
3k views

How to reverse the order of selected rows?

Is there an easy way to reverse the order of selected rows? (Or how about all rows, if that's easier.) Specifically, in this case, there is no column that could be used for sorting to get them in ...
8
votes
2answers
6k views

Google Spreadsheets: format cells as plain text [duplicate]

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 ...
8
votes
2answers
8k 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 ...
8
votes
1answer
586 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| ...
7
votes
10answers
17k views

How to set a Google Docs Spreadsheet cell format to bare text?

I am to store international standard phone numbers (starting with a plus sign followed, usually, by plain numbers) in a Google spreadsheet column. An example of such a phone is +420123456789 When I ...
7
votes
1answer
24k views

Create a column of date in Google Spreadsheet [duplicate]

Possible Duplicate: How to extend series of dates in Google Docs? Is there a way to create a column of date easily with google speadsheets like with Excel ? In Excel, enter a date, hold ...
7
votes
2answers
704 views

Which formula extracts the domain name from an email address (bob@example.com -> example.com)?

Which Google Spreadsheets formula do I use to get the domain part from an email address? Example: bob@example.com → example.com
7
votes
2answers
1k views

Default sheet in Google Docs spreadsheet

Is it possible to mark a sheet as "Default" so that if anyone opens a Google Docs spreadsheet, the corresponding sheet is opened instead of the first one?
7
votes
1answer
33k views

Reference data from another 'spreadsheet' in google docs / drive [duplicate]

Is there a way i can reference data from another google spreadsheet in google docs / drive ? ie. spreadsheet-A, sheet 1, column A is a dynamic reference of spreadsheet-B, sheet 1, column E Im not ...