How to underline cells in a spreadsheet

Question

How to underline cells in a spreadsheet

I have two columns of numbers. The first contains values and when I add the first 10 rows, the sum appears on the 10th row in the second column as a sub-total. Then, another 10 values in the first column is sub-totalled in the second column, and so on. Eventually, at the bottom of the second column, I will have a total of all the sub-totals above it.

I wish to underline the 10th, 20th, 30th, etc. row but when I underline the first one and go elsewhere in the spreadsheet, the first underline disappears.

How do I make the underline "stick" so I can repeat it every 10 rows or so? Does it have anything to do with "Cell Borders"?

Thank you.

Intel Core 2 Duo, Mac OS X (10.5.5)

Posted on Mar 29, 2010 7:58 PM

Reply

Answer 1

Badunit

Level 7

30,858 points

Mar 29, 2010 9:58 PM in response to B. James Lees

It is likely you are not following all the steps.

If you want to underline an entire row, click on the row header (the number) to select the entire row or, if you do not want it to apply to the header column, select all but the header column. Click on the border tool on the toolbar and select "bottom edge" then use the rest of the tools to make a border with the line type, thickness and color you want. To make copies of it for the other rows, turn on Allow Border Selection in the Table menu. Select the border by clicking on it (once gives you the entire border, again will select a segment, again will go back to the entire row). Copy Style. Select the other borders you want to change. Paste Style.

Alternatively for the borders, you can turn on Allow Border Selection first then select all the borders you want to change and change them all at one time.

Reply

Answer 2

KOENIG Yvan

Level 8

41,825 points

Mar 30, 2010 4:52 AM in response to Badunit

Hello

Thanks

I was always wondering why when I grabbed style from a cell with only the bottom edge customized and pasted it into an other cell I was getting a cell with the complete set of borders customised.
Now, I am able to customize exactly what I want 😉

Yvan KOENIG (VALLAURIS, France) mardi 30 mars 2010 13:52:15

Reply

Answer 3

Mar 29, 2010 10:45 PM in response to B. James Lees

Thanks for your quick response. I have done as suggested, and while the solution is a little clunky, it does work.
Best re/gards,
Jim

Reply