In some cases, you may want to hide particular rows or columns. Hiding rows and columns may be useful if you don’t want users to see certain information or if you need to print a report that summarizes the information in the worksheet without showing all the details.

To hide rows or columns in your worksheet, select the row or rows that you want to hide by clicking in the row or column header. Then right-click and choose Hide from the shortcut menu. Or, you can use the commands on the Home?Cells?Format drop-down list.

A hidden row is actually a row with its height set to zero. Similarly, a hidden column has a column width of zero. When you use the arrow keys to move the cell pointer, cells in hidden rows or columns are skipped.

Unhiding a hidden row or column can be a bit tricky because selecting a row or column that’s hidden is difficult. The solution is to select the columns or rows that are adjacent to the hidden column or row. (Select at least one column or row on either side.) Then right-click and choose Unhide. For example, if column G is hidden, select columns F and H.

Another method is to choose Home?Find & Select?Go To (or its F5 equivalent) to select a cell in a hidden row or column. For example, if column A is hidden, you can press F5 and specify cell A1 (or any other cell in column A) to move the cell pointer to the hidden column. Then you can choose Home?Cells? Format?Hide & Unhide?Unhide Columns.

• Magnetic Rowing Machine You just can't beat a magnetic rowing machine when your goal is to achieve total body aerobic exercise. Magnetic rowing...
• How to convert video. Mov in. Avi The. Mov is created at the time specifically for video and movies from only view with Quicktime Player, a kind...
• Mona Lisa Palace. Hotel Lisboa At the Mona Lisa Palace the die-hard Tombola fans can enjoy the fun of the game every Saturday, Sunday and...
• Home Remodel Budget Template Many people dream of remodeling as their homes get older. Before you make a decision on home remodeling, you have...
• Google Fusion Tables Could be a Game Changer Google has been very busy lately with many new products recently. Many of them, such as Google Public DNS, Google...