When I add shading to a cell, I cannot see it on the screen, I can only see
that there is shading when I use the print preview option.

What i have:
I have a telephone bill in an excel spreadsheet and im trying to perform a
cost analysis on my company's calls during certain shifts. the phone bill
comes with a column that breaks down the time of the call in this format

how do you delete document history in word and excel 2007 after you click the
top left office button

Hi, all
i have a problem to lookup or replace words when it contains "~"
character.
every time i have to change it to "-" manualy. for there are lots of

I would like to create a button by a visual basic code.
On my first sheet I have a button. If I click on this button a new page is
created. On this new page I would like to create a button with a macro code,
but I don't know how. So the button on sheet 2 has to be created by a ...

I've received a file from a colleague in France with a very long equation in
several cells. Actually it just adds 14 cells together, but since the cells
are in other workbooks the cell name is very long. Here is the problem. He
has no problems seeing the entire equation (i've ...

Hopefully i've got the right forum here.
Best explained by example.  In B1 i have '2008 Forecast' as a heading.  I
show the total for '2008 Forecast' using ="2008 Forecast "&sum(B2:B65536).  
This would show '2008 Forecast = 100000000.  Problem is i want to show say

Hello everyone. Please help before I lose my mind completely. I have a SS
with a load of flat (apartment) numbers in the format 1/2, 2/3, 3/3, 4/1,
etc. Excel has converted these to dates but I need them to be in text format.
Trouble is that, when I convert to text (or copy - ...

I have this problem that the cell format in the query result changed from the
source document. For example, when I run a query on a date field, the display
result will be shown as numbers. I have to keep reformatting the cell
everytime I run new query, and refreshing the data.

I copied a range of numbers into excel from the internet. When I try to
'Autosum' them they will not add. I also cannot format them e.g can't change
them to a currency or change the number of decimal places of any number in a
cell.

I have a column that has data where most cells in the column contain only a
number, but some cells contain a one to three letter designation for example
LT 50835, DLT 6035, or 8227P.  I am trying to figure our a formula that would
let me extract just the letter designation into a ...

Hi;
Can someone help me urgently? I'm getting a lot of complaint from end user
stating that they are not be able to change the cell contents.
This is how it works:

Please give me help
How I can write a macro in excel for copy and paste a formula  with
depending upon the value of  next right cell
For example I have a formula in cell A1  to  get numeric  value from   alpha

I have a formula that I need to copy along a row. Part of the formula refers
to cells that are elsewhere in a column. Is there a way of copying the
formula along the row without having to then manually change the references
for the data in the column.

I have a series of monthly returns (%) for an investment portfolio (let's
call them x,y and z).  I would like to convert them to a total return (TR)
such that TR=(1+x)*(1+y)*(1+z)-1.  But there are a lot of them and I dont
want to have to type such a gigantic formula.  Also, I ...