There could be times during your daily workflow when you may want to combine 2 columns in Excel with a space. Let’s say you have first names in one column and last names in another. Now, instead of ...

Comparing two columns in Excel doesn’t have to be a difficult task, and to get the job done, we suggest using VLOOKUP. You see, not always; the columns you want to compare are in the same workbook or ...

Adding space between Excel columns is usually a simple matter of increasing your column widths. But when the columns contain different types of data, such as numbers and text, increasing the width ...

Every time Dave publishes a story, you’ll get an alert straight to your inbox! Enter your email By clicking “Sign up”, you agree to receive emails from Business ...

Every time Ryan publishes a story, you’ll get an alert straight to your inbox! Enter your email By clicking “Sign up”, you agree to receive emails from Business ...

Sometimes hiding certain columns in an Excel spreadsheet can be helpful: Doing so can make spreadsheets easier to read or you may have other reasons to hide them. In any case, hiding columns in ...

If you often scroll through long Excel sheets, learning how to freeze the top 2 rows will make navigation far smoother. Excel’s Freeze Panes feature lets you lock multiple rows, columns, or both, so ...