Using a simple feature within Excel, we can keep a data set uncluttered, while avoiding the loss of functionality created by deleting the data entirely.

  1. Open an Excel workbook. In this case, I’m going to create a new workbook, and then add dummy data to demonstrate the steps involved in hiding columns or rows. 
  2. From this data set, we’re going to hide the employee’s Social Security Numbers from a printed document by first selecting the column we wish to hide. Select a column by clicking its heading, in this case C, to select all. 
  3. Right click anywhere in the selected area and choose Hide. 
  4. You can do the same thing for entire rows by following steps 1 through 3, and selecting a row instead of a column. 
  5. To bring the columns back, just right click anywhere on the page and select Unhide. 

Microsoft Excel Tips

Previous TipNext Tip

Use VLOOKUP in ExcelBack Up Files Automatically in ExcelRemove Duplicate Data in ExcelCreate a Waterfall Chart in ExcelLock Cells in ExcelFreeze Rows and Columns in ExcelBuild a Forecast Chart in ExcelCreate a Funnel Chart in ExcelMake a Treemap in ExcelConvert Excel Sheets to Google SheetsOpen Google Sheets in ExcelCombine Data from Different CellsMerge Cells to Span Multiple ColumnsUse AutoFill for Repetitive DataCopy and Paste Repetitive Data the Easy WayUse Text to ColumnsDraw Diagonal Line in a CellCreate a New Shortcut MenuTranspose Columns Using Paste Special