Very similar to our previous article on how to make a header row in Google Sheets, in this article we'll show how you can lock a column in Google Sheets. To lock a column in Google Sheets easily just navigate and click on the View menu, then on … [Read more...] about How To Lock A Column In Google Sheets
Blog
How To Make A Header Row In Google Sheets
I was recently working with a lot data on my Google Sheets spreadsheet and as I scrolled down the page the information from the top rows moved off and I could no longer see (and could no longer remember) what each column's label in the first row … [Read more...] about How To Make A Header Row In Google Sheets
Word Count WordPress – PHP Code
If you want to know how many words your Wordpress articles have you can open up each post individually and by clicking on the top left-hand corner’s information icon it will display the number of words. For example, when I completed this post I … [Read more...] about Word Count WordPress – PHP Code
Ignore Blank Cells In IF Functions – Google Sheets
In a previous post, I explored how to ignore blank cells when using the QUERY function in Google Sheets, which had its own distinct way of removing blank cells from the data capture. But how do you ignore blank cells in your spreadsheet when … [Read more...] about Ignore Blank Cells In IF Functions – Google Sheets
SuiteScript UNEXPECTED_ERROR With RESTlet
A recent project hit a roadblock when I changed some code depending on the N/search module and refactored it to use N/query module. While I had some initial hassles with accepting the Beta nature of the N/query script I soon ran into another error … [Read more...] about SuiteScript UNEXPECTED_ERROR With RESTlet
How To Format Numbers In Thousands (K) In Google Sheets
If you're looking at too many numbers on the screen and they are large enough to be reduced by thousands you can reduce them using a simple custom number format in Google … [Read more...] about How To Format Numbers In Thousands (K) In Google Sheets