![]() 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. ![]() Right-click a sheet tab, and then click Select All Sheets on the shortcut menu. Then hold down Command while you click the tabs of the other sheets that you want to select. And In this post I will show you few ways by which you can unhide hidden columns in Excel. I believe when working in Excel, we come to the point where we want to Hide a Column or a Row, in order to understand the data in the Worksheet. 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. Many people face complications while unhiding columns in Excel. ![]() In the Editing group, click on the Find button and select 'Go To' from the popup menu. 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. Question: How do I unhide column A in a sheet in Microsoft Excel 2013 Answer: Select the HOME tab from the toolbar at the top of the screen. Select the worksheets that you want to hide.
0 Comments
Leave a Reply. |