This is the third time I have tried to post this, but for some reason it never shows up in the forum, so if this is a repeat of something already seen I...

how to

Help (of course unless you know F1 anymore you cant get to help via menu either) says you can, but "menu" no longer allows option of freezing more that the...

Is there a quick way to generate a powerset in Excel? A powerset is the set of all possible combinations of the items in a set. For example, given the set a,...

I have been using this code for quite some time now 1 year. All of a sudden it stopped working and is giving me a "Run-time error '5' Invalid procedure...

Is there a way to change the defaults on Autofill? I want my default on the Autofill to be "copy cells" instead of "fill series".

I have two cells with two different numbers and I am trying to have Excel format the difference between the cells.

Hello I don't know this is a stupid question, but what is the difference between a regular copy and paste routine and the copy and paste special --Formulas...

Can anyone help me? I have a list of names, addresses, SS #'s, etc. 5,000+ on the list. I would like for the user to be able to type a SS# into a cell (C3)...

I am trying to craft a macro that will print assorted sheets in a single excel file. I have written the one below but it won't run. Any help would be...

Hi! I have a load of data in the following form: Town;Extra;ZIP code;Phone number;Country For the moment, I have one row of cells with all this information...

We frequently receive invitations to tender in Excel-files. These are often ..xlsx-files. We use Excel 2003, and the converter is therefore used to open the...

I have the max number of rows showing up every time I open a workbook or add a sheet. How do I get my sheets to go back to 60,000 rows? I tried to delete...

Efficient and fastest way to copy several row headers to rows below (maybe 2 or more blank rows) for each header. Thanks

Hi, I'm trying to use IF & VLOOKUP formulas to find data in a spreadsheet but I can't seem to work with multiple arguments. This is the formula I'm...

I have a database which can generate/create letters to various ventors to remind them of something they still need to do. I can print these letters ar...

I need help to use this application... The problem is that I installed the new version of Office and my program were made in Excel 2003. I used this...

I'm just interested in stopping Excel adding quotation marks around text pasted from copied cells into notepad without having to go into notepad and do...

how do i create a condition on a particular cell if it's characters are less than 8 it will add a character? e.g. if i put "abcdefg" in my cell, there are only...

I need to create a custom list when sorting, but Vista (unlike XP) limits me to 255 characters. I need to create a MUCH bigger list than this limit - can I...