There is also a keyboard shortcut to perform this action, Shift – Alt – Right arrow after selecting the rows. Select the desired rows, and from the Excel main horizontal menu, open the Data tab, and left mouse click the Group option. You can have many groups, but the rows in each group have to be contiguous.
In this final method, which is an indirect way of hiding rows by grouping them, a requirement is that the selected rows in each group must be contiguous. Select Hide & Unhide > Hide Rows to hide the selected rows. Then, from the Excel main horizontal menu, go to the Home tab and left mouse click on Format to open the drop down menu. In the second method, again begin by selecting the contiguous or non-contiguous rows to be hidden. Left mouse click the Hide option, and all selected rows will now be hidden. Next, right mouse click on the highlighted rows to bring up the context menu. The rows can be non-contiguous (hold down the Control key while selecting each row). To hide one or more rows, start by selecting the rows. There are a few different ways to to do this, which we will now take a look at.
#How to unhide a column in excel 2010 how to#
In order to understand how to unhide rows and columns, it helps to know how to hide them in the first place. Obviously, it’s just the hidden rows (or columns), but how do you detect that rows and columns have been hidden, and more importantly, how do you unhide these columns and rows in an Excel spreadsheet? This can become quite frustrating when trying to compare rows that are disparately located throughout the spreadsheet.Īnd although not as common, scrolling horizontally left and right, can also be just as annoying.Ī quick solution to the problem is to hide any intervening rows or columns, so that the required information appears in contiguous rows (or adjacent columns), ideally within a single screen.Īll well and good, but then when you share the spreadsheet with someone else who is unaware of the hidden rows, or you access the spreadsheet after some period of time has passed and have forgotten about hidden content, it appears as if information is missing or has been deleted.
It can sometimes take a good amount of scrolling (not only vertically but also horizontally), while wading through row after row of data looking for the required bits of information. Excel spreadsheets can grow quite large as data is added, spanning several screenfuls.
0 kommentar(er)
