![]() ![]() This is the long answer (the code Excel VBA generates when you record a Macro). You can definitely shorten this up. For instance, you don't need to set the.ColorIndex or.TintAndShade properties just to do a standard black [edit] border. Normally the cells show as Rectangles in Excel. However, in some cases users want the cells show as squares and make a grid paper of worksheet. In this article I will show you how to make a worksheet as grid paper, and save it as a template in Excel. Create a grid paper template with shape of square in Excel (7 steps). Add gridlines to an Excel sheet. Ask Question. Up vote 0 down vote favorite. In the below code, how can I add grid-lines to the entire Excel sheet?
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. Archives
March 2018
Categories |