We hope this article has been helpful to you. The hidden rows or columns are shown at once. The selected rows or columns are hidden immediately. ‣ Then the minus sign is displayed on the left of selected rows, or displayed at the top of the selected columns. ‣ Select the entire rows or columns you need to hide or unhide with a plus or minus sign, then click Group in the Outline group under the Data tab. Please do as follows hide or unhide rows or columns with plus or minus signs in Excel. Hide/Unhide Rows Or Columns With Plus Or Minus Sign ‣ Either way, the selected rows will be hidden from view straight away. ‣ Alternatively, you can click Home tab >Format > Row Height… and type 0 in the Row Height box. ‣ Under Visibility, point to Hide & Unhide, and then select Hide Rows. ‣ Go to the Home tab > Cells group and click the Format button.

If you enjoy working with the ribbon, you can hide rows in this way: This will reveal all hidden rows, a feature especially helpful if you’ve hidden multiple rows throughout a large spreadsheet. You’ll find options to hide and unhide both rows and columns. ‣ Click “Format,” which is on the right-hand side of the toolbar. ‣ To unhide all hidden rows in Excel, navigate to the “Home” tab. ‣ Also, see using Data validation in Excel. ‣ Select the columns (or cells in the columns) to the left and right of the hidden column. ‣ Select the rows (or cells in the rows) above and below the hidden row. ‣ Select the column (or a cell in the column) you want to hide. ‣ In the Format submenu, click Hide & Unhide. ‣ On the Home tab, in the Cells group, click Format. ‣ Select the row (or a cell in the row) you want to hide. Methods to Hide or Unhide Columns and Rows How to Get Roman Numerals in Microsoft Word: Steps Simplified.Peso Sign in Microsoft Word: Steps on How to Type the Peso Sign.How to Delete Horizontal Lines in Microsoft Word That Won’t Go Away.You can also achieve this by using the drop-down menu in the Home tab. You can hide, and later unhide, columns by right-clicking in the spreadsheet. 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. 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.Įxcel is great for sorting large amounts of data, whether it involves alphabetizing, adding, or merging cells. 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. Get to know 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.

How to unhide a column in excel 2013