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

Have you been working on a spreadsheet, editing and adding data, only to print it and find that it isn’t including all of your data? This can be a confusing issue to encounter, as it is typically caused by a setting that was applied to that spreadsheet by someone else that was working on it. […]

Page numbering printed spreadsheets is very important for multi-page sheets that could potentially become separated. Depending on the data that is included in the sheet, keeping your rows and columns in the correct order can have a significant impact on the way that data is viewed and understood. But if you have already added page […]

Using fill colors in Microsoft Excel 2013 is a great way to identify similar data and give people that are reading your data an additional, visual way to understand and interpret that data. But did you receive a spreadsheet from someone else that had multiple colors for a fill color, and you want to know […]

Using the strikethrough effect in documents is helpful for letting a reader know that the text has been removed, while still leaving it there as a reference in case it is needed later. This formatting option is available in Microsoft Excel, and is used occasionally for a number of reasons. If you are editing a […]