Tips and Tricks to Know

When you want to combine two cells into one in Excel, you have a few options. Merging cells is one of the best ways to do it. But it has a few drawbacks, too. Even so, you might find that it’s useful for working with text in Excel.

We’ll take a look at how to merge cells in Excel, how to unmerge them, and another method for combining two cells into one without losing the data in the cells.

How to Merge Cells in Excel

Before we get into how to merge cells, let’s talk about exactly what happens when you merge in […]

How to Insert a Checkbox in Google Sheets

Why is the humble checklist such a powerful tool? Well, it helps you keep track of anything—step-by-step or even as a random to-do list. Also, it is so simple to create. If you love checklists, then you will like the news that it is just as easy to insert a checkbox (or a “tick box”) in Google Sheets.

How to Insert a Checkbox in Google Sheets

Until now, to insert a checkbox in Google Sheets, you had to use the CHAR function and a number associated with the special character resembling a checkbox. This older process is complicated for something as simple as a checkbox, so […]

The Beginner’s Guide to Comments in Microsoft Excel

Whether you’re creating an Excel workbook for yourself or collaborating on a spreadsheet with others, comments are useful for many reasons. You should master the ways to manage them when you begin your Excel training.

Consider these four uses:

Set reminders for yourself of tasks you need to do on the worksheet.
Add notes for yourself or others.
Explain a formula in a cell.
Clarify how to use certain parts of the worksheet.

Today we’re going to cover some of the basics for working with comments in Excel.

Add a Comment to a Cell

To add a comment to a cell, click the cell to which you want […]