How to hide or unhide rows or columns using shortcut key Step 3: Under Visibility, point to Hide & Unhide, and then click Unhide Rows or Unhide Columns. Or press Ctrl+A to select all cells on a worksheet. Option 2: Show all hidden rows and columns at the same time. When you find there is a row or column hidden, you can simply drag the gridline to show it. Option 1: Unhide a row or column by dragging the gridline. ![]() Option 2: Go to the Home tab, click Format, point to Hide & Unhide, then click Hide Rows or Hide Columns. Option 1: Right-click and select Hide row or Hide column from the menu that appears, To hide rows or columns in Excel worksheet, select the rows or columns that you want to hide. In this guide, you will learn several ways to show or hide a row or column, and display all hidden rows and columns at the same time. This is a quick guide on how to hide a row or column in Excel. How to Hide or Unhide Rows or Columns in Excel
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |