I have 2 users that open the same spreadsheet. The spreadsheet shading looks quite different on both displays and prinnts the different shading. They are...

I have a small Excel 2003 workbook 1,300kb that takes 3 to 5 minutes to open. It was created in 2006 and has been opened daily since then. One sheet in...

There are preset borders available to use on the Formatting Tool bar and some of them have changed from standard lines to thick lines and I don't know how I...

I have two different excel documents. One is called "Job Costing" and the other is the "Project Book". I update the Job Costing sheet daily, and then I put...

I would like to save my standard footnote and reuse it in other 2007 office documents. Do I need to set up a template document or is there a way to automate...

Do sum up cell A1 of each worksheet from 1 to 6 I would use this function: =SUM(Sheet1:Sheet6!A1) BUT what if I don't know how many worksheets I will be...

HOW DO I KEEP THE CELL MARKER FROM MOVING DOWN AFTER HITING ENTER?

I'm trying to set up a conditional format that depends on the value resulting from taking the value of a cell and subtracting value in the cell above. I...

Hi, I have a workbook with multiple tabs. All tabs have a defined names region. For example if a tab is named 401 there is a name in the tab for 401 =...

I have a macro that runs a query against an external data source and then updates the range of a pivot table based on the number of rows and columns the...

I do alot of quotes and I want my customer to be able to see the price on the Doc. but when it prints can I block out the price to where it comes out black...

hello, I had recently received a macro that I was needing some help with. it seems to work on columns where there are formula's only. when i tried to modify...

I'm using the following formula in date format. I need to amend the formula so that if the result is a blank cell, the formula returns an answer of "null"...

hi, learning but am not good at macros, want to save time updating formula's in a column, steps: 1 i will manual copy cell at top, 2 want to select any...

Please help! I have a report that is pulled regularly. It contains thirty day of data each time. Header row on line 11. Data starts on line 12. Column C & D...

Excel2003 ... For Cells to be perfectly square ... What is the Col Width to Row Height Ratio I would use? Thanks ... Kha

We are using an Excel workbook that has been shared rather "successfully"; however, now the file is "locked" by one user that does not even have the file...

Is it possible to add a recording to an existing macro? The only way I have been able to to so this is to create another recording and then copy the code...

Hi, I have a worksheet of projects listed by quarter. A cell (say A6) contains QTR 1, followed by cells in column A filled with a series (1,2,3...say up to...

I have a surface chart with several bands of various color defs. Occassionally, but not always, when the source data is modified ALL bands take on a purple...