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

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...

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...

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

Sometimes when I subtract a number from itself, I get a negative zero, rather than a simple zero. Why is this?

Please help me to make a pgm to make a new file from an old file by clicking a button. The new file will be containing all the rows of the old file...

does a star(*) within a cell have any other meaning apart from a symbol for multiplication within a formula???

Hi. I am searching and replacing various characters in an Excel column. I need to delete all the asterisks (*) in this column. How do I do this? That is,...

About a week ago I had to recover my operating system, in the process I had to reinstall Excel. Everything works except the Tool Function, I have uninstall and...

My version of excel came installed on my computer but I need the solver add-in and it's asking for a CD. I asked a friend of mine about this and he said when...

Hi I'm using this vlookup to get values from a sheet named "sub": VLOOKUP(R1,sub!$J$1:$K$18,2,FALSE) and t works. But when "R1" is not in the lookup...

l am in a job that uses Excel (formula) alot, what book/course do you recomend that may be helpful to me as I am @ Int. level in Excel. Thx. Kim

I recently had XP installed. I download .tsv and .php files from the internet. I want Excel (Excel 2000) to open these files but it is not in the list of...

Everytime I try to use Excel it tells me that it is only available by CD rom, when I click Cancel it says that a Fatal Error has occured. I have been using...

Hi all, How do you get a textbox to autocomplete a word, or is it a textbox. I have been using a combobox but I wanted to make the form a bit neater...

situation: I am created a sceduled task within an ACCESS dB to export out information to a .csv network file share. The problem is that the date field is...

Can you have two arguments for a SUMIF function? I want cell K56 to sum cells K3:K44 if cells A3:A44 has a value of M or W. I can it to work with just one...

I rebooted my computer recently but I lost the use of the Excel spreadsheet which was originally in my computer when I bought it about 4 years ago. Currently,...

I did it once but don't know how. Basically I just want to rename an autoshape from "autoshape61" to "somethingmeaningful" I think it involves pressing the...