Headings struck through

**pnb** · 01-29-2009, 04:10 AM

I am sharing a spreadsheet on a network with some in-experienced users and keep finding minor corruptions of the sheets. The latest one which I can't get rid of is that all the row and column headings are struckthrough.
I thought it must have because someone had struckthrough all the cells on a sheet but when I cleared the ones I found the row and col headings remained struckthrough !!

Anybody got the answer?

Cheers

**davesexcel** · 01-29-2009, 06:04 AM

Then it could be borders....
Hard to tell without seeing the workbook.

**pnb** · 01-29-2009, 09:25 AM

Does this attachment help?

Peter

**VBA Noob** · 01-29-2009, 09:31 AM

Use Format / Style, select the normal style and click the modify button.
Change the font formatting to something other than strikethrough

VBA Noob

**pnb** · 01-30-2009, 12:08 PM

That did it, thanks !

**VBA Noob** · 01-30-2009, 01:42 PM

If you are satisfied with the solution(s) provided, please mark your thread as Solved.

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save