How do you reverse the order of a large set of data without having to retype
each cell? For example if I had data in the following order: A1: 10, A2: 12,
A3: 14, but I want them to look like this: A1: 14, A2: 12, A3: 10. How can I
make this happen for a large set of data?

I need to set up a function that rounds numbers up to the nearest whole
number if the decimal is greater than .5 and the number is odd, and rounds
down to the nearest whole number if the decimal is less than .5 with an odd
integer or if it is even no matter what the decimal is. ...

an option to reverse the order while pasting a row or column would be a
useful feature.
----------------
This post is a suggestion for Microsoft, and Microsoft responds to the

    If I add a number in cell A2, I want that number that i put into A2 an
the text  that I already have in B2 to go to another page in P2. How Can I do
this
Thanks

I'm not sure if this is possible but is there a way to change just one
portion of a fomula in mulitiple cells? I have a report that has monthly
results listed on one tab abd this reprot pulls the data from another
worksheet, where the data is on different tabs for each month. The ...

I have a column that I would like to edit in which all of the words are
capitalized. I need to convert them to regular words.... Is there a way I can
fast edit this bad boy.
Example , DENVER to Denver

Assume that I create a worksheet that goes to, for example, cell F500.  Okay,
now do "File/Save As" to rename & save it.  I then delete Rows 101-500.
Now, if I select Ctrl + End in the new worksheet, it will go to F500 – even
though the new worksheet ends at F100 (remember: I ...

Is it possible to create a cell with 2 different formulas? I need to subtract
one cell from another as well as to multiply a cell by a number. Example:
=SUM(D30-D29) and C28*1.5 and have the results combine in the one cell.
Please advise.

I cannot get the columns to add and give me a total below them.
I get sum= 0.
I tried autosum function, and manually typed formula. just does not make
sense.

For example I have two times entered as 23:30 and 1:45 (but the next day) we
are not entering the date just the time.  Subtracting the two gets the
correct answer but when the times wrap around midnight (as above) then there
is a negative time difference and it is wrong.

I've imported a report to Excel.  It looks something like this:
Column A                            Column B                              
Column C
Name:  Smith                       Fax:  321-321-3321               NPI:  

What does the "!" mean in the above formula?

The basic description of the problem is that I have data scattered in a bunch
of date-named files, and I am trying to assemble them back into the same
table using VLOOKUP function, where I have to change the workbook source
names - and I am getting an error, indicating that my ...

I have a workbook with 5 worksheets.  Sheet 1 is a summary of data on sheets
2-5.
Sheet 1 will always be named "summary", but the names of sheets 2-5 will
change monthly.

I am using ISBLANK in a formula and it keeps returning "false" when it should
be returning "true", because (SHEET1!CD15) is blank. What could be causing
this problem?
This is my formula: =IF(ISBLANK(Sheet1!CD15),"",Sheet1!BU6)