Underlining

Hello Richard,

Thanks for the screenshot.

I have attached a file for your info and just in case you are unable to read the file data for whatever reason, I have described below how I achieved what you are looking for.

1) In a cell type the heading then immediately click the Borders drop-down and select the Horizontal Line option. Right click the line and select Format Horizontal Line and change the format to a solid colour with a size of .5pt.

2) A second option is to simply go to the insert ribbon and select the line tool from the shapes button and holding the shift key down then click and drag a line. This has its drawbacks which you will encounter when you try to increase the row height. The line will simply stay where you placed it and requires editing to get it in the correct position, whereas, the Horizontal Line outlined in (1) above always stays with the cell where it was placed.

Hopes this is what you were looking for!


I hope this resolves your question. If it has, please mark this question as resolved.

If you require further assistance, please reply to this post. Or perhaps you have another Microsoft Office question?

Have a great day.
Regards,

Rodney
Microsoft Office Specialist Trainer