Spreadsheet Point
27 FOLLOWERS
Spreadsheet Point is dedicated to helping you become a master of Google Sheets. We have hundreds of in-depth guides dedicated to everything from the very basics of spreadsheet use right through to advanced tips for power users. Each of our guides is crafted by one of our spreadsheet experts.
Spreadsheet Point
1w ago
Adding a Google Sheets hyperlink is a piece of cake. This guide will show you how to do it with 3 different methods as well as how to edit and delete hyperlinks. I also made a 1-minute video to show exactly how it works. How to Hyperlink on Google Sheets Using Insert Menu This method ... Read more ..read more
Spreadsheet Point
3w ago
To import Stock Prices into Google Sheets, use the File menu and select import. Then, upload your CSV file. Here’s a video I made that shows the whole process. Where to Find Historical Stock Prices While there are many places you can go to find up-to-date stock prices, I prefer to pull all of the ... Read more ..read more
Spreadsheet Point
1M ago
Array formulas take functions that apply to single cells or ranges and can output the results as a matrix. Using them saves me a ton of time and reduces errors from manual entry. I understand they can be intimidating when starting. That’s why I’ve put together this helpful array formula Google Sheets guide to walk ... Read more ..read more
Spreadsheet Point
2M ago
To hide gridlines in Google Sheets, use the “show” menu. I’ll show where to find this (and how to add only specific lines in your spreadsheet) below. Note that my guide shows how to hide those gray lines and also how to add thicker grids around different cells. How to Get Rid of Gridlines in ... Read more ..read more
Spreadsheet Point
3M ago
A Google Sheets heat map is a great way to add color to a boring spreadsheet, making it much easier to read and more visually appealing. Luckily, Google Sheets has simplified creating a heat map by using the conditional formatting feature, which highlights and customizes your data so you can choose your color scheme, making ... Read more ..read more
Spreadsheet Point
3M ago
To build a character sheet spreadsheet, choose a system and walk through character creation. Or customize my generic character sheet template to suit your game. I’ll walk through each step of the process below. Character Sheet Spreadsheet Template If you want a basic character sheet in Google Sheets, make a copy of mine and customize ... Read more ..read more
Spreadsheet Point
3M ago
Looking for an investment tracking spreadsheet to organize your 2024 portfolio? Tracking your investments is just as important as the investment process. I’ve invested in multiple companies, and keeping track of my investments was a nightmare. That was before I started keeping tabs on my investments using a Google Sheets investment tracking spreadsheet. I will ... Read more ..read more
Spreadsheet Point
3M ago
To assign a task in Google Sheets, either tag someone’s email in a comment or create a drop-down list. I show both methods in this guide. The commenting method is used in Google Docs, Google Sheets, and elsewhere in the GSuite. The drop-down method of assigning tasks is unique to Google Sheets. How to Assign ... Read more ..read more
Spreadsheet Point
3M ago
This article discusses three of the best RACI templates in Sheets for 2024. Every template in this article has different features, so you can find one that best suits your needs. Feel free to download them all to see which meets your requirements. Keep reading to learn more about the best RACI template Google Sheets ... Read more ..read more
Spreadsheet Point
4M ago
The best habit tracker spreadsheet templates help you visualize your progress with an interactive worksheet. And what’s the best way to start the new year? For me, it starts with a renewed journey of self-improvement using an intuitive habit tracker Google Sheets template. In this article, I discuss three habit tracker Google Sheets templates. Each ... Read more ..read more