+ Reply to Thread
Results 1 to 5 of 5

Can the Excel 'cursor' or 'cell outline' color be changed?

  1. #1
    Registered User
    Join Date
    03-23-2007
    Posts
    6

    Can the Excel 'cursor' or 'cell outline' color be changed?

    Hi all,

    I've found a bunch of info on the net for mac users to change the 'cursor' or 'cell outline' color, but nothing for windows users. Can this be done? If so how do I do this little trick?

    Any help, as always, much appreciated.

    Lock-e73

  2. #2
    Forum Contributor vandanavai's Avatar
    Join Date
    09-04-2006
    Location
    India
    MS-Off Ver
    Excel 2007
    Posts
    256
    Hello,

    U can change Grindlines colour as follows

    From Menu select 'Tools' -> 'Options' -> 'View' -> 'Windows option' -> then select color as per your choice.

  3. #3
    Forum Expert Paul's Avatar
    Join Date
    02-05-2007
    Location
    Wisconsin
    MS-Off Ver
    2016/365
    Posts
    6,885
    You can also change the border color of any cell or group of cells as needed. Select cell(s), right-click selection and choose 'Format Cells...' and go to the Border tab. Choose a color and which edges you want to color.

  4. #4
    Registered User
    Join Date
    03-23-2007
    Posts
    6

    Thanks but not quite what I was searching for ...

    Hi folks,

    Thanks for the answers to my query, but I was actually attemting to change the color of the 'cursor' if you like. The outline of a cell when selected ... not the cell itself or the grid. It is currently a black outline or 'cursor' and I was wondering if you could make it green lets say? I realise you can change the grid line colors and thickness but can you change the 'cursor' (don't know how else to describe it ... not sure if I'm being clear!?)

    Thanks again in advance for any help

    Lock-e73

  5. #5
    Forum Expert dominicb's Avatar
    Join Date
    01-25-2005
    Location
    Lancashire, England
    MS-Off Ver
    MS Office 2000, 2003, 2007 & 2016 365
    Posts
    4,867

    Smile

    Good evening lock-e73

    You can do this type of thing, but only by using VBA (or macros) - there is no built in Excel setting to control this.

    There is one massive drawback, and that is that this technique will use something called "Event Procedures", which means that the macro will fire every time you move the cursor - and every time a macro fires it will clear your undo stack. So, yes, it is do-able, but you'll lose your undo facility.

    Chip Pearson discusses this subject here :
    http://www.cpearson.com/excel/excelM...ightActiveCell

    and provides an add-in for you to download here :
    http://www.cpearson.com/excel/RowLiner.htm

    HTH

    DominicB
    Please familiarise yourself with the rules before posting. You can find them here.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1