LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
Labrador_68
 
Posts: n/a
Default Your prayers have been answered: GRIDLINE Answers are Here!

DON'T YOU JUST HATE seeing the SAME OLD TIRED ANSWER, over and over again
when it comes to a GRIDLINE inquiry? (blah, blah, <Tools, <Options, then
<View, then click the <Gridlines checkbox to disable/enable gridlines)
YUCK!!!

DON'T GIVE UP NOW FRIENDS, because I know EXACTLY what you REALLY WANNA
KNOW! Most of you simply wanna turn them OFF & ON upon your DISPLAY just
like a LIGHTSWITCH, without having to DRILL DOWN into multiple menus each and
every time, RIGHT?

YES, as most of you suspected, there REALLY IS A SIMPLE BUTTON you can
permanently add to your toolbars forever, EMPOWERING YOU to simply click on
one button so that your GRIDLINES are either ON or OFF, showing up OR not
showing up on your worksheet/display with ONE click of the mouse!!!

WELL, here's HOW TO SETUP your GRIDLINE TOGGLE SWITCH to VIEW or to HIDE.

1) First, GO to <VIEW, and then choose <TOOLBARS

2) Scroll down list of Toolbars shown & choose the very last one: <CUSTOMIZE

3) Then, choose the <COMMANDS tab, and scroll down the LEFTHAND window of
toolbars until you reach <FORMS... Okay, highlight/choose the <FORMS item.

4) Move to the RIGHT HAND panel and scroll down until you reach <TOGGLE GRID

5) GRAB it with your MOUSE, and DRAG -n- DROP this BUTTON up to any toolbar
near your MENU, and placing it between ANY OTHER Tools & Buttons you
currently have displayed. Simply choose the most logical set of tools to
which to drop it -- I place mine near the <BORDERS drop down tools...

6) HEY, CONGRATULATIONS!
You have just permanently added the tool/button that acts as a LIGHTSWITCH
to either VIEW the gridlines, OR turn them OFF altogether w/ only one click
of your mouse!

Happy Toggling Those Gridlines...
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
in a line of three possible answers how to prevent multiple answer RichardZ Excel Worksheet Functions 1 September 7th 05 01:46 PM
After using a formula how can I filter out answers I don't want? Em Excel Worksheet Functions 2 July 26th 05 02:38 PM
Pivot Table for survey results with set of possible answers in PT's Rows Field? [email protected] Excel Discussion (Misc queries) 0 May 16th 05 10:35 PM
counting Multiple answers in 1 cell + column help me i have an excel problem Excel Discussion (Misc queries) 0 February 21st 05 08:41 AM
How do I have a list of possible answers auto put into a cell? smags Excel Worksheet Functions 1 January 31st 05 03:52 AM


All times are GMT +1. The time now is 02:36 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"