How to hide cells in Excel?

Asked By Jordan Hill 40 points N/A Posted on - 04/07/2012

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?

• Status: Open
• Question Views: 1367
• Answer Count: 2
• Vote Up 0 Vote Down

• Answer Accepted: Yes
• Question Category: MS Excel

Best Answer by Aeron Hogyu

Go To Solution

Best Answer

Best Answer

Answered By Aeron Hogyu 5 points N/A #120071

How to hide cells in Excel?

I am currently using  MS Excel 2003, however, the same steps apply to other version although it has a different format:

• Select all the cells in the sheet you want to hide. Drag your mouse to the upper portion (the one with capital letters) if you want to hide the columns or drag it to the leftmost portion (those with numbers) if you want to hide the rows.

• Right-click the mouse and select Hide. 

•  As you can see in my illustration, the cells that I’ve selected are already hidden.

• You can also unhide the cells by clicking the upper-leftmost portion of the worksheet; right click using your mouse and select Unhide.

I hope this helps!

About Aeron Hogyu

Questions
2

Answers
31

Best Answers
8

• Vote Up 0 Vote Down

• Posted on - 04/07/2012
• Question Category: MS Excel

Answered By Sherin Viluel 0 points N/A #120072

How to hide cells in Excel?

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.

About Sherin Viluel

Questions
0

Answers
50

Best Answers
37

• Vote Up 0 Vote Down

• Posted on - 06/16/2012
• Question Category: MS Excel