The gridlines on all worksheet doesn't appear. How can I get this to come up.

Dear Shaina

Thank you attending Excel Adv course. I hope you enjoyed the course.

I wasn't sure if you are asking about the gridlines or the borders. It is very easy to confuse between the two. I am sure you are proficient in applying the borders. Just to remind you it can be found in the home Tab on the Ribbon under the Font group.

However, I suspect that you are inquiring about the disappearance of the gridlines that sometimes happen when you either use the Fill handle to copy and paste the formulae/functions or simply copy and paste cells. I personally believe that this is some kind of bug within MS Office. Simply drag over the cells and the gridlines reappear magically. It may be something to do with the processor not being able to cope with the processes in hand and therefore not completing the tasks such as making your gridlines reappear.

Please let me know if that resolves the problem.

If this posting has helped in answering your query then I would request you to mark the posting as Resolved. If, however, it hasn’t and you need further clarification then please press the reply button and ask for further clarification with your specific question. In case you have a related question then please as the question as a separate posting.

Kindest Regards

Rajeev Rawat
MOS Master Instructor 2000 and 2003