I like to hide grid lines on my spreadsheets and charts whenever possible. I think removing gridlines makes the charts and worksheets more presentable. In case you are wondering how to remove (or hide) gridlines,
To hide grid lines on an excel worksheet:
Excel 2007 and greater: Go to View Ribbon and uncheck the “Gridlines” option. You can also press ALT + WVG
Excel 2003 and earlier: Click on Tools > Options and then in the View tab uncheck “grid lines” option.
To hide grid lines when you are printing an excel sheet:
Excel 2007 and greater: Go to Page Layout Ribbon and uncheck the “Print” option under Gridlines area. You can also press ALT + PPG
Excel 2003 and earlier: Go to “Print Preview” and uncheck “gridlines” in “Print” tab.
To Remove grid lines from a chart:
Select the gridlines in the chart and hit delete.
What do you think about gridlines ?
Do you like them or do you try to remove then whenever you can?
4 Responses to “Office 2010 Contest Winners are here!!!”
I while ago I wrote a post on selecting a couple of names from a range via an UDF
I could have been handy.... especially because I didn't win.... lol
http://xlns.lamkamp.nl/?p=14
Sweet! I won! Thank you so much, Chandoo! I'm really speechless! I'll look out for an e-mail from you. Again, I really appreciate it, and I can't wait to fire it up!
Sincerely,
Tom "this one" 🙂
Thank You... Thank You... Thank You... 🙂
Hi,
Don't want to ruin your party.. 😉 but I noticed that when you sort the list A2:B11 (step 2), the RAND function re-calculates the numbers so that they are different and in mixed order again. I had to paste the whole area as values first and then sort to get it to work.
Wonder if the same happened to you because in your list at least Greg has a higher value than Tom 🙂