The Unhide dialog box displays a list of hidden sheets, so select the ones you want to unhide and then select OK.Ĭlick the Window menu, click Hide or Unhide. To unhide worksheets, follow the same steps, but select Unhide. On the Home tab, click Format > under Visibility > Hide & Unhide > Hide Sheet. In Step 3 of the Convert Text to Column Wizard, we must select the Text option under Column data format. In the next window (or wizard), we must click the Next button in Steps 1 and 2. This will open Convert Text to Column Wizard. Right-click a sheet tab, and then click Select All Sheets on the shortcut menu. Next, we need to go to the Data tab and click the Text to Columns button under the Data Tools section. Then, right-click and pick Unhide in the shortcut menu. You can do this easily by dragging through them. Select the columns on each side of the hidden column(s). Then hold down Command while you click the tabs of the other sheets that you want to select. When you’re ready to view those hidden columns, unhiding them is just as simple as hiding them. Then hold down Shift while you click the tab for the last sheet that you want to select.Ĭlick the tab for the first sheet. If you don't see the tab that you want, click the scrolling buttons to the left of the sheet tabs to display the tab, and then click the tab.Ĭlick the tab for the first sheet. Select the worksheets that you want to hide.
0 Comments
Leave a Reply. |