Strikethroughs - HELP!!

Loveguts

New Member
Joined
Mar 20, 2009
Messages
2
Why are my Row and Column Headers shown with a strikthrough each of the letters and numbers?
 

Excel Facts

Does the VLOOKUP table have to be sorted?
No! when you are using an exact match, the VLOOKUP table can be in any order. Best-selling items at the top is actually the best.
Did a little poking around, looks like that's controlled by the style settings. Somehow your 'Normal' style got set to strikethrough text, which then applied itself to the row/column headers.

For 2003:
Go to Format>Style, select the 'Normal' style and click the modify button.
Change the formatting so strikethrough is not selected, then click OK.

For 2007:
On the Home ribbon, click 'Cell Styles,' right-click on the 'Normal' style and select Modify.
Click the Format button then remove the strikethrough with the options. Click OK.
 
Upvote 0
No idea but:

Format | Cells | and under the font characteristics uncheck the box for strikethrough. If that doesn't work then you've got some mighty strange characters that you'll have to re-write (edit: strike that - see above on another explanation as well)

Hope this helps - also, welcome to mrexcel.

Alex
 
Upvote 0
Hi Guys!

Thanks for the replies, and sorry for the delay in responding. Von Pookie, you were right. Thanks a million. We've had half of our organisation scratching our heads trying to work it out.

Woohooo!
Cheers.
 
Upvote 0

Forum statistics

Threads
1,214,421
Messages
6,119,392
Members
448,891
Latest member
tpierce

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top