Spit in the Face of God: Five Tasks You Didn’t Know Could be Done with Google Sheets
Google Sheets basically spits in the face of God. Man was never intended to have such power. You will surely burn in the Lake of Fire for using these tips to perform various tasks.
Spit in the Face of God: Five Tasks You Didn’t Know Could be Done with Google Sheets
Articles in Spreadsheets | By August R. Garcia
Published | Last Update 📌
Google Sheets basically spits in the face of God. Man was never intended to have such power. You will surely burn in the Lake of Fire for using these tips to perform various tasks.
3,390 views, 2 RAMs, and 2 comments
- Spit in the Face of God: Five Tasks You Didn’t Know Could be Done with Google Sheets
- Timestamp Cells with Ctrl+Semicolon
- Spreadsheet Tabs Can be Hidden
- Quick Navigation with Magic
- Google Translate is built into Google Sheets
- Scrape Data from Any (Public) Webpage
- Bonus: Offbrand JavaScript
- Honorable Mentions
- In Conclusion
- Additional Resources
- Related Posts
Spit in the Face of God: Five Tasks You Didn’t Know Could be Done with Google Sheets
Google Sheets basically spits in the face of God. Man was never intended to have such power. You will surely burn in the Lake of Fire for using these tips to perform various tasks.
Anyway, it’s time to learn how to anger God.
Timestamp Cells with Ctrl+Semicolon
Typing the =TODAY() and/or =NOW() functions into cells is bullshit, since then you have to convert the output of that function into a hardcoded value, so that it won’t change over time.
Instead of doing that, hit Ctrl+;
to add the current date into the currently-selected cell (ex: 2/12/2019). Or, if you like precise data, use Ctrl+Alt+Shift+;
to get a timestamp with the current time included (ex: 2/12/2019 4:48:57).
Spreadsheet Tabs Can be Hidden
Right click a tab and select “Hide Sheet.”
To unhide tabs, go to View --> Hidden Sheets
.
I bet you didn’t know about that, unless you did, in which case, please look up a video of Chris Rock saying “what do you want, a cookie?”
Quick Navigation with Magic
Holding Ctrl and pressing any of the arrow keys will jump the cursor to the next/last filled cell in the specified direction.
In most other applications, such as LibreOffice, Gedit, most browser contexts, and so on, using Ctrl+Arrow Keys
also works to jump over full words when editing text of any type.
On a related note, Ctrl+D
is the hotkey to “fill down.” Put a formula or a hardcoded value into a cell, highlight some cells underneath it, and press Ctrl+D
to drag the formula. This is generally much faster than manually dragging formulas when working with many rows.
Google Translate is built into Google Sheets
For example, this input:
=GOOGLETRANSLATE("We're going to build a wall and we're going to make Mexico pay for it. The wall just got ten feet taller." , "en", "es")
Will result in this output:
If you would like to further insult God (beyond speaking in the Unholy Spanish), there are various other tricks that can be done with this function, such as what is discussed in this forum thread, as well as similar tricks for the Filthy Money Changers.
Scrape Data from Any (Public) Webpage
Google Sheet’s IMPORTXML
function is a quick and straightforward solution to scrape data from any webpage. Writing is hard; check out this video:
IMPORTXML
uses XPath for data parsing. While writing and testing XPath queries, tools like XPather are useful.
Also see the IMPORTFEED
, IMPORTHTML
, IMPORTRANGE
, and IMPORTDATA
functions.
Bonus: Offbrand JavaScript
If you stayed up at night as a child, praying that God would heal your mother’s cancer, but He let her die anyway, your hatred for God might still be unsatiated. Custom functions can be written in Google’s custom scripting language known as the Google Apps Script scripting language, or more commonly as “Offbrand JavaScript.”
Apps Script is based on JavaScript 1.6, plus a few features from 1.7 and 1.8. Many basic JavaScript features are thus available in addition to the built-in and advanced Google services: you can use common objects like
Array
,Date
,RegExp
, and so forth, as well as theMath
andObject
global objects. However, because Apps Script code runs on Google's servers (not client-side, except for HTML-service pages), browser-based features like DOM manipulation or theWindow
API are not available.Source: Google Apps Script Documentation: Basic JavaScript Features
The script editor can be accessed under Tools → Script Editor. In addition to custom XML parsing and handling, it can be used for basically any Crime Against God, such as scripts for custom capitalization of terms, spintax for content generation, checking HTTP status codes, sending bulk emails, creating scripts to import JSON (for example, so that you can scrape data from Reddit by adding .json to the end of any URL).
Honorable Mentions
- String parsing, replacing, matching, and extracting with regular expressions. [Regex101 Tool]
- Using
Ctrl+Enter
while editing a cell to create a line break within the same cell - Using
=CHAR(10)
to create newlines when concatenating text, such as=”Line 1”&CHAR(10)&”LINE 2”
- Handling capitalization with LOWER, UPPER, and PROPER.
- Alternating colors are built in. Highlight a range and go to the Paint Bucket → Alternating Colors.
- Color-code tabs by right clicking a tab and selecting a fine color under the “Change Color” option.
- Pressing F2 while a cell is selected will move the cursor into the cell for editing.
- Notes exist (different from comments; simpler and less intrusive). Right click a cell and select “Add Note.”
- Creating single-cell charts with sparklines. [video]
- Creating reports from data using offbrand SQL queries.
In Conclusion
The wicked go down to the realm of the dead, all the nations that forget God.
Source: Psalm 9:17
Also, since all sins are equal in the eyes of God (James 2:10), you might also check out the Google Sheets, Google Docs, and Google Drive APIs.
Additional Resources
- The Full List of Google Sheets Functions
- The Official List of Keyboard Shotcuts for Google Sheets
- Learn Google Spreadsheets – A
QualitySinful YouTube Channel – Channel by Chicago Computer Classes by Chi Brander Inc.
Related Posts
- Get These Dependencies Off My Lawn: 5 Tasks You Didn't Know Could be Done with Pure HTML and CSS
- How to Make Graphs Using Google Sheets
- Using Excel to Create Scale-able Content for eCommerce and Other Related Tasks
- That Feel When Google Sheets Doesn’t Support Color Scales Based on Other Cells
- All Content Categorized under “Spreadsheets”








