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

Formulas that you use in Excel can perform a number of calculations or functions that automate some of the work that you are doing. These formulas often reference cells in a worksheet, meaning that the value contained in that cell is used in the formula. This allows you to enter the formula once and change […]

It’s not uncommon for someone to have more than one Web browser on their computer. Windows 7 includes Internet Explorer by default, but you may find that browser to be slow. This can lead you to download something like Chrome or Firefox. But you may notice that the links that you click in Excel continue […]

Links on Web pages provide a simple way to give a reader access to something that you think is important for them. Whether it’s a reference to some data in the article, or perhaps an additional resource that may prove useful, a clickable link makes navigation a lot simpler. Links can also be used in […]