Posted on Fri 7 Oct 2011Sat 30 Dec 2023 by Richard BaileyHide Rows Columns In large tables or summaries in Excel 2010 it can be useful to be able to hide rows. In this guide we will run through how to hide rows. This is what you do: 1. Select the rows you want to hide. 2. Right click the selection. 3. Click Hide.