Changing column width

Question

Changing column width

Perhaps my problem is the same as the person with the "Spastic Drag & Drop." When I want to select a group of columns or rows of a spreadsheet to change their width or height, I can't select them and NOT end up moving them. Well, I occasionally can, but more often it wants to move the cells instead of allowing me to just get the little arrows and change the dimension.

imac, Mac OS X (10.5)

Posted on Jan 21, 2008 7:29 AM

Reply

Answer 1

Best reply

Ric Donato

Level 4

1,129 points

Jan 21, 2008 11:40 AM in response to Ming Ming Su-Brown

Hi Ming Ming,
Here's what I do: Highlight columns B-C-D-E. Moving the mouse to the top between the columns, the courser changes to a small vertical black bar with an arrow left and right. Hold down the mouse drag to your desired direction. Yes it appears only one column width is changing however, when you release the mouse all highlighted columns will change widths.

Hope I understood your question.

Sincerely,
RicD

Reply

Answer 2

KOENIG Yvan

Level 8

41,807 points

Jan 21, 2008 11:48 AM in response to Ming Ming Su-Brown

Hello

Here is the way I do that

click in the column C's tab
press [Shift]
with Shift depressed, click in the column K's tab
leave the shift key.

Now columns C thru K are selected
click the vertical separator between tab C and tab D
the "adjust width symbol appears
Move it to the left or to the right to get the wished width.

Yvan KOENIG (from FRANCE lundi 21 janvier 2008 20:48:17)

Reply

Answer 3

Jan 22, 2008 4:48 PM in response to Ric Donato

Dear RicD & Yvan K,
Thank you both for your helpful answers. I think I was not waiting until the double arrow showed up and was dragging too soon.

Both of your answers worked!

Ming Ming

Reply