General

how do i change an existing cell or cells to upper case?
how do i change an existing cell or cells to upper case? ... 20 Mar 2010 23:17

Formula For Time Duration Calculation
Hi Every One, I Have excel sheet like, A B C REPORTEDDATETIME STATUSDATE Result (HH:MM) 02/16/2009 04:00 AM 02/16/2010 04:00 AM 8760:00 02... 20 Mar 2010 22:11

Transpose Large Column to Row
Hi - I have a column with about 25,000+ rows in Excel 2007, and need to somehow get this transposed into a row (so with 25,000+ columns). I have tried to do this with the TRANSPOSE function using Ctrl-C and using the Paste drop-down menu and selecting the Transpose option. But I get an error message that the... 21 Mar 2010 08:18

The whole page moves with the up/down arrows, not the cells
How do I stop the whole page from moving with up/down arrows? I just need to change the cell. Excel 7 ... 20 Mar 2010 19:59

Email pivot table report page.
Is it possible to email only one page from my pivot table? Say I have a report on sales rep as page field and I want to email only his page to him. Is it possible to email that page to the respective sale rep? ... 20 Mar 2010 19:59

How can I rotate an XL worksheet 180 degrees
I have turned a worksheet into a graph page and need to rotate it 180 degrees. ... 20 Mar 2010 21:05

bins, frequency function
when i select the data and bins array and press CTRL+SHIFT+ENTER some number appear in the column but they are incorrect and the last number of cells in the column just say NAME? Please could anyone help me? ... 20 Mar 2010 18:52

#VALUE!
When a cell returns the text #VALUE!, how can I convert this to read the number 0? ... 20 Mar 2010 17:46

Help for the formula
Dear All, Please i need the formula for colum D Status, it can display Pickcal or In or Out or Picked. Colum A Colum B Colum C Colum D Confirm Date scanin scanout Status ... 22 Mar 2010 23:02

Opening xlsx files in Excel 2000
I'm getting an error opening an xlsx file in Excel 2000. I have tried installing the 2007 Compatibility pack. I uninstalled and reinstalled Excel 2000 and the Compatibility pack. Ironically I've gotten it to work on another of my computers (same version of Excel) but can't seem to get it to work on my deskto... 23 Mar 2010 11:20