trivia questions

  • Thread starter Thread starter Charles Gilley
  • Start date Start date
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
 
Hi
1.: In A1 enter 1
in A2 enter
=A1+1
and copy this down

2. Are these cells merged cells?
 
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
 
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!
 
Back
Top