Excel tables

Hi all,

I am looking at moving some of my word from Word to Excel - mainly tables and forms, as these can be populated onto several sheets from a master sheet etc.

But, the table lines (borders) are a lot thicker and darker than in Word.

Is there a way to make the lines thiner/light so the table would look like a Word table.

Hope this makes sense.

Thanks

You can select a range of cells (or the whole table) and right-click and then choose Format Cells | Border tab. You will see a variety of line styles and thicknesses that you could apply.

I think Word has probably got more control over borders than Excel, though.

Hope this helps.

Pete

Thanks

Thats exactly what I needed

Cheers

Originally Posted by Pete_UK

You can select a range of cells (or the whole table) and right-click and then choose Format Cells | Border tab. You will see a variety of line styles and thicknesses that you could apply.

I think Word has probably got more control over borders than Excel, though.

Hope this helps.

Pete

Glad to help.

If that takes care of your original question, please take a moment to select Thread Tools from the menu above and to the right of your first post in this thread, and mark the thread as SOLVED.

You might also like to know that you can directly thank those who have helped you by clicking on the small "star" icon located in the lower left corner of a post that you have found to be helpful (not just in this thread - for any post that has helped you). This also adds to the reputation of the poster (the small green bars in the poster's profile).

Pete