Formulas are an important part of many Excel spreadsheets, and are one of the main reasons that it can be such a helpful tool in a wide range of projects. Excel supports a lot of different formulas, many of which have their own special formats. In order to help with your usage of the program, […]

The row of buttons and tabs at the top of your Excel window is called the ribbon, and it offers an efficient way for you to find almost all of the settings and tools that you will need when working with your spreadsheets. But, depending upon how you use the application, and the other programs […]

Whenever you create a new workbook in Microsoft Excel, there are certain default settings that are applied to that workbook. Some of these default settings can be adjusted, including the one that determines the size of the font that is used when you type information into your cells. So if you find that the current […]

A file in Microsoft Excel is called a workbook, and that workbook can include a number of different spreadsheets called worksheets. Organizing large amounts of data into multiple worksheets affords you a number options for analyzing your data, and you may have found that you are often adding more worksheets every time you start a […]

The strikethrough effect is a helpful thing to use when you are creating documents. It provides you with a way to visually delete or mark information as something that is not important, but it allows you to keep it around so that readers can still see it, or in case you decide later that you […]

If you have used Excel for a while, then you have probably acclimated yourself to the visual appearance of the program. But the colors of the application might be wearing on your, leaving you looking for something different to spice up your daily activity in your spreadsheets. One simple change that you can apply is […]

There is often a difference in the way your data appears in cells in Excel 2013 spreadsheets. The number of displayed decimal places can vary depending on the entered amounts so, if you are dealing with monetary values, it’s helpful to keep them consistent by formatting those values as currency. But the default currency formatting […]

There are multiple different sizes of paper that you might use to print a spreadsheet. The selected paper size may depend on the size of the sheet you are printed, but there may be some geographic preferences that play into that selection as well. In some parts of the world it is common to print […]

Depending upon your current geographic location and your field of study, you may be used to a specific character that separates your decimal values. However, the character that is currently set in Microsoft Excel may not be the separator that is ideal for your current needs. Fortunately you can change the decimal separator in Microsoft […]

Hiding data in an Excel spreadsheet is a common practice when there is data that isn’t necessary to view, but that you either need for a formula, or aren’t sure that you actually want to delete. Perhaps you have even hidden some rows or columns before, and like the ability to streamline the data that […]