Some keys on my keyboard is locked in Exel. How do I unlock it?

I use custom toolbars wherein I assign macros from my personal.xls. After inserting a new button, I save my "book1.xls" and exit the program. When I come...

I have been given the task of designing a database that would store customer information. However, It should be done in a way that when an invioce is created...

how do I create and use a new spreadsheet based on a template?

Hi, In our company we have a very long pricelist in an Excel-file. Once a week we get a list with updated prices, also in Excel-format. Is there an easy way to...

Hi. I'm trying to copy and paste formulas without having the exact formula change. For example, in one cell I have =c1*d1, I want to copy and paste to another...

I have created an enrollment form in Excel (master file) and would like to merge it with data from a different worksheet and then print all of the merged files...

I have an Excel file with 9000 records and 15 fields sorted alphabetically. I want to set up the letters of the alphabet at the top so that if I click a letter...

Hi - Does anyone have or know of a link to a bi-weekly employee time sheet template for Excel? I am a new bookkeeper and the one that is currently being used...

my 2000 excel allowed me to follow a hyper-link by simply pressing "Enter". Now the 2003 version makes me have to use the mouse clicker. Can I set this excel...

I have an inventory sheet where items are listed as: BE-01, BE-02..., PE-01, PE-02... etc. When I add new items I indicate a preliminary inventory as (ie) BE-...

I have a workbook with 50 sheets (1 for each employee). How can I get Excel to sort these into alphabetical order ? (From )

I am not an expert user but I have just upgraded to Office 2003 and a spreadsheet that I have used for some time is giving me the following error:- Compile...

Operating system is XP. Office 2000 came installed. I am trying to calculate CUMPRINC, but can not do so without Add In form Analysis Tool Pak, which is not...

How can I sort a range of numbers in (columns and rows)in order to calculate frequency...

I have a simple scatter plot containing approx 1 weeks worth of minutely wind speed data (10,000 points). (Y-axis is the magnitude of the wind, x-axis is the...

Hello, I use Excel 2000, and I'd like some help with handling dates. I want to calculate the number of days between two dates for all the years from January...

Hi, I'm trying to create a column which automatically shows all the Sundays, Mondays, Wednesdays and Thursdays in a month (skipping Tuesdays,...

Is there a way to count back a certain number of active cells only (eg. 40 possible cells, only 28 are active), and then enter the lowest number within that...