3,369 reputation
615
bio website Blogger-hints-and-tips.blogsp…
location Ireland
age
visits member for 4 years, 4 months
seen 18 hours ago

Jun
9
answered Does Facebook delete old messages/conversations that haven't been active in years?
Jun
9
answered Google spreadsheets showing “shared with xxx” count greater than actual?
Jun
7
comment Rename Column in Google Spreadsheets
In that case, you should use the approach used in the article you have linked to, along with the View > Freeze Rows > Freeze 1 Row option
Jun
7
revised Rename Column in Google Spreadsheets
Added link to worked example
Jun
7
answered Rename Column in Google Spreadsheets
Jun
4
reviewed Approve suggested edit on ImportHTML spreadsheet function to update every 5 mins
Jun
4
reviewed Reject suggested edit on Jira → Agile → Scrum Board → Work—change text of column titles?
Jun
3
reviewed Approve suggested edit on How do I change basic information, profile picture, etc for a facebook page?
Jun
3
comment How can I prevent users from reverting to an old version of a Google Spreadsheet?
I built applications with spreadsheets back in the mid 1990s. These days, I know better :-)
Jun
3
answered Can I make a sheet private in a Google Drive spreadsheet?
Jun
1
reviewed Approve suggested edit on How do I tell lastpass to use (and update) a password for a group of sites?
May
30
comment How can I prevent users from reverting to an old version of a Google Spreadsheet?
I'm not even sure that enhancements like that would be a good idea. fundamentally this is a spreadsheet (free-format calculations canvas), trying to do the job of a multi-user application with a database backend (structured calculation processor). The mismatch between the basics is too great for a spreadsheet to realistically provide a good solution, IMHO.
May
30
answered How can I prevent users from reverting to an old version of a Google Spreadsheet?
May
27
answered Is there a way to export the text of blog entries, in Blogger, to individual text-files?
May
27
reviewed Approve suggested edit on How to take out my Youtube history?
May
23
reviewed Reject suggested edit on Semi-transparent background for Google presentation text box
May
23
revised How to calculate average screen reso. based on number of visitors using a spreadsheet?
deleted 14 characters in body
May
23
comment Google sheets split multi-line cell into new rows (+ duplicate surrounding row entries)
Someone could write a script for this (I'm not that someone!) - but really the time spent testing it would probably be greater than the time spend doing it manually.
May
23
comment Google sheets split multi-line cell into new rows (+ duplicate surrounding row entries)
You don't need to do the manual step for the whole thousand businesses. You only need to do it for the maximum number of pepole associated with any one of those businesses: eg if one business has six people, then there will be six new helper columns created, so you have to to a manual copy-and-paste six times, one for each column.
May
23
answered How to calculate average screen reso. based on number of visitors using a spreadsheet?