Learn more at the Excel Help Center: https://. Please send us your comments on this article. Hide or unhide columns in your Microsoft Excel spreadsheet to show just the data that you need to see or print. Or Press Alt + H + O + U + O.Īll rows in the worksheet have been redisplayed. Press Shift + F10 to bring up the context menu. Press Shift + ↓ (Down Arrow key) to select the top and bottom of the hidden row. Press Shift + Space to select the entire row. Press Shift + ↓ (Down Arrow key) to select the cells above and below the hidden row. Unhide row shortcutĬommand + shift + 9 or control + shift + 9 Use the shortcut key to unhide a rowĮxplains how to use the shortcut keys to unhide a row. In addition to how to redisplay rows using the shortcut keys, we also explain how to redisplay rows from the context menu and how to redisplay all rows in a worksheet. If you want to show the data of a temporarily hidden row later, you can use a convenient shortcut key to redisplay the row. Select the Between input languages item, then press Alt+C to select the Change Key Sequence item. Run the Control Panel, and select Region and Language. Just as you can quickly hide a row, you can also redisplay a hidden row. In Windows 7, try this to get this shortcut to work in Excel: 1. Written in Excel for Microsoft 365 version 2201. Unhide rows in Excel shortcut - Excel Hack Unhide rows in Excel shortcut
0 Comments
Leave a Reply. |