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 ...

Sometimes we have spreadsheets overrun with data and it can be quite cumbersome where Microsoft Excel is concerned. Not everyone wants to see the data all at the same time, so the best option to take ...

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 ...

How to split a column using an IF() function in Excel Your email has been sent We all inherit Microsoft Excel sheets that don’t suit our working routine. If it’s a simple tracking sheet of some sort, ...

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 ...