|⌘ = Ctrl and Option = Alt|
Look down at the bottom of this page. See those tabs? Those are different sheets. If you want to test out a puzzling theory,
but don't want to muck up your current progress, duplicate the current sheet, name it "<your name> copy" or something
|Copy and Paste||Rows & Columns|
and try it out on the new sheet. If someone is referring to progress in a chat, but you don't see it, it might be on a different sheet.
|⌘ + C||Copy, duh|
Highlight N rows/cols, right click, Insert N rows/cols
|Inserting multiple rows/columns|
|⌘ + V||Paste, duh||Highlight N rows/cols, right click, Resize||Resizing rows/columns|
|⌘ + Shift + V||Paste values only||Highlight N rows/cols, right click, Hide||Hide rows/columns|
Use UPPERCASE and fixed-width fonts for short strings of data, like crossword clue answers.
|⌘ + Option + V|
Paste formatting only
|Data → Split text to columns||Split text by delimiter|
Color answers that have been confirmed or used in some way (such as being added to a grid)
Use lowercase or single question marks for answers you are unsure about
Use question marks or asterisks to denote partial knowledge of certain letters
|⌘ + K||Insert link||Arrow (↑↓→←) | PgUp | PgDown | Home | End||Move cursor along direction (Home/End is ←/→)|
Prepend numeric-looking data with a single quote if you want Google Sheets to treat it as raw text
|⌘ + D||Fill down||⌘ + Arrow||Move cursor to furthest non-empty cell|
|⌘ + R||Fill right|
Shift + [Arrow|⌘+Arrow|PgUp|PgDown|Home|End]
|Select multiple (along movement)|
|FORMULAS||⌘ + \||Clear formatting||⌘ + Click||Select multiple, noncontiguous cells|
Google Sheets provides a fairly powerful language for manipulating sheet data. We've listed some common patterns below, but
|Option + Enter||Open link|
if you need to do something more advanced and are not sure how, consult Andrew He.
|=MID(A1, B1, 1)|
Index B1 into A1
When there are multiple people viewing a Google Sheet, a chat panel will pop up on the right side of the screen.
=SUBSTITUTE(A1, " ", "")
THIS CHAT DOES NOT SAVE HISTORY, so if someone says something important, make sure it appears either on
Convert to uppercase
the sheet itself or a corresponding Discord channel. Furthermore, if you are not the owner of the sheet, Google Sheets will
|=CHAR(A1 + 64)|
Convert number to letter (A = 1, B = 2...)
by default display you as an anonymous animal. This is not very useful for conversing. To rectify this, SHARE THE SHEET
|=CODE(A1) - 64|
Convert letter to number (1 = A, 2 = B...)
with yourself (a gmail address) and then re-open it.
NOTES AND COMMENTS
Right-clicking on a cell allows you to insert a note or insert a comment. In general you should prefer notes to comments. Comments
If the puzzle includes pictures, or elements that are not easily transcribed, take a screenshot and include it in the sheet as an image.
notify the owner of the sheet via email, can be replied to and resolved, and are kept track of at the bottom of the page in front
Insert → Image → File from computer / link
of the name of the sheet. None of these features are desirable in the context of puzzle solving.
Resize and move around the image to an appropriate size and location.
This cell has a comment
This cell has a note
Google Sheets sometimes bugs out, especially when multiple people are making simultaneous edits. (Transactions are hard...)
grids, notes, crossword clues, heavy formatting
If you've suddenly found that all your progress is gone, and can't identify who needs to Ctrl + Z to get it back, never fear!
|sheet||indexing, formulas, data collection, images|
Simply ask everyone to stop making changes, and then dig through the version history (File → Version History) to restore your work.