Microsoft Excel windows can easily become cluttered, which can make it difficult to concentrate on the task you are trying to complete. One way to alleviate some of this confusion is to hide some of the elements that you do not need. Whether this means certain rows or columns, or even entire worksheets and workbooks, […]

A common way to format a spreadsheet is to include a row of cells at the top or a column of cells at the left of the spreadsheet that identify the type of information that will be contained in those cells. This allows for a structured data layout that is easy for anyone viewing the […]

If you have ever run into issues with cell references in Excel formulas, then you may be looking for another way to use them. Or if you used Excel 2010 on another computer at work or school and found that the other version of Excel used numbers for both the rows and the columns, and […]

Last updated: December 16, 2016 The strikethrough effect in Microsoft Excel 2010 is helpful when you wish to indicate that information in a cell should be ignored, yet you do not want to delete that information. But the strikethrough effect can be distracting, especially when it is used a lot, and the effect remains applied […]

Excel 2010’s system of cells provides for an efficient way to organize and manipulate your data. But occasionally you may be using Excel for a purpose that requires certain data to be placed in a text box instead of a cell. Text boxes are very versatile, and you can adjust both their appearance and location […]

When you create a new text box in your Microsoft Excel 2010 worksheet, it will have a border. Typically this border is dark grey, and serves to identify the separation between where the text box ends, and the worksheet begins. But if you are using a text box in a manner that requires it to […]

Highly customized spreadsheets in Microsoft Excel often go through several different versions before they are finalized and ready to be used or seen by their intended audience. The process of finalizing a worksheet can often include adjustments or revisions that are easiest to make when the spreadsheet is viewed on paper, rather than on a […]

Unhiding the first column, or column “A” in an Excel spreadsheet presents a unique challenge. The typical method for unhiding a column will not apply when the column that is hidden is the leftmost one in the worksheet. An alternative would be to simply unhide all of the columns that are hidden in the spreadsheet, […]

If you have ever printed a lot of different similar-looking reports, then you know how helpful it can be to have those reports include identifying information in the header or footer. You can also identify different worksheets within an Excel file by changing their worksheet names. If you would like to include your worksheet name in […]

Microsoft Excel 2010 can do a lot of different things, leading many users to take advantage of the program whenever possible. But there are certain functions that Excel cannot perform. Some of these functions can be added to the program through the use of Add-Ins, which help to extend the capabilities of Excel. But if […]