Unit 13: Row & Column Formatting


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 particular information, or if you need to print a report that summarizes the information in the worksheet without showing all the details.

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

To hide columns, use the same technique, but start by selecting columns rather than rows.

Excel displays a narrow column heading for hidden columns and a very narrow row heading for hidden rows. You can drag the column heading to make the column wider – and make it visible again. For a hidden row, drag the small row heading to make the column visible. Another way to unhide a row or column is to choose Home → Editing → Find & Select → Go To (or it’s 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 to move the cell pointer to the hidden column. Then you can choose Home → Cells → Format → Hide & Unhide → Unhide Columns.

UNIT 13 – Row And Column Formatting


There aren't any posts currently published in this category.