Browsing: Sheets

How To Lock a Formula in Google Sheets

This Tech Junkie guide told you about how to lock formula cells in Excel. You can also lock, or protect, formula cells in Google Sheets. Google Sheets offers real-time collaboration for sharing spreadsheets with multiple users.


Read More
How To Highlight Duplicates in Google Sheets

For years, business and home users alike relied on Microsoft Excel to organize their data into spreadsheets. Whether you’re looking to make check lists, budget and financial records, graphs, or any other set of data, it’s


Read More
How To Subtract in Google Sheets with a Formula

Sheets is the spreadsheet application in Google’s web-based office suite. Although it’s a web app, Sheets is still comparable to most desktop spreadsheet software packages. It shares many of the same functions included in Excel. Furthermore,


Read More
How To Get Absolute Value in Google Sheets

The absolute value of a number is how far it is from zero. For example, the absolute value of 454 is 454! However, absolute values for negative numbers are also positive numbers. Thus, the absolute value


Read More
How To Add the CAGR Formula to Google Sheets Spreadsheets

Google Sheets is a web-based application that includes many financial functions. As such, Sheets users can set up a wide variety of investment spreadsheets. The compound annual growth rate, otherwise CAGR, is one of the handy


Read More