Stupid Spreadsheet/Excel question

[Pipp]

I'm inept when it comes to spreadsheets -- apparently.

I'm trying tolock the rows so all the info sorts together.

I want to sortby the information incertain columns, but sometimes just the column sorts and puts all the info in the rows out of whack. I tried the Help menu, but it's totally useless. :grumpy:

:dunno

 

[aurora369]

As far as I know, you have to highlight all the columns you want to be sorted. Then sort the data.

I'm not too good when I'm not looking at the program directly.

--Dawn

 

[kirst3buns]

When you set up your spreadsheet, make sure that there are no empty columns or rows in the data you want to sort. That will cause excel to exclude data. It will automatically include data around your cursor until it reaches empty columns or rows.

Also, you can manually select the area you want to sort if it is not automatically selecting the entire spreadsheet. That way, even if you have a column that is empty, you can still tell it to include columns to the right of that empty column. Same goes for rows. Sometimes I do this just to make sure everything I want included is highlighted.