If you want to send a Google Sheets document to someone, you may be happy to simply share the sheet with them, but this doesn’t work in all cases. For instance, if you’re sharing a document with family, friends, or co-workers then you may be happy to share the sheet. If, however, you’re sending a copy to a client or something similar, you’re much more likely to want to use a … [Read more...] about How to Convert Google Sheets to PDF
Google Sheets
How to Create and Modify a Chart in Google Sheets
If you have to regularly deal with lists of numbers, looking at those boring lists can get to you. Maybe at work, you have no choice but to deal with these kinds of lists, but those lists can be more pleasing to read when they're in a chart. The good news is that you can turn all those monotonous numbers into an attractive chart with a few clicks here and there. It's going … [Read more...] about How to Create and Modify a Chart in Google Sheets
How to Set Editing Permissions in Google Sheets
By setting editing permission in Google Sheets, you can prevent other users from making any unauthorized changes to your file. The change could be made to help, but if you want to prevent others from making any changes, there are permissions you can change. With the options Google Sheets has, you can keep your file edit-free and only authorize people you trust to make the … [Read more...] about How to Set Editing Permissions in Google Sheets
Setting Up Macros in Google Sheets
With advancements in technology comes an even greater need for efficiency at work. Basic spreadsheet tricks like formulas, tables, and filters in Google Sheets can no longer get you very far. Even though these skills are still essential to know, they are quickly becoming somewhat outdated. Workplace production really demands something more than mere efficiency. It demands … [Read more...] about Setting Up Macros in Google Sheets
Google Sheets: Add Multiple Lines of Text in Single Cell
Usually, in a spreadsheet, you’ll have one line of text, one piece of information per cell. Whatever the data may be – an amount, a date, anything really. In some instances that may not be the case though; you may find yourself wanting to keep an entire address in a field, for example, or a few sentences of a description. … [Read more...] about Google Sheets: Add Multiple Lines of Text in Single Cell
Adding a Watermark to Google Sheets
Google Sheets doesn’t support watermark functionality – if you want to add a watermark to your Google Sheets, you’ll have to use a bit of a work-around to get it done. It should be the last step in your work process, so make sure that you’re done with your spreadsheet before doing this. … [Read more...] about Adding a Watermark to Google Sheets
Google Sheets: Protect Cells
Google Sheets is a great productivity tool with just about every function a user could want. Among the slightly lesser-known but easily most useful, is the ability to protect fields and data ranges. This function allows you to protect certain fields from accidental editing while you work on them in a collaborative arrangement. You can stop others from editing some of the … [Read more...] about Google Sheets: Protect Cells
Google Sheets: Remove Gridlines (Display and Printouts)
Google Sheets is a great alternative to expensive productivity programs like Excel – Sheets offers much of the same functionality, though organised a little differently. If you aren’t used to Sheets, it can be difficult to know what to do – for example when it comes to gridlines. Gridlines are the outlines that mark the limits of each cell, the borders, so to speak. They can … [Read more...] about Google Sheets: Remove Gridlines (Display and Printouts)
Google Sheets: Make Dropdown List
Google Sheets has a long list of useful features – there are dozens of things you can accomplish with them, not the least of which is the handy dropdown list feature. While cells are meant to hold one piece of info per cell, you can give yourself or other users a choice – by letting them choose from options stored in a dropdown. … [Read more...] about Google Sheets: Make Dropdown List
Google Docs: How to Make Flashcards
Flashcards are fantastic studying tools, as are their virtual counterparts. Given that Google Docs is the perfect free alternative to paid Office tools it stands to reason that you’d want to use it to make your own flashcards. … [Read more...] about Google Docs: How to Make Flashcards