Hot answers tagged

16 votes
Accepted

How can I add N more columns?

Select a column where you want to add your N columns (left of there or right of there) Shift-select the N number of columns that you want to add Right-click Click on "Insert N columns on left" or "...
  • 184
9 votes
Accepted

How do I fill out Google applications when their own reCAPTCHA is broken?

I have heard some reports that: Entering the shown text ("reCAPTCHA V1 IS SHUTDOWN") will let you pass. Entering any text will let you pass. But if that's not true, then you'll have to wait until ...
  • 1,404
5 votes

Google Docs doesn't do copy/paste and requires me to install Google Drive

The reason for this is that, for a number of security reasons, browsers have limited capability to interact with the operating system's clipboard. If you think about it, this makes sense as the ...
  • 159
4 votes

Google Docs doesn't do copy/paste and requires me to install Google Drive

The Google Drive web app gets around a security feature on the browser. Without this security feature, a script on any web page you open could grab sensitive data from your clipboard. When you right-...
4 votes
Accepted

Is there a "best way" to send Google feedback?

Below link shows how to send feedback for Google's product: Help improve Google’s products . If you want to send the feedback to the Google photos team click on below link: Welcome to the Photos ...
  • 9,772
4 votes
Accepted

Text result of JOIN is longer than the limit of 50000 characters

Use a query smush, like this: =arrayformula( substitute( transpose( split( query( filter( substitute( substitute(Data!C2:C, " ", "_")...
  • 10.5k
3 votes

How can I add N more columns?

I just figured out a nifty little way to do this. Even if you don't know JavaScript, this should be pretty easy to follow: Answer: Step 1 - Go to the script editor: It will look like this: Step 2 -...
3 votes

How can I add N more columns?

To add N number of Columns > Right Click on the top left corner of the sheet so that it selects the entire spreadsheet > you will see the option to add 1000 Rows and 26 Columns. I believe Google ...
3 votes

How can I change my username on Google Help Forums?

This must have changed as I was just able to change my user name on the Google Voice Help Forum. Here is what I did. While in the forum (e.g. https://productforums.google.com/forum/#!forum/voice for ...
  • 131
3 votes

Login to a website/app without social login buttons

You are absolutely right that this can be confusing sometimes. In case of Uber it is especially weird since the Google search result for 'Uber app login' shows Sign In. Connect with Facebook. or ...
  • 149
3 votes
Accepted

Disabling all Gmail's April fools

No, there isn't. Google has never offered any option to prevent their corporate pranks. Of course, in the past, most have been ones where you actually need to go to a different URL or are something ...
  • 51.7k
2 votes

Google Trends keeps coming up in Chinese

in 2019,using the "http://www.google.com/trends/?hl=en" can direct to english language on google trends,but when you type some words to search it return chinese again. so there is another solution: ...
2 votes

How do I change my username on Trello after I set up my account with my Google account?

So, I had the same problem as Danny. I used my Google login to create a Trello account, and didn't appreciate the 1 tacked onto the end of my username. Surprisingly, the following worked.... Note ...
2 votes
Accepted

Change language of Google websites?

You can change the language for all of Google's products by setting your preferred language at this URL: https://myaccount.google.com/u/0/language To change the display language for Google Accounts, ...
  • 430
2 votes

How and why are Google signing in to my outlook.com account?

This often happens when a Gmail account is set up to "gather" or collect email from Outlook.com via POP or IMAP. It's a quite handy feature as Gmail allows you to pull those messages and have a ...
  • 539
2 votes

How do I let Google know of a problem so they can fix it?

Short answer Use Google Feedback Explanation Google Feedback is the tool that Google includes on many of their web applications to make easier for users send feedback directly to the engineers in ...
  • 43.1k
2 votes
Accepted

Sync Photos and Videos with Google Backup and Sync tool for Windows

By default Google gives 15 GB free space to use, which includes Gmail, Photos and Drive. To backup and sync your photos and videos in there are three options. Two options are unlimited free to sync ...
  • 9,772
2 votes
Accepted

Apply conditional formatting to a blank cell if another cell in the row is not blank

The formula you need is the following: =NOT(ISBLANK($H3))*(ISBLANK(I3)) Please pay attention to the $ sign in front of H3. Using the $ (dollar) sign we "lock" the column and the formatting is ...
  • 12.1k
2 votes

Multiple IF functions on a single cell

Matter is with SEARCH() returning error when failing to find your criteria. To avoid that wrap your SEARCH() in IFERROR() like this: =IF(IFERROR(SEARCH("wheel", A41),),"car", IF(...
  • 795
2 votes
Accepted

Copy/multiply cell contents based on number in another cell

Please use the following =QUERY(ArrayFormula(flatten(IFERROR(SPLIT(REPT(B1:B&"@",A1:A),"@")))),"where Col1<>'' ") How the (undocumented) flatten function work. ...
  • 12.1k
2 votes

Copy/multiply cell contents based on number in another cell

Here is another approach: =ArrayFormula(VLOOKUP(TRANSPOSE(SPLIT(JOIN("",REPT(ROW(A:A)&"@",A:A)),"@",0,1)),{ROW(A:A),B:B},2,FALSE)) How It Works =ArrayFormula(...) ...
  • 4,802
2 votes
Accepted

How can I know whether I am a Google One member?

Well, the first result when I Google’d “google one” was https://one.google.com/about, which seems to indicate that it’s an enhanced / elevated service plan, where you pay money for lots of storage (...
2 votes
Accepted

How do I use an arrayformula to autofill a column in Google Sheets?

AND() is not compatible with ArrayFormulas, you need to find another calculation. Furthermore we cannot use COUNT() because otherwise we would obtain a value that is always valid even if there was an ...
  • 2,216
1 vote
Accepted

How do I use shortcuts on Google web apps which conflict with macOS shortcuts?

Finally found out how to do it: the option which you are looking for is Override browser shortcuts. Go to Help and search for and enable the following option: Override browser shortcuts This option ...
1 vote
Accepted

Backup photos and videos to Google Photos

If you delete a photo or video from your local device which is already backed-up to Google Photos, it won't be deleted from Google Photos. To test this, backup any random photo or video to Google ...
  • 9,772
1 vote
Accepted

Bar chart that counts rows google sheets / Pandemic-like chart

You can use a query like this : =QUERY(A:A,"SELECT A, count(A) group by A order by A desc") Result : Graph :
  • 1,928
1 vote
Accepted

Prevent products I’ve searched for appearing as Facebook ads on other devices

I expected that this only happens via cookies (and other locally stored state) combined with login accounts since IP addresses are commonly shared, including between parents and children, and your ISP ...
  • 2,400
1 vote
Accepted

Populate Last Cell With Query Function in Google Sheet

What you need to get the desired results would be: =QUERY({'Sheet1!'!A1:A,ArrayFormula(IF(LEN('Sheet1!'!A1:A)<>0,REGEXREPLACE(TO_TEXT('Sheet1!'!A1:A),TO_TEXT('Sheet1!'!A1:A),"TRUE"),""))}) ...
  • 12.1k
1 vote

How can I add N more columns?

I couldn't find a way to insert or add more columns to my Google Sheets, so I downloaded the current one, edited it in Excel, and uploaded it back to my drive.
  • 11
1 vote

Is there a "best way" to send Google feedback?

Google is getting increasingly difficult to give feedback to. The location varies by product. Google Sheets Under help, "Help Sheets Improve" Google Docs Under help, "Help Docs Improve&...

Only top scored, non community-wiki answers of a minimum length are eligible