Has anyone noticed that if your print area is non-contiguous (made up of more than one range) then print-to-fit doesn't work? or is it me?

I am dragging and dropping data from a 3rd party application to an Excel worksheet. It creates a new worksheet when I drag and drop. It automatically...

When i paste a single cell to a merged cell. This err display. How can i resolve it. Thanks in advance

When you need more than 2 or 3 IFs, your best bet is to use a lookup table or some other formula. Be more specific about what you're trying do, include some...

A user here wants to key a date in as 112003 and not have to key the slashes. I can create a custom date format that will fill in - for her instead of...

I recently reinstalled Win 98se and Office 97. I have two hard drives on my computer and before installing the software I saved all My Document files to the...

In Excel 5.0, I have 25 sheets in a workbook. I want to do a few more sheets. Per "Help", when I hold Control and click the blank spot next to "Sheet 25",...

I have two columns, A1 (variable start date) and B1 (fixed end date), I would like to calcuate the number of (busniess) days between A1 & B1 excluding weekends...

I have created a table that lists a class number for each individual and a dollar amount. I want to get the percentage of the total dollar amount for each...

I have a total sheet and want to add up the previous sheets by name. For example if the sheets are named Assets, Income, Liabilites. On the total sheet in...

Hi Helmut, what does "calculate easter" mean? I am interested in this formula, but cannot understand what "calculate easter" means. "helmut sager"...

I know how to convert numbers to text but I have thousands of entries to convert (in the same column). After I select the column and go to Format cells and...

Excel 97 Won't Print Landscape on HP4000

I have not used a macro in excel for many years. I am rying to do a simple macro to add text to a cell and then go to the next cell and add the same...

In Office 97 I could assign a unique number on a worksheet. How can I do this in Office XP?

@=04=07v=1CZ(=01PrintSMPCT-FS01=01=05=05=15=FAO=0C/=FDCF=1E=07=E5;+|=0811= 1Priority=20 Practice Analysis.xlsSarahTHP Color...

I have a worksheet that includes a column of email addresses. I want to send an email to all of the emails in the column. Without having to type each email...

I am tring to copy information from 50 cells in a horizontal sequence into a vertical sequence without having to do so individually. When I use autofill,...

I would like to find a formula that gives a specific output based on the amount time past. Inputs would be the Current Date & Starting Date. Outputs would be...

I'm wondering if anyone knows if it's possible to use Vlookup and for the table_array to use an Access...