Skip to main content
Share Your Experience: Take the 2024 Developer Survey

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.

Filter by
Sorted by
Tagged with
203 votes
8 answers

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?
Jeff Yates's user avatar
  • 2,565
181 votes
3 answers

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), ...
serg555's user avatar
  • 2,185
164 votes
2 answers

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?
David Faux's user avatar
  • 8,069
156 votes
4 answers

How to paste a comma separated string over multiple cells in Google Sheets?

Say I have a string of: l,f,x,a,s,f I would want to paste this every comma-separated value over 6 adjacent cells. How would I do it?
user3046061's user avatar
  • 1,677
151 votes
9 answers

Google Sheets formula for "if contains"

I'm trying to figure out how to identify IF a list of items in one cell containing a value or string. EXAMPLE Cell A1 contains sites, sheets, docs, slides. I want cell B1 to display a 1 'if' cell A1 ...
Mr. B's user avatar
  • 2,867
123 votes
4 answers

How to check if value is in range of cells?

In a Google Sheets spreadsheet, I want to check if the value of a cell exists in a range of cells. How can I do this? Just like you would be able to do "if value in list_of_values" in Python ...
Javaaaa's user avatar
  • 1,385
119 votes
3 answers

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?
user avatar
115 votes
2 answers

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 ...
Jonik's user avatar
  • 3,788
111 votes
14 answers

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

I've got a Google Spreadsheet that looks roughly like this: Date | Start time | End time | Minutes ------------+-------------+-------------+----------- 1/11/2012 | 11:39 | 12:41 ...
Stefano Palazzo's user avatar
96 votes
10 answers

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

Let's say I want Google Sheets 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 is ...
user avatar
91 votes
20 answers

How to prevent cut and paste data changing references in formulas?

Google Sheets 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 ...
grahamparks's user avatar
  • 1,026
85 votes
6 answers

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 ...
Sam Bisbee's user avatar
84 votes
5 answers

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?
ale's user avatar
  • 52.7k
80 votes
7 answers

Is it possible to add a checkbox/button equivalent?

What I'm looking for is a one click enable/disable or toggle in some form. The closest I've come is manually editing a cell to enter a 0 or 1, but I'm hoping there's a nicer pattern. I know there's ...
dlanod's user avatar
  • 1,068
79 votes
2 answers

Summing a column, filtered based on another column in Google Spreadsheet

I have the following data in a Google Spreadsheet: +------+---------+ | Time | Include | +------+---------+ | 0:30 | No | | 1:00 | Yes | | 0:30 | Yes | | 0:30 | No | | 0:30 | Yes ...
xylar's user avatar
  • 1,895
77 votes
15 answers

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 ...
Edward Tanguay's user avatar
74 votes
8 answers

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 ...
Robert Koritnik's user avatar
71 votes
14 answers

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 ...
Ivan's user avatar
  • 2,067
69 votes
13 answers

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: ...
Senseful's user avatar
  • 31.2k
69 votes
3 answers

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: ...
JBWhitmore's user avatar
67 votes
6 answers

Formatting a cell with word wrap without switching modes?

How can one format a cell to have word wrap in Google Sheets? 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 if you ...
leeand00's user avatar
  • 2,213
67 votes
5 answers

Forcing uniqueness in a Google Spreadsheets column

I have created a Google spreadsheet (acting as a database) that has numerous columns, name being one of them, and I wanted to make sure the name field is always unique and no row can be created if the ...
user avatar
65 votes
15 answers

Shortcut to insert new row in Google Spreadsheets?

Is there a way to do this without using the menu? I have seen references to ctrl + space and ctrl + +, but this no longer works (zooms in and out in Google Chrome)
Damon's user avatar
  • 807
65 votes
8 answers

How to group data by month in Google Sheets

I have a Google Sheet which contains various metrics for each day. Each day has it's own row: day | cost | impressions | clicks | conversions 2014-02-01 | $45 | 3,540 | 80 | 5 2014-...
Bogdan's user avatar
  • 823
64 votes
5 answers

Sum values with same name

I have a Google Sheets with a long list of names and amounts. Many of the names are duplicates. For example: John | 10 Bill | 2 Susan | 3 Frank | 4 Sally | 10 John | 2 Susan | 2 John | 3 Is ...
peter's user avatar
  • 649
63 votes
5 answers

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?
user12181's user avatar
  • 749
61 votes
5 answers

Link to a cell in a Google Sheets via URL?

One can link to a Google Sheets via key, and via key and worksheet id: Is ...
miku's user avatar
  • 1,836
58 votes
6 answers

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 ...
Robert Koritnik's user avatar
56 votes
5 answers

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 five shares ...
spinlock's user avatar
  • 671
51 votes
6 answers

