In Ms Excel worksheet how can I unhide multiple sheets at same time without macros? And what is the short cut?

Start networking and exchanging professional insights

Next Question:
How to send multiple emails at once from outlook by using ms-excel?
Posted by:
Shahbaz Aklekar
07-May-2013

Retail Accounting Microsoft Office MS Office tools

Question added by ANURAJ KAITHAVALAPPIL , Chief Accountant , Barakat
Date Posted: 2016/12/06

Upvote (0) Views (11) Followers (3) Answers (3) Report Question

Write an Answer
Register now or log in to answer.

3 Answers

by preejith a , JUNIOR ENGINEER , CHOWEL INDIA PVT LTD

Alt+F11 (opens the VB Editor Window)
Ctrl+G (opens the Immediate Window)
Paste the following line of code in the Immediate Window and press EnterFor Each ws In Sheets:ws.Visible=True:Next

Upvote (0)

Downvote Reply () Report

by Mohammed Mahmoud Khairy Ahmed Mostafa , Branch Manager, Structural Design Engineer , Ossiad Consultant Office

on the Home tab choose Format, Hide and Unhide, and then Hide Sheet. Or, to save a couple of steps, right-click on the worksheet tab and then choose Hide in excel 2007 and later

Upvote (0)

Downvote Reply () Report

by AbuSufyan Cheema , Accounts Payable Manager , PioneerTechnical Factory for Electric Circuits

Select all the sheets that you want to be hide, then right click on sheet tab and press hide. I think there is no direct short key to hide multiple sheets.

Upvote (0)

Downvote Reply () Report