I hid some rows in a spreadsheet but am unable to unhide them.Ive tried: Selecting row above or below hidden rows, choose Table menu, both options to unhide are greyed out.
Selecting a cell in the spreadsheet, choose Table, again both options to unhide are greyed out Selecting row above or below and clicking drop-down next to row number, no option available to unhide, only to hide that row. ![]() ![]() Apple may provide or recommend responses as a possible solution based on the information provided; every potential issue may involve several factors not detailed in the conversations captured in an electronic forum and Apple can therefore provide no guarantee as to the efficacy of any proposed solutions on the community forums. Apple disclaims any and all liability for the acts, omissions and conduct of any third parties in connection with or related to your use of the site. All postings and use of the content on this site are subject to the. However in certain cases we cannot group rows or columns rather we need to hide those rows and columns, so this task is often regular for regular excel users so maintaining the efficient way of doing this is very important. Unable To Unhide Column A In Excel How To Hide RowsIn this article, we will show you how to hide rows and columns in excel using the shortcut keys to work efficiently. Unable To Unhide Column A In Excel Manual Way OfTo hide rows and columns we have several methods, first, let me show you a manual way of hiding rows and columns in excel. After selecting the column that we need to hide right click on that column header and choose Hide option. In earlier cases, we need to select the row or column before we choose the hide option, but using excel shortcuts we need not do all these. By holding the Ctrl key press number 9 from keyboard numbers. Here we discuss how to hide rows and columns in excel using the shortcut keys to work easily along with practical examples and downloadable excel template. CFA And Chartered Financial Analyst Are Registered Trademarks Owned By CFA Institute. By closing this banner, scrolling this page, clicking a link or continuing to browse otherwise, you agree to our Privacy Policy.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. Archives
December 2020
Categories |