All Questions

Filter by
Sorted by
Tagged with
4 votes
2 answers
2k views

How to share a Google Sheets demo spreadsheet

I find a lot of -especially new- users on the site are having difficulties on sharing a demo sheet so they can be easily helped if any at all. So, what is the right way to share a demo test sheet?
marikamitsos's user avatar
  • 12.6k
54 votes
2 answers
4.9m views

How do I recover my Google account, password, or username?

Google Account Recovery Questions This is the canonical target for Google Account questions about recovering usernames and passwords, as well as problems logging in for other reasons. For example: I ...
Vidar S. Ramdal's user avatar
115 votes
6 answers
158k views

How can I search for a keyword with special characters in Google Search?

I want to search for what += means, but Google won't return any documents. Also when I come across some PHP code I don't understand I can't search for the keywords as written. How can I search for ...
ChrisF's user avatar
  • 8,959
15 votes
2 answers
29k views

How to know if Google Sheets IMPORTDATA, IMPORTFEED, IMPORTHTML or IMPORTXML functions are able to get data from a resource hosted on a website?

Google Sheets has several import functions IMPORTDATA IMPORTFEED IMPORTHTML IMPORTXML Sometimes the above functions returns errors like #N/A Imported content is empty and would like to be sure that ...
Rubén's user avatar
  • 44.6k
1 vote
1 answer
2k views

Finding the longest time duration in Google Sheets

I'm trying to find the longest time value (hh:mm:ss) and I'm looking for it in column I, starting at row 5. I've already tried using the LARGE function but that outputs a decimal, not a time. =LARGE(...
Marcus's user avatar
  • 21
97 votes
3 answers
38k views

How to search the internet for terms with special characters [closed]

As I learnt from this post, Google has no ability to search for special characters. Let's say I want to search for ss!. Are there any other search engines that can achieve this? Please do not propose ...
Mehper C. Palavuzlar's user avatar
37 votes
10 answers
51k views

Get e-mail addresses from Gmail messages received

How can I export a list containing e-mail addresses for everyone that has sent me an e-mail? I have all of the messages archived.
Brad's user avatar
  • 539
203 votes
8 answers
662k views

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
74 votes
8 answers
141k views

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
90 votes
11 answers
17k views

Is there a way to remove sites permanently from (my personal) Google search results? [duplicate]

I regularly find sites that copy content from elsewhere (mailing lists, etc) while not providing any added value. Quite to the contrary, they are pretty heaped with ads. I'd like to remove those ...
David Schmitt's user avatar
33 votes
4 answers
25k views

Why does Google not consider dot in usernames of Gmail addresses?

E.g.: If your Gmail ID is [email protected], it considers this the same as [email protected]. Why is this so?
Srinivas Tamada's user avatar
13 votes
3 answers
82k views

Is it possible to recover an email that has been clicked "delete forever" in the trash folder?

Is it possible to recover an email that has been clicked on "delete forever" in the trash folder? I have accidentally clicked delete forever for an email but now I need to recover it.
Sarawut Positwinyu's user avatar
42 votes
4 answers
310k views

How can I get around giving my mobile phone number to Google?

When I want to register an account with Gmail now, it says "Google will send a text message containing a verification code to your mobile phone." I don't want to give Google my mobile phone number!! ...
barlop's user avatar
  • 3,004
22 votes
3 answers
66k views

Google sheets split multi-line cell into new rows (+ duplicate surrounding row entries)

I'm compiling a database of business address info, including key staff for each business. The Google spreadsheet I've inherited for this project includes a column for 'key staff' (in column B), with ...
kirk tab's user avatar
  • 331
103 votes
8 answers
146k views

Wildcard search in Gmail

Is wildcard search possible in Gmail?
kristof's user avatar
  • 1,189
44 votes
3 answers
106k 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 ...
RichGonzalez's user avatar
27 votes
5 answers
19k views

How can I access google.com outside the US? [closed]

I live in the UK, and whenever I visit google.com I am redirected to google.co.uk, but I want to see my website's rankings on the US version (I presume the results are different). Is there a way to do ...
Gelatin's user avatar
  • 5,128
2 votes
2 answers
298 views

Where to find a list of Google search operators?

I heard once that there are some search keywords or operators that google could use to enhance the search results. One of them was "NEAR"... Say if I search "make" NEAR "great ...
serge's user avatar
  • 271
110 votes
14 answers
278k 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 time | End time | Minutes ------------+-------------+-------------+----------- 1/11/2012 | 11:39 | 12:41 ...
Stefano Palazzo's user avatar
62 votes
12 answers
33k views

How can I sort emails in Gmail by size?

Google has started to warn me that I am almost out of space in my Gmail account. How can I sort my messages by size to identify any expendable large emails in my account?
Dave Hunt's user avatar
  • 2,179
41 votes
11 answers
159k 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?
Edward Tanguay's user avatar
16 votes
2 answers
20k views

Refer to Sheet with value in Cell?

The usual way to reference a sheet is here but how do you reference a sheet when the sheet's name is a value in a cell? For example, A1 = "Sheet number two" B1 = A1&"!B4" Here I want B1 to ...
E.Beach's user avatar
  • 263
13 votes
7 answers
44k views

Send a copy of outbound messages to another address

Is there a way to have a copy of any message sent from a Gmail account sent to another address? I've got any messages coming to my address copied to another (see this question for one solution, ...
Doug Harris's user avatar
224 votes
12 answers
56k views

Turning off Google search results indirection

In Google search results, in Firefox or Chrome, I get URLs that go through Google and not directly to the target site. For example, at http://www.google.com/search?q=foo the first result is http:/...
Gilles 'SO- stop being evil''s user avatar
98 votes
28 answers
16k views

How do I download a YouTube video?

How do I download a YouTube video? I have used various solutions in the past that do not seem to work any longer (KeepVid and various Greasemonkey scripts). Is this just no longer possible?
Alex B's user avatar
  • 1,250
93 votes
10 answers
346k views

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
42 votes
6 answers
37k 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 ...
Jacob Jan Tuinstra's user avatar
17 votes
1 answer
51k views

In Google Sheets how do I duplicate a sheet along with its permission

In a Google Spreadsheet called Attendance there is a sheet called Template. The user duplicates this sheet, renames the sheet with current date and uses this sheet to mark attendance for students. The ...
Arvind's user avatar
  • 433
12 votes
1 answer
2k views

Google Drive storage mismatch

I have a paid 100GB Google Drive plan. It is reporting that I am at 99% capacity. According to the the storage both within the desktop and web application, I have used 90.53GB within Drive. My Drive ...
port5432's user avatar
  • 223
152 votes
4 answers
70k views

Is it possible to create a Gmail filter that works on headers other than From, To, Subject?

I've forwarded one of my really old email addresses to Gmail. I'd like to create a filter so that any mail to that old address is always labeled properly in Gmail. I can create a Gmail filter with ...
Chris W. Rea's user avatar
  • 2,617
86 votes
7 answers
57k views

In what order are filters processed in Gmail?

