Sometimes, you may want to reorganize data and combine info from different Excel cells into one entry. You can do this using the concatenate function. In this example, we have a basketball fantasy league roster, with fields for players’ last names, first names, and positions. If we want to combine all that information in one field, we will need a formula that reads “=concat(first cell, second cell, third cell),” or, in this case, “=concat(C6,B6,D6)” without the quotes.

Sometimes, you may want to reorganize data and combine info from different Excel cells into one entry. You can do this using the concatenate function. In this example, we have a basketball fantasy league roster, with fields for players’ last names, first names, and positions. If we want to combine all that information in one field, we will need a formula that reads “=concat(first cell, second cell, third cell),” or, in this case, “=concat(C6,B6,D6)” without the quotes.

If you want to unhide a specific row or column, you will need to highlight the columns or rows on either side of it. Once done, right-click and select Unhide from the resulting list of Excel options.

If you want to do more advanced work in Excel — such as create macros — you will need to access the Developer ribbon. Sadly, this tab is hidden by default. To view it, click Excel in the upper-left corner and select Preferences.

So you see almost everything that you can think of can be done in Excel with some simple shortcuts. There are many useful tips and tricks to save your time both as beginners and advanced users. So boost up your productivity with some amazing Excel Hacks that you possibly are not aware of.