![]() ![]() ![]() It was sent to me in email, and I do not have permission to share it publicly. But when I subsequently enter 1:1048576 (or 1348:1048576 or just 1348:1356) into the Name Box, right-click on a highlighted row title (1 or 1348) and click on Unhide, nothing changes. I cannot share the Excel file at the moment. When I enter A:XFD into the Name Box, right-click on a highlighted column title (A, B, etc) and click on Unhide, it displays all columns A:XFD. I tried saving and re-opening the file after my apparently-failed unhide efforts, to no avail. I have ensured that Freeze Panes is not set, and there is no active Filter. In yet other worksheets in the file, I unhide both A:XFD and 1:1048576 that is, the entire worksheet. In some other worksheeets in the file, I can unhide 1:1048576, but not A:XFD. ![]() I cannot seem to unhide rows after 1348, even to row 1356, the last row in ActiveSheet.UsedRange. The last visible continues to be row 1348. Selecting the option Format from the Cells group of the Home tab on the Excel ribbon and, from within the Format drop-down menu, selecting Hide & Unhide->Unhide Columns. When I enter A:XFD into the Name Box, right-click on a highlighted column title (A, B, etc) and click on Unhide, it displays all columns A:XFD.īut when I subsequently enter 1:1048576 (or 1348:1048576 or just 1348:1356) into the Name Box, right-click on a highlighted row title (1 or 1348) and click on Unhide, nothing changes. Unhide the selected columns by either: Using the mouse to right-click on the selected column(s) and then selecting Unhide from the right-click menu. I have a worksheet that currently displays only rows 1:1348 and columns A:O. The tip should work for unhiding the first row or column in a table unless its also the first row or column in the spreadsheet. How can I reliably unhide all rows and columns? ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |