HomeTechnologyHow to Hide and Unhide Columns and Rows in Excel How to Hide and Unhide Columns and Rows in Excel By Lucas TMLT December 11, 2020 Technology 0 Comments How to Hide and Unhide Columns and Rows in Excel. How to Hide and Unhide Columns and Rows in Excel: You can easily hide columns when working within an Excel spreadsheet and just as easily unhide them. Keep reading if you want to continue. If you want to prevent users from wandering into parts of a worksheet you don’t want them to see, then hide such rows from their view. This technique is often used to conceal sensitive data or formulas, but you may also wish to hide unused or unimportant areas to keep your users focused on relevant information. Excel is great for sorting large amounts of data, whether it involves alphabetizing, adding, or merging cells. While organizing this data, you may find it helpful to hide columns you are no longer using, but don’t want to delete from your document. You can hide, and later unhide, columns by right-clicking in the spreadsheet. You can also achieve this by using the drop-down menu in the Home tab. READ ALSO: How to Delete Horizontal Lines in Microsoft Word That Won’t Go Away Peso Sign in Microsoft Word: Steps on How to Type the Peso Sign How to Get Roman Numerals in Microsoft Word: Steps Simplified Methods to Hide or Unhide Columns and Rows To hide a row: Select the row (or a cell in the row) you want to hide. On the Home tab, in the Cells group, click Format. In the Format submenu, click Hide & Unhide. Choose Hide Rows. To hide a column: Select the column (or a cell in the column) you want to hide. On the Home tab, in the Cells group, click Format. In the Format submenu, click Hide & Unhide. Choose Hide Columns. To unhide a row: Select the rows (or cells in the rows) above and below the hidden row. On the Home tab, in the Cells group, click Format. In the Format submenu, click Hide & Unhide. Choose Unhide Rows. To unhide a column: Select the columns (or cells in the columns) to the left and right of the hidden column. On the Home tab, in the Cells group, click Format. In the Format submenu, click Hide & Unhide. Choose Unhide Columns. Also, see using Data validation in Excel. How to Unhide All Rows in Excel To unhide all hidden rows in Excel, navigate to the “Home” tab. Click “Format,” which is located towards the right-hand side of the toolbar. Navigate to the “Visibility” section. You’ll find options to hide and unhide both rows and columns. Hover over “Hide & Unhide.” Select “Unhide Rows” from the list. This will reveal all hidden rows, a feature especially helpful if you’ve hidden multiple rows throughout a large spreadsheet. Hide Rows Using the Ribbon If you enjoy working with the ribbon, you can hide rows in this way: Go to the Home tab > Cells group, and click the Format button. Under Visibility, point to Hide & Unhide, and then select Hide Rows. Alternatively, you can click Home tab >Format > Row Height… and type 0 in the Row Height box. Either way, the selected rows will be hidden from view straight away. Hide/Unhide Rows Or Columns With Plus Or Minus Sign Please do as follows to hide or unhide rows or columns with plus or minus sign in Excel. Select the entire rows or columns you need to hide or unhide with plus or minus sign, then click Group in the Outline group under Data tab. See screenshot: Then the minus sign is displayed on the left of selected rows, or displayed at the top of the selected columns. Click the minus sign, the selected rows or column are hidden immediately. And click the Plus sign, the hidden rows or columns are showing at once. Tags:create a button in excel to hide/unhide rows when clicked, excel hide columns with + how to hide columns in excel with plus sign, how to hide unused columns in excel, unhide columns in excel, unhide columns in excel shortcut Related Posts How to Get a Free CPAP: CPAP Assistance Programs Best Expense Tracker and Budget App Available for you How to Download Cool Books From Google Books About Author Lucas TMLT Add a Comment Cancel replyYour email address will not be published. Required fields are marked *Comment:*Name:* Email Address:* Website: Save my name, email, and website in this browser for the next time I comment.