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 ...
- 41
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:
...
- 21
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 ...
- 21
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 ...
- 778
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