Microsoft QuickTips
< 1 2 3 4 >

Excel problems?

I need to set up an excel document to align dates to certain days of the week. both of which change e time. for example 24/01/07 (is a wednesday) the second date i have is 04/05...

Excel numbers, copying+cutting?

I am having minor problems with my excel. whenever i try to copy+cut numbers the 1st number i click on i seem to continue carrying it through so i end up copying all the same...

Excel. 2007 - files won't open from explorer?

When i try to open an excel document from windows explorer, excel lots up but the document doesn't open. i have to minimise the window first, then it opens the doc. the same happen...

Excel question for the elite user?

Hi all, i need some excel wizardry with the following scenario: - in cell b1 are "oranges", c1 "apples", d1 "apples and e1 "oranges. the data volumes for each are in cells b2 "...

Excel query.?

Which l does one use to detect duplicate numbers when editing with excel? is it possible for them to be detected as you enter them or does one have to wait until sheet is complet...

Help with excel custom functions?

Plz help. i have written my own functions in excel, and how should i get excel to display the arguments in the yellow box when using my function, the same way standard excel formu...

Ms excel csv?

Hello, for some reason my excel is not working and i desparately need to contvert a csv file to xls. what i need is for anyone who would extremely kindly do this for me if i send t...

Ms excel convert text from upper to lower case?

Cannot seem to get the "proper" formula to actually do anything. somebody know how it is supposed to work. i have 3 columns, 200 cells each, in all uppercase. am trying to ...

In ms excel 2000 - how can i copy and paste many entries in one column to another column and add a prefix?

I have got a few hundred lines in an excel database (i am no database genius you understand but use excel a lot). i need to copy the product codes in one column to another col...

Help with excel formula for school laboratory experiments using an if function.?

I need to configure an excel file where the data from 4 experiments is entered into excel. thing is that there are a few absents(abs) in the data, where the student scored no marks...
< 1 2 3 4 >
 
< Back
Microsoft Quick Tips Blog -|- Hostgator Web Hosting -|- G -|- Answerz