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 […]

Having very wide or very skinny columns in Excel can make it difficult to work with the rest of the data in your spreadsheet. Whether those column widths were changed intentionally or by accident, it is helpful to be able to resize a column by clicking on its border and manually dragging the column until […]

Often when you are working with a lot of data in Excel you will need to scroll to a point where a column or row label is no longer visible. This can usually be resolved by freezing the top row of the sheet so that you always keep the header, or title, row visible, but […]

If you need to take an inventory of something in your home or place of employment, or if you need an effective way to record pieces of information, then a table or grid is a great solution. One option for creating that grid is to draw it by hand, but that can be tedious and, […]