Text Rotation in Google Sheets allows you to angle the text up or down inside your cells, which lets you create some nifty looking headers.
This particular example was prompted by a recent question from a reader:
How do I make a diagonal line to split a cell, so that I can enter text into two triangular subdivisions?
You can’t split a cell explicitly, but you can use text rotation and formula-trickery to achieve this effect.
Continue reading Using Text Rotation to Create Custom Table Headers in Google Sheets
Let’s kick of this post with one of the all-time top Google Sheet productivity tips:
Use keyboard shortcuts to work more efficiently. It might feel clumsy at first, but persevere and it’ll pay off in spades as you become more efficient in your work.
Continue reading 6 Killer Productivity Tips for Google Sheets
Have you ever needed to use Vlookup with multiple criteria?
For example, you may want to use first name and last name combined to search for a value using Vlookup.
In this post, you’ll see how to Vlookup multiple criteria in Google Sheets, with three different scenarios.
Continue reading Vlookup Multiple Criteria in Google Sheets
In this post, you’ll see how to remove duplicates in Google Sheets using the Remove Duplicates tool, the UNIQUE function, Pivot Tables, Conditional Formatting, Apps Script or an Add-On.
Firstly though, what are duplicates? And why are they a problem?
Continue reading How to Remove Duplicates in Google Sheets