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 […]

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 […]