I am running this macro that sums the range and place the total at the end of the range. The macro will work on the current worksheet, but will...

°²ÀÏʦ£º ÄãºÃ£¬ÏòÄã·¢¸ö¶«Î÷£¬ÔõôÑù°¡¡£ ¾Å°à£ºÁõÃô 2005Äê11ÔÂ22ÈÕ

I have a workbook with 80 worksheets. How do I create a macro that will automatically convert each worksheets into pdf files? Your help is greatly...

i want to insert some titles at the top of the page in microsoft excel with the no.1 starting below the titles

I want to change the name of all the worksheets by using a table in another worksheet. The table contains one column for long names and another column for...

I want to be able to automatically find the last cell in the range, offset (1,0) and activate/select the cell to place the sum of the range. The code below...

Hello, I know this is slightly off-topic but... I'm using Excel from Office 2000 and am getting an error on startup which I'd really like to get rid of: -...

I have a series of 114 workbooks with 22 worksheets each. They are setup for A4 printing. Is there a way to print all worksheets in each workbook on 8½x11...

I am trying to make an inventory list where I have consecutive numbers. I don't want to type each number individually. Is there a special function that will...

Novice here - how do I format an excel calendar to put the date in each box, set location, color, etc. ? thanks

In the past I would have a text file containing space delimited data inside which was saved as a text file. I would rename the extension to .xls and then...

When making a form, cells are locked so that the user can not change them, and can only enter information in the unlocked cells. But when one creates a new...

I wish to import data into Excel that is typically 90K rows long and could go to as much as 900K. # of Columns is only say 20 or so. is there any way to...

I have an excel file that contains 80 worksheets. I want to automatically convert each worksheet into own new excel file. How can I do that without copying...

I cannot change a column to show dates as mm/dd/yy. Some cells will change but others are frozen on dd/mm/yy. Nothing I do will clear it and lock in the...

In Excel 2003 i use the "Open Favorite" button on my toolbar. I put a bunch of shortcuts to folders I use often in my favorites so this is a great way...

How do I format worksheet so that consecutive repeating values in a column will appear only once in the first row and suppressed in the following rows?

I am trying to import a txt file into Excel. When I go through the wizard, I choose "fixed Column" width- next- then I have to put my break lines in...

hello and greetings, my microsoft excel having problem in my office, each and everytime i try to open a dexcel doc from another pc through my computer, it...