Search results for query: *

Help: I want to be able to set the header and footer margins in Excel when i change the margins in the main body. For instance if i change the margin to 1.50, i want the header and footer margin to change to 1.50. Thanks in advance.

Trying to find a way to validate a number by determining whether the number is odd or even (a true or false argument). Help is kindly appreciated. Thanks.

Hi: Thanks for the reply, however, in playing, I found my answer, I used a combination of the "if" and "iserr" formula in excel which solved my woes. Thanks.

Hi all: Having a problem - want Excel to be able to look up a date and based on that date, return a specific value. If the criteria does not match, than formula should return "blank" or 0. I tried using "vlookup" with "false" as the 4th arguement, however, keep...

I am assuming you want this pop up box so that it reminds you of important events. Instead of using excel to do this, you might to better off to use Outlook's calendar functions. In here, you can set appointments, reminders, contacts, etc... I use it and it's great. Cheers.

Thanks for the help :). However, in this case, averages only work if you are dealing with one product (i.e. gasoline prices). Can't compare apples with oranges. Cheers.

For instance, if you have price in column 1, qty in column 2, and total (prc * qty) in column 3, it does not make sense to have totals for price, it may for qty, and definitely for totals. Hope this helps. Rgds,

I just want the pivot table to calculate totals for certain columns without having to cut and paste the table; and then modifying it every time I select a different criterion. I was hoping that the pivot table was similar to MS Access where you can define what columns you want totaled. Cheers

Hi Doroth: Maybe I should elaborate - The "GRAND TOTALS" are part of the pivot table, hence, you can not delete the "cell" to get rid of the totals under the 1st and 2nd (price & qty) column. What I would like the pivot table to do, is when it does the "GRAND...

Need help!! Here's the scenario - have 3 columns 1st column is price, 2nd is quantity and the 3rd is amount (qty * price). At the bottom, under the GRAND TOTAL ROW, Excel sums up every single column, how do you get rid of the sum for the 1st and 2nd column (leaving the 3rd column intact)...

Have a major problem - under "Startup" under the "Tools" menu, I unchecked "Allow Full Menus" and now a lot of the menus are missing things such as "Tools" under the menu bar. Also, I can't even access the "Switchboard Manager". How can I...