When you do this manually, it's very time-consuming and there is a risk of making mistakes. So I highly recommend using drop-down lists...
Create Drop Down Lists in Excel & Google Sheets
read more
Quick Tips Articles
Split text into separate columns with the ‘Text to Columns’ function in Excel
Hands up if you've tried to download info from your bank, CRM or online app and it comes out an absolute mess! It's so frustrating when you're...
FREE QR Code generator in Microsoft Excel
A really simple, step-by-step tutorial on creating a FREE QR code in Excel which can be used in presentations, flyers, business cards, surveys and so much more.
Easy Way to do Basic Calculations in Excel & Google Sheets
Learn the basics! Simple way to learn how to ADD, SUBTRACT, MULTIPLY and DIVIDE in spreadsheets properly. Learn how to use the SUM function to save time when adding up lots of numbers, even they are not all in one line.
Display And Format Numbers Properly In Excel & Google Sheets
In this tutorial, I cover number formats for dates, currency, numbers and percentages for both Excel and Google Sheets.