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 "...
user avatar
  • 184
15 votes

Does Google Bookmarks show us how many total bookmarks we have?

Yes, you can find out how many bookmarks you have right here. https://www.google.com/settings/chrome/sync sample:
user avatar
  • 151
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 ...
user avatar
  • 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 ...
user avatar
  • 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-...
user avatar
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 ...
user avatar
  • 9,698
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, " ", "_")...
user avatar
  • 6,748
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 ...
user avatar
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 ...
user avatar
  • 51.2k
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 ...
user avatar
  • 149
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 ...
user avatar
  • 131
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: ...
user avatar
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 ...
user avatar
2 votes

Import / Sync Google Calendar Events with Facebook Page?

Zapier has a recipe that can do this. I've just set it up and tested it and it seems to work well. It creates a new Facebook Page Event when a new Google Calendar entry is created. So far, I've only ...
user avatar
  • 129
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 ...
user avatar
  • 531
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, ...
user avatar
  • 430
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 ...
user avatar
  • 41.9k
2 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 -...
user avatar
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 ...
user avatar
  • 11.8k
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 ...
user avatar
  • 9,698
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(...
user avatar
  • 760
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. ...
user avatar
  • 11.8k
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(...) ...
user avatar
  • 4,587
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 (...
user avatar
2 votes
Accepted

From old to new layout in Google books

Both the old and new Google Books have a settings icon (). When you are in the new Books, there is an option to "Go back to classic Google Books." When you are in the Old Books, there is ...
user avatar
  • 4,753
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"),""))}) ...
user avatar
  • 11.8k
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 ...
user avatar
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.
user avatar
  • 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&...
user avatar
1 vote

How do I prevent Google from killing access to sister/brother sites?

Some Google services use top country domains as the default for users out of the US while others don't. Some of these pages don't share the sign in status (use different cookies) with pages with ...
user avatar
  • 41.9k

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