HOW TO UNHIDE A HIDDEN TAB IN AN EXCEL WORKBOOK
1	HERE'S A SCREEN CAPTURE OF A TYPICAL WORKSHEET IN AN EXCEL WORKBOOK.  IT SHOWS THE ROW OF TABS ACROSS THE BOTTOM OF THE SCREEN.  EACH TAB IS A UNIQUE WORKSHEET WITH 17 BILLION CELLS.  BUT WAIT! THE DIRECTIONS SAID TO LOOK FOR THE 'WHO'S COMING LIST", TAB 1B.  WHERE IS IT?  WELL, IT'S THERE , BUT IT'S HIDDEN.
2	TO UNHIDE A TAB POINT TO ANY TAB, RIGHT CLICK & SELECT UNHIDE.
3	THE "UNHIDE" BOX WILL POP UP DISPLAYING ALL THE HIDDEN TABS IN THIS WORKBOOK.  SELECT THE TAB(S) YOU WANT TO UNHIDE.
4	IMMEDIATELY, THE REQUESTED TABS ARE RESTORED TO THEIR ORIGINAL PLACE AT THE BOTTOM OF THE WORKSHEET.  WOW!  EXCEL MAGIC.
5	TO RE-HIDE THE TAB JUST REVERSE THE PROCESS.  POINT TO THE TAB YOU WANT TO HIDE, RIGHT CLICK IT & CLICK "HIDE".  EASY-PEASY.

<RETURN TO TOP>

This page last updated on Friday, December 22, 2023 by Ed Crane, webmaster since 2006