Excel problem

[Rincewind]

You know how when you use the mouse to select a range of cells, Excel identifies the selected cells with a surrounding line?

Well - I have a spreadsheet where this doesn't happen - the cells are selected, but there's no nice surrounding line.

I guess I probably accidentally hit a key that does this!

So - please can anyone advise how to set it back to normal?

Thanks!

 

[RecoveringYuppy]

I don't use Excel much but I suspect that at least some versions inherit some appearance values from the dialog:

Control Panel\All Control Panel Items\Personalization\Window Color and Appearance

So you may need to say what version of Excel and Windows you're using to get an answer.

 

[Rincewind]

Ah very true! Thanks for the reminder.

Windows 10 and Office 2016.

 

[Wudang]

Mr Excel is a good resource. Any help?
https://www.mrexcel.com/forum/excel-questions/703859-selected-cell-has-no-border.html

 

[Rincewind]

Mr Excel is a good resource. Any help?
https://www.mrexcel.com/forum/excel-questions/703859-selected-cell-has-no-border.html

Thank you!

That's got it!

 

[a_unique_person]

Only one problem with Excel? You are lucky.

 

[rjh01]

Only one problem with Excel? You are lucky.

There is only one problem with Excel - and that is often the user. Unless the user uses Excel a lot then they probably do not have the knowledge to use it. Excel has many features, but trying to work out what they are and how to use them is hard. Then they add in a few more features or change the way it works like they did when they went from 2003 to 2007 version.