Discussion on:
View:
Show:
Not a big deal if you've already moved on to another version of Office.
No such thing as too much info. Thanks for sharing. Please don't let a few negative folks dissuade you from sharing in the future. There are many of us out here appreciating ALL that's offered. Thanks again
So trivial, yet a pain in the butt to correct if you didn't know the term "gridlines".
As stated by another member this is a very "trivial" feature and not worthy of mention on this forum. It simply changes the cosmetic appearance.
It does NOT have the claimed effect of preventing data entry. Just because gridlines are not visible does not stop a user moving to a cell and entering data. To prevent data entry a combination of "locking" cells and worksheet "protection" is needed - at least in all versions of Excel up to 2000.
It does NOT have the claimed effect of preventing data entry. Just because gridlines are not visible does not stop a user moving to a cell and entering data. To prevent data entry a combination of "locking" cells and worksheet "protection" is needed - at least in all versions of Excel up to 2000.
Prevent, in this usage, means to ensure that the user is not confused. By turning off gridlines and ensuring that only the cells you wish to have filled have borders you are preventing your user from becoming confused and possibly upset.
this section is called tips if u knw, good for u,, if knw more tell us, but dont do like many "knw it all" guys and brag.......... thats shallow!!!!!!!!!!
Hi,
I personally dont think this is too trivial for the forum since looking at some of the replies to this and other tips it seems there are members learning about Excel at all levels. However, I have to technically agree with Graham on the meaning of prevent.
Maybe discourage would have been a better choice of word in the original context.
Regards
Paul
IT Trainer in Hobart, Tasmania, Australia
I personally dont think this is too trivial for the forum since looking at some of the replies to this and other tips it seems there are members learning about Excel at all levels. However, I have to technically agree with Graham on the meaning of prevent.
Maybe discourage would have been a better choice of word in the original context.
Regards
Paul
IT Trainer in Hobart, Tasmania, Australia
Thanks for the tip. Being a student it helps to practice these things.
This infomation was usefull, thank you.
Have a question thought -
How do I add the gridlines (turn on/off) icon on the quick access Toolbar- Excel 2007 ?
Have a question thought -
How do I add the gridlines (turn on/off) icon on the quick access Toolbar- Excel 2007 ?
Great feature - together with hiding row numbers and column letters - been there since before Office 97! Although (as pointed out elsewhere) is a cosmetic feature can give a professionally finished impresssion for situations where end users dont need the understanding just the functionality of the application developed. Of course in many situations ignoring such cosmetic features is legitimate too - just demonstartes the diversity in both the product and users.
Thanks.
Thanks.
- Keyboard Shortcuts:
- Prev
- Next
- Toggle









































