How do I hide columns or rows of data without deleting them, and then unhide them when needed in Excel 2007? To hide rows or columns first select a row or several rows and then right click that selection, or on Home Tab in Cells group click Format button, to Hide and Unhide and click Hide. Of course once hidden they won't print either. To unhide your columns or rows you have to select the row or column before and after the row or column is hidden, and so you'll be selecting two of them, and then go ahead and right click your selection to unhide. The fastest way to understand how to hide and unhide your rows or columns is to watch our training videos!

Purchase the training video and you can see this in action for yourself!