Reputation
4,595
Top tag
Next privilege 5,000 Rep.
Approve tag wiki edits
Badges
8 21
Newest
 Vox Populi
Impact
~326k people reached

Jul
24
comment Best way to migrate Google Account to another
Sorry, I don't know about those ones. Hopefully someone else can comment about them - or maybe searching their help for the phrase "transfer" might yield something.
Jul
23
comment How do I get my Twitter direct messages back?
What has caused you to lose them? Why can you not just log in to Twitter and see them?
Jul
16
comment How to output data from Column A and Column B to Column C automatically in Google Sheet
You can put an arrayformula into the first cell, eg =arrayformula(A2:A9&B2:B9) Personally I don't like them, I would rather take responsibility for the formula in each cell myself. But some people do.
Jul
15
comment Google Docs: Textbox via Drawing blurry / Alternative element for absolute positioning?
In principle, using a drawing programme to create an invoice just sounds wrong. Why are you using a drawing, rather than a spreadsheet (if you want calculations) or a document? (I'm sure there's a reason, but I'm not clear what it is from your question.)
Jul
15
comment Google Docs: Textbox via Drawing blurry / Alternative element for absolute positioning?
You have said "The header shouldn't grow with the information, because the information takes some space (and is taller than the header)." - but really you need to say what should happen here. Are you wanting the header to be a scrolling text-box? or?
Jul
13
comment How can I insert a cross-reference to a figure in Google Docs?
What exactly do you mean by a Figure? I cannot see that as something that can be inserted in Docs. I was thinking that perhaps you meant something that was labelled (eg "Figure 10") with a Caption (as per Word), but cannot see thing a option to do that.
Jul
10
comment How do I organise my data in Google SpreadSheets
No, you can use a pivot table, and select which three months to display.
Jul
3
comment How do I organise my data in Google SpreadSheets
There is no problem with having duplicate rows for each persons name. If you put the data into format (what I have described), then you can filter on any column, any time you need to. And you can also use other features like pivot tables to make summaries that only have one row for each person, and put other fields (like Month) into the Columns section. But the way your data is organised now, you cannot use any of these features.
Jun
26
comment Increase in photo number when uploading in Google photos
Do you have any other image files on the compute, generated from other things than photographs?
Jun
16
comment How to highlight an entire route or way on an online map?
Google Maps - I've added a clarification tot he answer now.
Jun
9
comment How do I separate two accounts on the same Google Mail?
How do you choose which Google account you are signing in to? I know YouTube can be different, but for Google accounts in general, you log in using the account name, which looks like an email address.
Jun
5
comment How can I modify a photo's date on Google Photos?
Re the date showing as 1970 in PWA - I'm pretty sure that Blogger's "beginning of time" is 1970, so it may have been that these photos didn't have any date stored with them at all, and the 2075 date is Google Photos default value.
Jun
5
comment How can I modify a photo's date on Google Photos?
I'm glad to hear that worked: at one stage Actions > Edit in Google+ wasn't working from Picasa Web Albums. But if it is working now, that's an improvemement.
Apr
23
comment Find and replace text in Google spreadsheet
Is this a one-off exercise, or do you need a repeatable solution?
Mar
25
comment Make cell height in one column not affect other columns within the same row in Google Spreadsheets
I'm afraid that's really not how spreadsheets work. Perhaps you should consider using a table in a Docs file instead of a spreadsheet.
Dec
3
comment Can Facebook pages be indexed by Google's search engine?
Well it appears that Google is doing so now: I just googled "some words I know I posted on the wall of a Facbook page site:facebook.com - and my Facebook page IS listed in the search results.
Dec
1
comment Google Spreadsheet generate random numbers with Math.random()
Can you just put the results of =rand() into a helper column, and then pass the contents of that column into your function? That may resolve the hanging behaviour you are seeing.
Nov
24
comment How can I google search a defined set of domains/sites for a certain string
That's the one-off solution. For a repeatable solution, see "How to limit Google search result to a set of websites" - webapps.stackexchange.com/questions/70005/…
Nov
19
comment Forgot YouTube account and Password
Who owns the copyright of the songs? If that person or company files a DMCA complaint, it's possible that the videos (not the channel) will be deleted.
Nov
18
comment How to make SQL JOIN of two tables with Google Spreadsheet?
What would you do with the data that came back from the query? it's likely that there is an anternative spreadsheet focussed way to solve the underlying problem.