Super User Stack Exchange
Super User Stack Exchange

Questions tagged [google-spreadsheets]

Google Spreadsheets is a part of the Google Docs web app suite. Questions about Google Spreadsheets are off topic and should be asked on webapps.stackexchange.com, unless they specifically involve your computer or browser.

Google Sheets (formerly Google Spreadsheets) is part of the Google Docs Editors suite of office tools.

See our sister Stack Exchange site, Web Applications for more focused questions and answers on Google Sheets and other Google Docs Editors applications.

461 questions
81
votes
9 answers

How to create a formula for every row in a column in Google SpreadSheet?

I use three columns. A, B and C. In column C I have a formula every row =A1*(1.6*B1) and then for the next row I have =A2*(1.6*B2) in C2. How can I do so I don't have to type in the new formula in column C for every row? I use it in both Google Docs…
Jonas
  • 26,874
  • 52
  • 105
  • 125
65
votes
1 answer

How to convert a duration into a number of hours in Google Spreadsheets?

Trying to organize a timesheet. I have a cell with a duration of, say, 84:30:00 (84 hours, 30 mins, 0 seconds), which has a number format of "Duration". How can I calculate the decimal number of hours (84.5) from this? The obvious approaches Hour(),…
Athena
  • 1,733
  • 1
  • 11
  • 9
50
votes
3 answers

Pad numbers to specific length in Google Spreadsheet

I have a column with integer numbers like this: 1, 2, 3, 4, 5 and I want to create another column with these values padded to length of three like this: 001, 002, 003, 004, 005. Is it possible to pad string to length in Google Spreadsheet? I wasn't…
Slava Fomin II
  • 782
  • 2
  • 9
  • 20
21
votes
5 answers

How to Label / Tag Items in a Spreadsheet

I'm a novice at spreadsheets, so I hope you'll forgive me if I'm asking a super obvious question. Is it possible to use tags in Excel/Google Spreadsheet? I'm creating a spreadsheet to log all the articles and books I'm reading. Say I'm reading "I,…
nusantara
  • 313
  • 1
  • 2
  • 5
20
votes
1 answer

Equivalent for FILTER() formula in Libre Office

In a Google Spreadsheet, I create a report sheet by entering a formula like this in the top left cell. =FILTER(Sheet1!A2:E, Sheet1!E2:E > 0) This gives me all the rows in the Sheet1 from row 2 downwards where the value in column E is greater…
Keith
  • 568
  • 7
  • 16
16
votes
2 answers

Date based sum in Excel / Google Docs spreadsheets

I have a bunch of rows with a date and a dollar amount (expenses). I want to produce a list of the days of the month and what the balance of the expenses is. So, for example the 5th entry in the list would be 8/5/2008 and the sum of all the…
alumb
  • 1,504
  • 1
  • 14
  • 18
15
votes
1 answer

Smooth Scrolling in Google Sheets

Google Sheets currently scrolls by entire rows and columns, which can be a jarring experience (especially if there are large rows or columns). Anyone know how to make the scrolling smooth?
vancy-pants
  • 259
  • 2
  • 5
13
votes
3 answers

How do I append a character to the end of every line in an Excel cell?

I have a column of Excel cells that's similar to a grocery shopping list and looks as follows: 3 Days Ingredients 2 Apples 1 Jug of milk 3 Bags of mixed vegetables 5 Potatoes Is there a way to append a character such as a comma or semicolon at the…
Keyadun
  • 241
  • 1
  • 2
  • 5
12
votes
9 answers

Can you convert an address to a zip code in a spreadsheet?

Given a column of street addresses with city and state but no zip in a spreadsheet, I'd like to put a formula in a second column that yields the ZIP code. Do you know a way to do this? I'm dealing with US addresses, but answers pertaining to other…
Isaac Moses
  • 672
  • 1
  • 6
  • 16
11
votes
3 answers

How to auto-fill a numbered series WITHOUT a mouse (keyboard only) on Google Sheets

Is there a way to fill down a series using just the keyboard instead of the mouse? This is that function where you highlight a group of cells, then click on the bottom right corner of the highlighted box, and drag down with the mouse to make a…
Joanne
  • 111
  • 1
  • 1
  • 3
10
votes
2 answers

Extracting email from text string in excel/google spreadsheet

I'm looking to extract email addresses from text strings in Google Docs/Excel and email them automatically, where the content of the cells are currently unknown (until updated by user). For example, they might read: Hi, My friend…
Tom
  • 103
  • 1
  • 1
  • 5
8
votes
4 answers

Formula to see if a series of numbers is increasing in value?

I have a spread sheet with thousands of sets of numbers. That is too say, there are ten columns and each column has a number - and there are thousands of rows of these numbers. What I want to do is check whether the numbers on each row is increasing…
Moshe
  • 225
  • 1
  • 3
  • 6
8
votes
2 answers

How to "Round half to Even"?

I need to "Round half to Even" (Bankers' rounding) a number in Excel. So: 4961,25 => 4961 9738,75 => 9739 4934,5 => 4934 4935,5 => 4936 How can I do it? It must also work "online", using Google Sheets (here is a ready sheet).
markzzz
  • 717
  • 3
  • 13
  • 22
7
votes
6 answers

Count substring occurrences within a cell

How can I count the number of occurrences of a substring within a cell? For example: | | A | | 1 |John,John,Tom,David| What formula would I use if I want to return the number of occurrences of "John" in cell A1 (=2)?
johnL
  • 272
  • 1
  • 3
  • 9
7
votes
3 answers

Spreadsheet (Excel, Google Docs etc), extracting value separated by comma

I have a value in one cell that looks like this 4,8,2 Lets say it's in the A1 cell how I can get the inner 8 (the second comma separated value) from this cell into the cell B1 ? =? Tried with =SPLIT(A1, ","), but this splits the values and writes…
astropanic
  • 237
  • 1
  • 9
1
2 3
…
30 31