Sometimes you are writing up a long text string in Microsoft Excel that you know won’t fit into a regular sized cell. So what can you do about it? Simple. There’s a way to wrap text in Excel that’s pretty easy to learn. Here’s how you can successfully wrap text in Excel See also: How …
What if you wanted to merge some cells in Microsoft Excel? You may want to combine the names of people or places into one cell. Whatever the reason, there’s a couple of ways you can do that. One method is quicker but is mainly for eliminating other cell names. The other truly merge two cells …
When it comes to office jobs, few skills are as beneficial as Microsoft Excel. Mastering this ubiquitous tool is like having the ultimate transferable skill on your resume. Excel has almost limitless potential. Today we’re going to discuss how to create a drop down list in Excel. Why would you want a drop down list? …
One of the most common functions you’ll find yourself using in Excel is basic math. You’ll find that most operations have straightforward formulas that you can use to add, multiply, and more. However, there is no formula in Excel that allows you to subtract. Instead, here are a few alternative methods for how to subtract …
Too many columns of data can get confusing in Excel, especially if you don’t need them all for your current task. You may choose to hide some columns just to clean up the data you’re working with, but then you also need to know how to unhide columns in Excel. While hiding columns is relatively …
In Excel, data is entered into cells and those cells are further organized into rows and columns. However, even the most well-planned spreadsheets need to be reorganized sometimes. Whether you’re organizing by data type or searching for trends, it’s important to know how to move columns in Excel. As with many Excel features, there’s more …
So you’re chugging along, filling in your Excel spreadsheet. All of a sudden you realize that you missed a few valuable lines of your data. Now you either have to go back and erase a lot of data or insert a bunch of new rows. The choice is obvious: Here’s how to insert multiple rows …
When you’re knees deep in your spreadsheet with column after column full of important data, it can get overwhelming. You have more information than you can shake a stick at but you can’t always find just what you need. This is exactly when you need to know how to sort in Excel. You may have …
Basic math is one of the most important things that you can do in Excel, and it’s usually quite straightforward. Adding is important because it is one of the ways you’ll start to work with some basic formulas. The SUM formula may not be the most advanced, but mastering it will help you wrap your …
One of the most exciting things you’ll do in Excel is converting heaps of dreary data into stunning graphs and charts. Pie charts are among the most popular graphs to make because you can show data as a percentage of a total. However, it can be tricky to learn how to make a pie chart …