Excel question(s)

[#1procrastinator]

If I wanted to add up all the cells in one column with one cell in another column, what would the formula be?

i.e. I wanted A1+B1 = C1, A2+B1 = C2, A3+B1 = C3 etc.

I've tried =A1:An+B1:B1 but it just adds up the A1+B1, A2+B2...

[Lasercookie]

Use =$A1+$B$1 in C1. Then hover to the bottom right corner and drag that cell down. The $ will keep that reference constant, and any unlocked values will vary according to which was you drag down. e.g. dragging down to C2 should give you =$A2 + $B$1, where only the number of the 'A' is changing.

Wait, unless I read that wrong and you wanted Sum of Column A + B1 (e..g just getting a single value. In which case =SUM(A1:An)+B1 should do the trick, where n is the final A cell.

Or =SUM(A:A) + B1, where it'll sum every value in the column A

[#1procrastinator]

Thanks a lot man - nah, your first interpretation was correct 

[#1procrastinator]

I'm trying to convert my workbook/sheet into a .pdf file but I have a few columns of cells to the right I don't know how to get rid of.

Also, the font of the stuff inside the cells is pretty small - how do you make it bigger?

And is it possible to make the gridlines thinner or lighter? It's light in Excel but when you save it as a pdf, it's pretty thick and is distracting.