Spread 'Em!

April 2, 2011 8:02 AM

Idiotic Google spreadsheet question: how do I shrink the column size?

I'm not an experienced spreadsheet user in the slightest, so bear with me.

I have a spreadsheet located on Google Docs (it's here, if you want to look at it) and the columns have inexplicably gotten too wide. I'm sure I clicked something by accident.

Normally, I would just put my cursor to the top of the header, and would drag it back to size. But the problem is, the columns are so wide that I can't get to the appropriate header--when I try to scroll, it just takes me to the next column, with no header visible.

I looked here on Google Doc's Help page. I can select all the columns in my spreadsheet, but when I right-clcik on the selection I can't seem to get the menu they refer to (and I am using Google Chrome).

Help me, MeFites!

posted by magstheaxe to Computers & Internet (6 answers total)

Best answer: On my googledocs spreadsheet, when I mouse over the column's head cell (the one with the letter in it, say 'B'), a small blue arrow appears and I can click to activate a drop-down menu. Select 'Resize column' and enter a value in pixels. Then click OK.
posted by carsonb at 8:11 AM on April 2, 2011

Click on the top left hand corner to select all rows and columns. Then resize column A to make it a little narrower and all the other columns should be set to the same size.
posted by therubettes at 8:11 AM on April 2, 2011

Best answer: I can also get that drop-down menu by right-clicking the header.
posted by carsonb at 8:12 AM on April 2, 2011

Response by poster: YES! Thank you, carsonb!!! You're awesome!!!
posted by magstheaxe at 8:14 AM on April 2, 2011

Looks like you got it. =)
posted by carsonb at 8:14 AM on April 2, 2011

You can also change several columns at the same time.
posted by davcoo at 8:54 AM on April 2, 2011