Hi In Excel I have a customer list showing information in numerous columns e.g. Name/ Address / Contact info etc. In Word I have created a Label...

Hi, I have a report submitted which looks like a pivot table format and would like to change it to another orientation in another worksheet. Is there a...

Hello, I have Excel 2007 I have a sheet with rather narrow columns. Starting with a blank sheet,... if I enter a long text string into the 1st column...

OK - am having problem with this and need expert help. 1) When I try to change the $250 in the last column, it does not work and 2) When I go to the next line...

I am using excel 2003 and am trying to link a worksheet from one spreadsheet (source) into a second spreadsheet (destination). The source spreadsheet may or...

I saw a document with √ in a cell. What do I need to do to recreate this symble or where can I find out how to use it?

Using Excel 2003. I can use the min function to find the lowest number in a row but how do I get the lowest number in a row (or column) to change colour so...

I'm starting to get confused by the vocabulary in Excel. I'm not necessarily looking for someone to just give me a solution to my problem. I'd just like...

Hi I need to calculate from une date if 18 monts has past, if is false put a "X" on if is true livet in blank (no 0 ) ex Kevin start on 06 mai 2007 still...

There is a charge of £55.75, to which a handling fee of 2.95% is to be added. But, the handling fee is also capped at £0.50 minimum and £1.50 maximum. Any...

If A1=Date Reported, B2=Date Resolved, B3=Resolution Period What formular should I use to: 1) calculate the resolution period in days, excluding weekends and...

i'm trying to angle (rotate text in exel) it ofcourse rotates fine bot then i put border on that cel the border is also rotated how to rotate text...

Top row is all merged. Underneath is a row consisiting of several groups of merged cells, each of which is acting as a heading for the columns underneath....

Excel 2000, Vista How do you refer to the info on the tab (worksheet name) in a cell in the worksheet Thank you, Bill

Hi when adding up a colum using sum instead of getting the total I am getting ### I can see the correct answer bottom right as usual but when I try to enter...

Qestion to judge whether the candidate has passed or failed depending upon the marks secured in different subjects. my question is that to compare marks...

I need to compile data from 6 cells in the 2nd tab in over 300 workbooks that are in the same folder into 1 spreadsheet in a separate workbook.I want to ...

I'm trying to clean up .pdf data that was exported to Excel. The columns are a mess so I'm working left to right. I was hoping to create a macro that would...

I have recently set up a time sheet for myself at work. At my last place you could click on a button called 'Annual Leave' or 'Bank Holiday' and the cells...

can i sort my data automatically without click on "sort" icon