10 Excel Options and Features You Didn’t Know Existed in Excel


How much do you actually know about Excel? Even if you’ve spent a lot of time using Excel, it’s likely that this spreadsheet software has features that you’re unaware of. These are 10 impressive options that Excel offers.

1. Excel Can Be Used to Make Video Games

People usually don’t think about gaming when they think about Excel. However, Excel can actually be used to build all kinds of games. People have even managed to build versions of hugely popular games in Excel.

2. You Can Add Multiple Rows at Once

When you’re adding rows to a spreadsheet, you don’t have to do it one row at a time. It’s possible to add a number of rows at the same time. Mastering this feature can save you a lot of time. Use the insert or Ctrl+ to use this feature.

3. There Are Print Optimization Features

If you’re printing out the spreadsheets that you make in Excel, then you’ll definitely want to take a look at some of the print optimization features that it offers. You can do a lot to improve the look and feel of your spreadsheets this way. You can print headers, titles or footers on each page with a little bit of setup.

4. You Can Fill in Multiple Rows at The Same Time

In many cases, you’re going to need to fill multiple rows with the same information. Instead of doing this one row at a time, you should try to fill in all of the rows at once. Excel gives you the option of filling in more than row if you need to. You can highlight the data to copy and then right click to highlight the rows to populate.

5. You Can Automate Many Features

If you repeat the same tasks in Excel all the time, you should know that some of these tasks can be automated. Learning how to automate these features can take a little bit of time. However, once you figure it out, you’ll be able to save yourself time every single day.

6. You Can See the Roman Value of an Arabic Integer

This is a feature that won’t come in handy that often, but it’s still something that can be useful every now and then. If you want to know what the Roman value of an Arabic integer is, Excel will be able to do that for you. Simply use ROMAN in the formula bar and indicate the cell you want that applied to (=ROMAN(B6))

7. You Can Repeat a Text String as Many Times as You’d Like

When you create a text string in Excel, you can actually repeat that string over and over again. You can decide how many times you would like the text string to repeat and then tell Excel what it should do.

8. You Can Use Excel To See Today’s Date and Time

Want to know the date and time without checking a calendar? This is something that Excel can tell you. Use the DATE and or TIME functions to populate this information into a spreadsheet.

9. Excel Can be Used to Solve Math Problems

If you need to solve a math problem, you’re probably better off using a calculator rather than Excel. However, Excel actually does have the ability to solve a number of equations using the Solver Add-in.

10. You Can Create Custom Formulas with Excel

If there’s something you want Excel to do, the only thing you have to do is come up with a formula. Learning how to write Excel formulas isn’t always easy, but it will give you a lot of control over this program.

How much do you actually know about Excel? Excel has all kinds of options and features, and you’ll want to try some of these features out if you can. Learn a little bit more about Excel and how it works so that you can maximize the time you spend with it.