This blog post will present a few examples of how to create checkboxes and insert tick symbols or cross marks in your Google Sheets. Whatever your history is with Google Sheets, today you may discover some new methods of doing that. Lists help us put things in order. Stuff to buy, tasks...
Let’s change the lowercase text in the left column to uppercase in the empty right column. Method 1 – Using the Flash Fill Feature Flash Fill senses the pattern in your text and fills your data in the same way. It identifies the cell value pattern and repeats the order for the ...
Connect your Google account, select a spreadsheet and sheet. InTable contains headersselectNo. In theColumn rangespecifyA-ZZ. Specify the filter by which you want to select a row (for example, by the day of the week), and click theOKbutton. In the first field, select a column from Goo...
A cheat sheet for common data journalism stuff. For details on installing these tools, see how I work. Use CMD + F to search the page, or the jump menu below if you know what you're looking for. Jump to: Command line tools grep | head/tail | ffmpeg | pdftk | esridump | wget ...
Now that you’ve created a bar graph in Google Sheets, you might want to edit or customize the labels so that the data you’re showing is clear to anyone who views it. To add or customize labels in your bar graph in Google Sheets, click the 3 dots in the upper right of your bar...
2. Insert text at the end of Google Sheets cells To add text in Google Sheets at the end of cells, use the same joining way I showed for inserting text at the beginning of cells. I mean the CONCATENATE function that uses an ampersand (&). ...
=VLOOKUP(search_key,SheetName!range, index, [is_sorted]) Basically, directly before the range, you add the worksheet name that contains the data you want to pull from followed by an exclamation mark (!). How to use VLOOKUP in Google Sheets Now I'll show you what VLOOKUP looks like in...
How to compare documents in Google Docs The steps to compare two documents in Google Docs varies slightly from Word, but it's just as straightforward to do. Open the first document you want to compare. In the menu, clickTools, and then clickCompare documents. ...
For math, science, or even a footnote, here’s how to superscript in Google Docs. Learn how to apply the superscript format on the web and in the mobile app.
This complete guide will teach you how to start a blog, from start to finish. Learn how to choose a blogging platform, set up your blog and monetize it.