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...
Tag: 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...
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...
Do you need to compress those large numbers in your spreadsheet down by representing them as thousands, or millions? This simple custom formatting technique will help you clean up your numbers real...
How do you find the difference between two dates in Google Sheets? Do you just subtract two dates? Or is there a handy formula you can use to better calculate the difference. In most spreadsheets...
The only limitation with the ARRAY_CONSTRAIN function is it fetches from the upper-leftmost corner of the range. Here we combine the QUERY and TRANSPOSE functions to flip a range, so the...