Hash Brown (3 years ago)
Huevos Rancheros (3 years ago) 🐏 ⨉ 2Posted by August R. Garcia 3 years ago
Edit History
• [2019-02-12 7:53 PST] August R. Garcia (3 years ago)• [2019-02-12 7:53 PST] August R. Garcia (3 years ago)
• [2019-02-12 7:53 PST] August R. Garcia (3 years ago)
• [2019-02-12 7:53 PST] August R. Garcia (3 years ago)
• [2019-02-12 7:53 PST] August R. Garcia (3 years ago)
• [2019-02-12 7:53 PST] August R. Garcia (3 years ago)
🕓 Posted at 12 February, 2019 07:53 AM PST
- C U [Solved] Google Sheets: "Text result of JOIN is longer than the limit of 50000 characters"
- C U How to copy formulas in Google Sheets?
- C U [Google Sheets] Dollar sign usage? What does it do?
- C U [Google Sheets] Getting the error "Service invoked too many times in a short time: exec qps. Try Utilities.sle...
- C U [Google Sheets] Global conditional formatting across multiple sheets/tabs?
- C U How to find and replace in Excel?
- C U Finding outliers in Excel?
- C U How to round number to nearest 5 in Excel?
- C U How to split cells in Google Sheets?
- C U How to use the Quick Analysis tool in Excel 2016?
August Garcia is some guy who used to sell Viagra on the Internet. He made this website to LARP as a sysadmin while posting about garbage like user-agent spoofing, spintax, the only good keyboard, virtual assitants from Pakistan, links with the rel="nofollow" attribute, proxies, sin, the developer console, literally every link building method, and other junk.
Available at arg@256kilobytes.com, via Twitter, or arg.256kilobytes.com. Open to business inquiries based on availability.
Re: "Scrape Data from Any (Public) Webpage" - There's a new post/video that demonstrates this type of scraping for email extraction, which can be found here:
Sir, I can do you a nice SEO.
Any opportunity to spit in the face of god is good by me.
Excellent post homie.
"THAT DOG IS GETTING RAPED" - Terry A. Davis
Post a New Comment
To leave a comment, login to your account or create an account.
Do you like having a good time?
Register an Account
You can also login to an existing account or reset your password. All use of this site is subject to the terms of service and privacy policy.
Read Quality Articles
Read some quality articles. If you can manage to not get banned for like five minutes, you can even post your own articles.
View Articles →
Argue with People on the Internet
Use your account to explain why people are wrong on the Internet forum.
View Forum →
Vandalize the Wiki
Or don't. I'm not your dad.
View Wiki →
Ask and/or Answer Questions
If someone asks a terrible question, post a LMGTFY link.
View Answers →
Make Some Money
Hire freelancers and/or advertise your goods and/or services. Hire people directly. We're not a middleman or your dad. Manage your own business transactions.