Managing Rows and Columns in Excel

Guest author David H. Ringstrom, CPA,www.accountingadvisors.com Users often hide rows or columns in a spreadsheet to conceal private data, or perhaps just to keep a large spreadsheet manageable. This is a helpful feature in Excel, but many users often go about managing rows the hard way: Excel 2007 or later: In the Cells section of the Home tab choose Format, Hide & Hide, and then make a selection as to what to hide or unhide. Excel 2003 and earlier: Choose Row or Column and then Hide or Unhide, respectively. Hiding rows is fairly straight forward, as you can select the rows or columns, and then carry out the aforementioned menu command. To unhide rows or columns, you must select rows above and below the hidden section, or columns to the left and right of the hidden section, and then carry out the menu command. Constantly navigating the menus to hide and unhide rows or … [Read more...]