Blog

Using Text Rotation to Create Custom Table Headers in Google Sheets

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?

Google Sheet with diagonal text

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

Vlookup Multiple Criteria in 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