To hide an entire row, right-click on the row number and select “Hide”. If you have a large worksheet, you might want to hide some rows and columns for data you don’t currently need to view. Also, the original value in the hidden cell will be replaced with the new value or formula that you type into the cell. NOTE: If you type anything into cells in which you hid the content, it will automatically be hidden after you press “Enter”. To unhide the content in the cells, follow the same steps listed above, but choose the original number category and type for the cells rather than “Custom” and the three semicolons. The data in the selected cells is now hidden, but the value or the formula is still in the cell and displays in the “Formula Bar”.
