I have made a Line-chart containing 8 different series. I now want to change 2 of the series to Bars, but in the same chart. How do I proceed to pick the...

Is there a way to add a new entry to a right mouse click dropdown list? When I right mouse click on a cell in the drop down list of available commands, I want...

I have a timesheet I wish to create. Below is the format I wish to send it out in. I need ot be able to sort final data by (employee, department, project,...

I have a spreadsheet with some conditional formatting. How can I copy the appearance of the cells without the formatting condition?

Bob Phillips wrote: *Here's a technique that I discovered a few weeks ago, and I am getting fond of. This code assumes the client name in column A of...

Though data sets can be bigger than they were in the past, issues are still occurring with smaller data sets. Users find that the processing is a lot worse...

I have two columns in a spreadsheet that have the following formula =IF(j8="",0,G8), I need to add something to this column that will flag if collections drop...

hi in an excel sheet when i try to sutofit columns E and F then through a macro it gives error and stops the macro in betweeen. so i tried to double click...

I need to copy a lot of raw data from html format into excel. Most of the data consists of a min/max figure (eg. 31/45) Excel (2003) always converts this...

I am attempting to link a SECTION of a word document to an excel document via a hyperlink but 'couldn't do it. I tried setting up a bookmark for the sections...

Is there away to get sequential page numbers in each footer for each page if I print an entire workbook? Example: If Sheet One is 3 pages, Sheet Two would...

Hi I get "Personal.xls locked for editing by '.' " for users opening Excel. Can anyone advise where this file is and who could have it locked ? thanks Wayne

Hi, I created a Macro but I want to have it show up on a toolbar. I know that you can create a custom toolbar but how can i add a macro (which I would need an...

Hello, I have office XP. The issue that I am having is when I export a table from Access to Excel (and I'm usually copying over an old file because it's a...

When I use ctrl/end in my worksheet, I end up in column HH:93 even though as far as I can see I only have data through I:93. How can I find the ghost data...

This is an old post, but I wanted to post the solution for others to benefit from. I did a complete re-install of Windows XP and the whole problem was...

Hello! My problem is that Excel crashes when i open one of my files. I have experienced this only ones before in all of theese years I have been using...

I have a filter set up. Every time I click one of the drop down lists to select a sub-set Excel saves my spreadsheet with the new selection set. What is going...

I have an Excel2000 workbook on a shared drive; users fill out some cells in the excel file and are supposed to do a "save as" to save it as a separate file....

Is there any way to protect or lock a "freeze window" setting so that others can't unfreeze the window, change the rows, and re-freeze the window, thereby...