I am trying to create an excel sheet for my bowling to make calculations
easier. I want to make all the cells from A2- say A25 have a height of 16,
and then the rest of the cells to only have a height of 8. So that there are
two cells in the second column for each one cell in the first column. Is
this possible, and if so how do I do it.
You can merge cells to give the effect you described.
Highlight cells A2 and A3. On the menu bar, Format gt; Cells, click the
Alignment tab and check Merge Cells. (You probably have a seldom used button
on your toolbar that has a small 'a' in the middle with arrows pointing left
and right; it's the Merge and Center button and will merge highlighted cells
without going through the menus). From the alignment tab, you can also
specify how the contents of the merged cells should be aligned; you'll
probably want top vertically.
Note that A2 and A3 are now one, so you've effectively doubled the height of
A2. Does that do what you're looking for?
If so, you can repeat by either using the format painter (the paintbrush on
the toolbar) or Ctrl y to repeat (click on the next two cells and then
Ctrl Y, etc).
--Bruce
quot;Paulaquot; wrote:
gt; I am trying to create an excel sheet for my bowling to make calculations
gt; easier. I want to make all the cells from A2- say A25 have a height of 16,
gt; and then the rest of the cells to only have a height of 8. So that there are
gt; two cells in the second column for each one cell in the first column. Is
gt; this possible, and if so how do I do it.
Bruce,
Thank you so much for your help. That's exactly what I wanted to do!!
quot;bpeltzerquot; wrote:
gt; You can merge cells to give the effect you described.
gt; Highlight cells A2 and A3. On the menu bar, Format gt; Cells, click the
gt; Alignment tab and check Merge Cells. (You probably have a seldom used button
gt; on your toolbar that has a small 'a' in the middle with arrows pointing left
gt; and right; it's the Merge and Center button and will merge highlighted cells
gt; without going through the menus). From the alignment tab, you can also
gt; specify how the contents of the merged cells should be aligned; you'll
gt; probably want top vertically.
gt; Note that A2 and A3 are now one, so you've effectively doubled the height of
gt; A2. Does that do what you're looking for?
gt; If so, you can repeat by either using the format painter (the paintbrush on
gt; the toolbar) or Ctrl y to repeat (click on the next two cells and then
gt; Ctrl Y, etc).
gt; --Bruce
gt;
gt; quot;Paulaquot; wrote:
gt;
gt; gt; I am trying to create an excel sheet for my bowling to make calculations
gt; gt; easier. I want to make all the cells from A2- say A25 have a height of 16,
gt; gt; and then the rest of the cells to only have a height of 8. So that there are
gt; gt; two cells in the second column for each one cell in the first column. Is
gt; gt; this possible, and if so how do I do it.
- Aug 28 Tue 2007 20:38
How do I change the ROW HEIGHT in one column?
close
全站熱搜
留言列表
發表留言