trivia questions

C

Charles Gilley

1 - how can I fill a column of cells with an ascending numeric value?

2 - formatting text - some of my text is long, so I tell excel to wrap the
text. This usually results in excel increasing the height of the cell
so that all of the text is visible. However, some cells REFUSE to behave
in the same fashion - they will not expand in height no matter what
options I select. What am I missing?

thanks
 
F

Frank Kabel

Hi
1.: In A1 enter 1
in A2 enter
=A1+1
and copy this down

2. Are these cells merged cells?
 
G

Gord Dibben

Charles

1. Enter 1 in top cell then right-click on the the fill-handle(black lump at
bottom right corner of cell). Drag down as far as you wish. Release mosue
button and select "Fill Series" from the menu.

There are other ways. Post back if you want alternatives.

2. If row heights have been manually set they will not expand with wrap text.
Select the rows and Format>Row>Autofit.

Also, if any rows have been merged, they will not Autofit.

Gord Dibben Excel MVP
 
C

Charles Gilley

Frank and Gord - thank you for the suggestions. I have searched at
some length for the autofill, I am now dangerous with excel :).

Also, the autofill is just the ticket. This is a relatively simple
spreadsheet - just much data. And, many people have their hands in
here. Sometimes the text just would not format, and I never knew why.

A thousand thank yous!
 
Top