How to export a filtered set of rows from a Google Spreadsheet?

Is it possible, when exporting a Google Spreadsheet into a CSV, to apply this operation only to filtered set of rows? I need to get in CSV exactly the rows which are visible on the sheet after a ...
Stan's user avatar
  • 619
50 votes
3 answers

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 ...
Jonik's user avatar
  • 3,788
49 votes
13 answers

How to specify the entire sheet as range in Google Sheets?

The best workaround I have found so far is: worksheet_name!$A$1:$YY but ideally I would like to be able to simply write, e.g.: worksheet_name! So, does anyone know: is there a syntax for ...
user avatar
48 votes
10 answers

Stop a '+' from generating a formula

I'm having a bit of a struggle. I'm creating a spreadsheet which uses plus signs (+) regularly. I want a semi-permanent fix for +'s turning into addition formulae.
David Wheatley's user avatar
47 votes
6 answers

Hot keys to switch between tabs?

Does anyone know if there´s a shortcut to switch between tabs in Google Spreadsheets? If you use CTRL+PgUp / CTRL+PgDown like in Excel you switch between Chrome or Firefox's tabs instead.
elunicotomas's user avatar
  • 1,793
46 votes
4 answers

Fill value in multiple cells in Google Sheets

In MS Excel, after selecting a range of cells it is possible to enter a value and press CTRL+ENTER to have that value set in all selected cells. Is there a keystroke in Google Spreadsheets that would ...
Cristian Lupascu's user avatar
45 votes
6 answers

How can I automatically set "last updated" cell in row Google Docs Spreadsheets?

How can I automatically set "last updated" cell in row Google Docs Spreadsheets ? I want to create a column where the cells' value will be automatically set to when that row was last amended. Is this ...
cwd's user avatar
  • 814
45 votes
4 answers

Add 3 hours to Date value (DD/MM/YYYY 00:00:00)

I have cells with dates in this format: DD/MM/YYYY 00:00:00 and I want to add 3 hours because I'm in a different GMT zone. Is possible to use dates in a formula? Something like: 30/12/2012 22:15:00 ...
Santiago's user avatar
  • 561
44 votes
7 answers

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 ...
Phira's user avatar
  • 551
44 votes
3 answers

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 ...
RichGonzalez's user avatar
43 votes
6 answers

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 ...
Jacob Jan's user avatar
  • 23k
43 votes
3 answers

How to turn off Insert/Overwrite in Google Spreadsheets

When editing text in Google Spreadsheets, in the formula bar, or editing the name of the sheet, overwrite is toggled, and pressing the insert key (numberpad or 'regular' insert key, numlock active or ...
CWilson's user avatar
  • 1,159
43 votes
5 answers

Display sheet name in Google Spreadsheets

Is there any way to display a sheet name as the result of a function in a Google Spreadsheets (exactly like this question, except in Google Sheets)?
oldrobotsneverrust's user avatar
43 votes
5 answers

How to save temporary variables in Google Sheets formula?

I'm trying to create a formula in a Google spreadsheet which looks like this: if (x < 0, x + 1, x) It means if x is smaller than 0, return x + 1, else return x. However, x itself is an ...
Pacerier's user avatar
  • 6,193
41 votes
11 answers

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?
Edward Tanguay's user avatar
41 votes
4 answers

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 ...
Graviton's user avatar
  • 1,445
41 votes
1 answer

How to see which formulas reference a given cell in Google Sheets?

Is there a way to see which cells reference a given cell in their formulas, in Google Sheets? For example, if cell C1 contains =SUM(A1:A5), and cell D1 contains =SUM(A5:A8), I'd like to somehow be ...
trusktr's user avatar
  • 561
40 votes
6 answers

Google Spreadsheets automatically removes leading zeroes

I have a column comprised exclusively of numbers. Whenever I add 050, the sheet automatically changes it to 50. I have tried prepending a space, but it makes no difference. What can I do to avoid ...
codeandcloud's user avatar
40 votes
1 answer

How to sum only visible cells on Google Sheets?

As per question title, how to sum only the visible cells on Google Spreadsheets?
Weslei's user avatar
  • 1,325
39 votes
10 answers

How to insert the current date into a Google Spreadsheet?

I've got a spreadsheet in Google Drive and one column is meant for the date the entry is made. Is there a button to do this? I'm aware of the functions =NOW() and =TODAY() but their description says "...
Celeritas's user avatar
  • 3,528
39 votes
3 answers

FILTER(condition OR condition) syntax?

I am using FILTER() to display a value from Sheet 2 where the Name columns match. My problem is where I want: =FILTER(Sheet2!A:F, Sheet2!A:A="Combat Medic" OR Sheet2!A:A="Universal") as OR results ...
Rushmik's user avatar
  • 431

2 3 4 5