Hello,
I gave link from Sheet1 to Sheet2 in MS Excel. Now if I hide Sheet2, the link of Sheet1 does not work.
I heard that I can hide all the cells of Sheet2 in that situation.
But the problem is I don’t know how to hide the cells of a Sheet in Excel.
Can anyone please help me in this regard?
I am currently using MS Excel 2003, however, the same steps apply to other version although it has a different format:
I hope this helps!
In a situation where you have given link from sheet 1 to sheet 2 although your sheet 2 is hidden those links should work. I think you may have done error in hiding cells. If you want to hide sheet 2 you can use one of following two methods.Those methods are,
1. Right click on the sheet name (That is sheet 2) and click on the “Hide” option. Then the entire sheet will be hidden.
2. Click on the rectangular on left upper corner (to select all the cells) and right click on the Column “A” and click hide. Then the all the cells will be hidden However sheet 2 will still available.
As above you can hide the data in sheet 2 without affecting the links from Sheet 1.
I think this answer might be fairly enough for you to solve the problem.
