Hello Could anyone help in proper saving as html? My xls contains charts and tables. Print preview looks OK in Excel, but when I save it as html. Settings are...

I have a data table with column headers (U - Z) and row headers (A - E), I would like to enter the two headers, e.g. V and E and find the number...

thanks domenics one seems to be working -- neowok ------------------------------------------------------------------------ neowok's Profile:...

I would like to create a formula that increments the value of one cell. Here's the dilemma. A5 contains a number entered as text, 001. I need to keep that...

Never mind. Just figured it out. Sorry for taking up your...

I have a excel file that should print out and fill the page but only prints to 65% of the page. Please help as i can not find the setting to fix it.

Thank you Peo, if I'd only known how to do it correctly the first time. And, yes, it's all backed up. There are sometimes over 200 entrants, each with their...

Is there a way to filter by a formula? For instance, I want to filter all data with dates today(). I tried entering in 'less than' and 'today()' but it...

I was wondering is there a formula that can subtract something is the amount is a postive number but when the number is a negative number can it add to that...

Many thanks Frank, it worked really well. Much to my surprise there were a couple of hundred...

Hi All, I have just managed to figure out how to setup a pivot table. My question is, now that I have managed that, how can I get the pivot table to...

Hi Could someone please help me? I am using Excel 2000, I have a spreadsheet with several columns all with filters... the problem is, is that when I protect...

Is it possible to Hide Gridlines on ONE Sheet but not the others? Alternatively, would an Event Macro for Activating and Deactivating the Sheet in question...

When trying to enter a negative number, such as -1, excel changes it to 01.

How can I insert a number leading off with a 0 into a cell that is formatted as general without the 0 getting kicked?

How do I find my question that I posted yesterday? Thanks

I have an Office 2000 Excel address list containing an email address for each entry. I wish to send a blanket email to everyone in the list. I've...

yep...I can click in any other program...just isolated to excel. I'm thinking it has to do with code in a macro that I ran at once point and now I can seem...

Hi, I would like to be able to have a macro that would automatically open ALL the files in one particular directory. Say I have various directories, each...

hello, i am trying to calculate averages using excel's median and avarage calculations but after multiple attamptswith no luck!. I have values in 409 cells...