Hiding lines, or rows, in Microsoft Office Excel 2010 is very simple: Right-click the lines and select "Hide." However, expanding the hidden lines in the Excel spreadsheet is not as simple. To get ...

Learn how to show charts with hidden data cells in Excel. When there is data that is hidden in your table, Excel will not show that information in the chart.

How to Find Hidden Microsoft Excel Cell References. Microsoft Excel displays all cell references by default. When you click on a cell, its column and row references are highlighted in the ...

You can remove leading, trailing, and extra spaces between characters and numbers in Excel using TRIM(), SUBSTITUTE() or Find and Replace.

You can search in Excel with the Search Sheet bar, and use Find and Replace to swap out terms or values. Here's how to do it.