Why does the hidden line disappear in Excel2013

Hi, Why does  the hidden line  disappear in Excel2013. Please see the circle B in the picture in attachment. Even if I regulate it with the circle A, it does not appear. Any one can give me some suggestion ? Thank you
Capture.PNG
eemoonAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

helpfinderIT ConsultantCommented:
did you click on the small arrow on the right side of the icon and choose proper bordering?
0
eemoonAuthor Commented:
Thank you so much for your fast reply.
did you click on the small arrow on the right side of the icon and choose proper bordering?
I did not find the small arrow. Can you tell in detail ?
0
helpfinderIT ConsultantCommented:
see red circle
Capture.PNG
0
Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

eemoonAuthor Commented:
I guess all of that you mentioned are not related with the issue. The hidden line can not be printed in normal situation. The reason why it is lost is that I moved these cells, and then the line disappear in the original loacation.
0
Saurabh Singh TeotiaCommented:
It's a formatting of the cell which makes this happens and it can be due to multiple reasons..the simplest way to solve this is select column-e or f do a ctrl+c..

Then go to column-g and do paste special-->formats and you will see the lines being back..

Alternatively you can use paint brush as well and repeat the above exercise to do what you are looking for..

Saurabh...
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
QlemoBatchelor, Developer and EE Topic AdvisorCommented:
The "hidden" lines are only displayed if you have not set up a background color for the cells. When moving cells, the source cells are filled with the default background color. In opposition to the cells of a new sheet, the default color is not "none" but usually white.
So all you have to do is to select that column, and set the background color to none.
0
Katie PierceCommented:
Also, if you're having trouble with it printing, make sure that you check or reset your Print Area.  Cutting and pasting cells could affect your Print Area if you have one set.
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Excel

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.