Wish list for Excel
I am doing a spreadsheet on the NCAA basketball tournament. Air Force has
played 3 games in 3 different years. Kentucky has played 140 games in 47
different years.
Two things I wish Excel had a
1. I would like to be able to highlight a line of cells (such as A7-K7 then
A14-K14 then A87-K87) then be able to highlight columns A-K then go to €śData€ť
then €śSort€ť by column A and it would sort each group (in this case Schools)
in between the brakes. Would also like to be able to Sum or Average on the
brake line.
2. Now I am having to highlight each schools data and sort by column A
(which is date) then by column C (which is the round). Then on the next
group the Sort may have gone back showing the first row as being a header and
not keeping the second sort. When I sign in to my mail there is a little box
I can check to save my password to this computer. When you are doing a lot
of sorts that are alike it would be nice to be able to save your sort.
In other spreadsheets I would like to be able to copy a row and then be able
to paste that list into a column.
----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.
http://www.microsoft.com/office/comm...lic.excel.misc