This topic has been archived. It cannot be replied.
-
工作学习 / 专业知识杂谈 / 请教一个Excel的问题：每次打开Excel文件，我都喜欢把网格线(gridlines)去掉，这样看着眼睛舒服些，怎样把这个设置成缺省？记得Word中有个叫default template是用于保存缺省设置的，但Excel里没找到，请指教
-works(works);
2006-8-8
(#3130531@0)
-
What I did to get rid the gridlines:create a macro to disable the gridlines and save it in one xlt file and save this file in xlstart folder. every time when excel starts, this macro will run. But this is a compromise to excel file security unless you know exactly what this macro does.
-chenrulai(BlueSky);
2006-8-9
{250}
(#3131759@0)
-
要不你试试这个。tools - > Customize -> tab (commands) 下的Forms，在右栏找到Toggle Grid 图标拖到工具兰里。以后每次点一下就行了
-lizpan(M6);
2006-8-9
(#3131781@0)
-
New book, unchecked the gridlines from Tools->Option->View, save it as Book.xlt and put the Book.xlt into C:\Documents and Settings\YOURUSERNAME\Application Data\Microsoft\Excel\XLSTART folder.
-sunday8(sunday8);
2006-8-9
(#3132116@0)
-
感谢以上各位热心回复。试了试，发现BlueSky的宏命令方法可行，以前我也是这么干的，但有点复杂；sunday8的方法只适用于新建文件，不适用于打开已有文件；M6的方法最简单，且是现成的
-works(works);
2006-8-10
(#3135055@0)