Format

P

PL

Hi

1) I have a whole lots of data, how do I arrange each row in alphbetical
order, according to the 1st letter in the column A?

2) How to insert hyperlink for all the URL in my data?

3) If I extend the width for a row, how to ensure the text will fill the
width instead of requiring me to extend the length of the column?

Thanks
 
I

IanC

1. Select all the data, go to Data > Sort. If you have a header row, select
that at the bottom of the "Sort" dialog, then ensure that the correct header
name appears in the "Sort by" drop-down box. If you have no header row,
ensure "Column A" appears in the drop-down box. Select whether you want the
data Ascending or Descending (A-Z or Z-A) and click OK.

Alternatively, select the first cell in the first row of data (eg A2). Click
& drag to select all the data, then click the "Sort Ascending" icon on the
toolbar (icon with A, Z and down arrow).

2. Don't know.

3. I assume you mean you increase the height of the row and you want the
data to fill several lines in the column rather than making the column wider
to fit it all on 1 line. If so, select the cell(s), go to Format > Cells >
Alignment tab and select the "Wrap text" checkbox. Click OK.
 
Top