If I have multiple filters that match the same email do they all get processed? If so, in what order are they processed? What if the first filter matched modifies the email to make it match (or no ...
Senseful's user avatar
  • 30.7k
21 votes
7 answers
78k views

Can I add an autoincrement field to a Google Spreadsheet based on a Google Form?

Is it possible in Google Forms to give a unique value to each row it inserts into the spreadsheet as well as the timestamp?
Toby Allen's user avatar
21 votes
3 answers
51k views

Cell reference with colour formatting

Is it possible to reference a cell in Google Sheets so that cell where it gets displayed also displays it using the same text and cell colour formatting? =A1 Will only reference cell's value. But if ...
Robert Koritnik's user avatar
21 votes
4 answers
72k views

Extract the link text and URL from a hyperlinked cell

Suppose I have a hyperlink in cell A1: =hyperlink("stackexchange.com", "Stack Exchange") Elsewhere in the sheet, I'd like to have formulas that get the link text and URL from A1, separately. I found ...
user avatar
19 votes
1 answer
37k views

How do I protect my Google/Gmail account?

I have seen lots of horror stories of people who have lost control of their Google account, especially Gmail. How can I prevent the same thing from happening to me? What steps can I take to protect ...
ale's user avatar
  • 52.3k
8 votes
5 answers
11k views

Split a column of strings with a single formula returning an array

I have a column of strings like this: +---------+ | a bb | | ccc d | | ee ffff | +---------+ (exactly one space in each string), which I'd like to split by the space into two columns: +-----+-...
user avatar
5 votes
3 answers
9k views

Recalculate google sheet on demand:

I have the following formula in a sheet: =if(E1="HOLD",,query(Cust_Orders!B6:Z5000,"Select Y,G,I,H,K where H>0 ")) With E1 being a drop down with values HOLD and FETCH The recalculation when I ...
Sherwood Botsford's user avatar
4 votes
3 answers
7k views

Forms Data Manipulation In Google Sheets

I'm trying to develop a solution using Google Forms with Google Sheets that will collect Google Forms data and then automatically divide that one form submission's data into multiple rows of data in ...
Mr. B's user avatar
  • 2,857
2 votes
1 answer
4k views

Transpose Ranges repeated by row

I would like to convert several range of columns into rows, and keeping the association to the original col/row source Sample source sheet --------------------------------------------------- | Data ...
Fernan's user avatar
  • 43
30 votes
4 answers
6k views

Can Gmail automatically base "send from" address on the "to" address?

In short: In Gmail, is there a way to let the "send from" address change automatically depending on which of my accounts it was sent to? In long: I recently joined a team (of developers) and they ...
joon's user avatar
  • 499
15 votes
6 answers
18k views

Why on the first page Google says there are thousands of results but on the last page there are less than a hundred?

Why on the first page Google says there are thousands of results but on the last page there are less than a hundred? That's kind of a recursive Google Search that should be self-explanatory. It did ...
cregox's user avatar
  • 1,383
12 votes
1 answer
178k views

Making tags visible when using a Tumblr theme that doesn't show them

I have just created a Tumblr blog using the Fluid theme. After creating a new post, I added a few tags, but then I noticed that the tags do not show up along with the post. I tried searching for an ...
missingfaktor's user avatar
7 votes
3 answers
40k views

Unable to parse query string for function Query, when using IMPORTRANGE

This is the problem I'm seeing: Error - Unable to parse query string for function QUERY parameter 2: NO_COLUMND The formula is of the form: =query(importange("...", "Sheet!A:V"), "select D where ...
jas9531's user avatar
  • 107
2 votes
1 answer
6k views

Dynamic date range query

I'm trying to create two cells that will update my query: A >= date"A1" and A <= date "B1". My goal is to create a search page for the data, where the end user could insert a date or the =today() ...
Charles's user avatar
  • 21
139 votes
44 answers
115k views

Hidden features of Google Search

What little known tips and tricks do you have for searching on Google? Please note that this question exists because it has a high level of significance, but it is not considered a good, on-...
87 votes
6 answers
152k views

How to restrict a Google search to results of a specific language?

How can I restrict the results of a Google search to only a specific language? Is there an operator like language:english?
user avatar
84 votes
5 answers
95k 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?
ale's user avatar
  • 52.3k
77 votes
15 answers
114k 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 ...
Edward Tanguay's user avatar
72 votes
3 answers
265k views

How to remove accounts from "Choose an account" list in Google sign in?

When signing in with Google (OAuth), it shows a list of accounts it already knows about. How can I remove some accounts from this list? I know I can nuke all of them by deleting all cookies, but I'd ...
Kornel's user avatar
  • 823
59 votes
7 answers
98k views

See all shared items in Google Drive

In Dropbox there is a place you can see all the shared items in your account (i.e., all the items you have granted others access to). Is there a similar feature in Google Drive? I'm not only trying ...
sam's user avatar
  • 6,833

15 30 50 per page
1
2 3 4 5
65