#1
|
||||
|
||||
Seleted Cell Highlighting
When I selected a cell in my 2007 version of Excel, the background would highlight with a very light gray color. In the 2019 version of Excel there is only a slight change in the border around the cell to indicate that it is selected and it is very difficult to find that cell in a large spreadsheet. Is there a setting I can use to change the properties of a selected cell?
Jim B. |
#2
|
|||
|
|||
Interesting. My 2007 version just places a thick border around the cell.
??? |
#3
|
||||
|
||||
That may have been what was happening in my 2007 Excel. I had display problems with my 2007 version of office so I uninstalled it and installed the 2019 version. Neither this version of Excel or Word will put a border around the selected cell/cells. Is there a setting which I can use that will make this happen?
Jim B. |
#4
|
|||
|
|||
I don't know of any setting ... although there may be one. I've always understood it was an editable design of Excel.
|
#5
|
|||
|
|||
I have 2019 version and Excel cells look like photo on my machine. Ignoring the pale green background (because that is my customised colour) does your cell highlighting look similar? Maybe post a photo?
|
#6
|
|||
|
|||
|
#7
|
||||
|
||||
That's what my cells look like. Now put a border around a couple of cells and then select one of them. You'll see what I'm talking about.
Jim |
#8
|
|||
|
|||
Image Attached .
|
#9
|
||||
|
||||
Quote:
Just what I was looking for bur, it only works in a xlsm file. How would I open a new workbook as a xlsm? |
#10
|
|||
|
|||
I didn't study the article. It just sounded as if it is what you need. The instructions begin with the text "The following VBA code...." then steps 1,2, 3 and 'Notes'.
There may be something more simple on tinternet but that was the first thing I found. Good luck. |
#11
|
||||
|
||||
Thanks for your help. When you get to step 3, it just says "save". When you try to save it in a xlxs file, you get an error saying It can only be saved in a macro enabled file (xlsm) I'd like to be able to open a new workbook in that format. The only way I know how to do that is, open a new book then immediately save it as a xlsm file.
|
#12
|
|||
|
|||
Is the following any use? I haven't watched the video but it sounds as if it may be useful: -
Highlight Active Cell in Excel (Excel Magic Trick # 1) - YouTube |
#13
|
||||
|
||||
Quote:
Thanks, but...This wasn't helpful. |
#14
|
||||
|
||||
Quote:
I have this code embedded in a workbook. How do I view it when I'm in the book? |
#15
|
|||
|
|||
I'm out of ideas so I hope you find help elsewhere.
Maybe it is not possible unless you into advanced computer stuff? |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Conditional Highlighting When Approaching End of Quarter if Date in Cell is From Previous Quarter | PrincessApril | Excel | 6 | 12-06-2019 02:38 PM |
Clear all cell colors within a range starting at cell A8 and change row of active cell to yellow | FUGMAN | Excel Programming | 7 | 02-05-2017 08:37 AM |
Word tables: prevent word from highlighting whole cell when I highlight text | skylark53 | Word | 2 | 08-04-2015 08:12 AM |
highlighting | Donnathompson | Word | 4 | 08-07-2011 05:21 PM |
Cell highlighting Issue | jasonk916 | Excel | 0 | 12-07-2009 07:05 AM |