![]() ![]() 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 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |