Printing is a basic necessity while working with any kind of data. While printing it's very important to know what will be printed. Google Sheet Provides us with very simple…
Unlike Google Docs, we don't have any option to add Headers and Footers to the Sheet normally. To add headers and footers, we'll have to print the sheet first. In…
At times you may require to know the Column Number or Column Letter of an associated cell. Thankfully Google Sheets has provided us with simple ways to get this done.…
A neat row header is one of the most underrated best practices while working with Spreadsheets. It has the potential to save tons on time, make a good presentation impression…
Text Rotation in Google Sheet is a lesser used feature, but comes in quite handy for formatting reasons at times. Best of all it's very easy to implement. In the…
Imagine you presenting a data heavy Google Sheet and your boss asks to "Zoom - IN" and you dont know how. Dont worry we are here to help. Though it…
Ever felt the need to count blank cells in a given data and don't know how? Google Sheets provides us with COUNTBLANK Function to do this task. This is a…
Conditional counts are frequently required whenever you are trying to draw insights from a big dataset. One such instance is when you want to count cell any text/specific text across…
COUNTUNIQUEIFS in the truest sense is a hybrid of COUNTUNIQUE & COUNTIFS, literally bringing the best of both worlds. (Highly recommended to have a look at above two articles before…
Counting is a very fundamental operation in any spreadsheet activity and fortunately Google Sheets provides us with a plethora of count related function to work with. COUNTUNIQUE is one such…