I have a spreadsheet with a picture on the first page. When I look at the spreadsheet in any of the Excel views it looks great however when I print the...

I want to be able to type in a workbook name in cell A1, example "05-03-10 Sales", and in cell B1 pull in cell A3 under the tab SALES in that workbook...

I am in need of some ideas. I am attempting to put together an automated cleaning list for one of our locations. What is the best way to do this? The tasks...

As new data is input the chart remains the same and doesn't reflect new data. The data values and number of entries can be completely different. I think...

Hi all, I would like to have the following run every time when the Excel 2003 sheet is opened: so I am going to put the VBA macro into AUTO_RUN...

Date 5/4/2010 Starting in early summer 2010, Microsoft will begin progressively closing down the Microsoft public newsgroups to enrich conversations in the...

I have a pivot table in which the data area includes a 'count' of a text field. I am trying to create a calculated field which will divide the sum of a...

Is there a way to search an entire workbook for keywords and return the entire row? The same as "sort" does on one page, just across the whole workbook.

Date 5/4/2010 Starting in early summer 2010, Microsoft will begin progressively closing down the Microsoft public newsgroups to enrich conversations in the...

Hi- I have tried multiple times, and I am losing the order of conditional formatting for a cell when I copy it to another cell. The relative reference copies...

Let's say that you have a spreadsheet with three fields, like: Year Group Value 1970 1 3 1970 1 1 1972 1 1 1973 1 ...

I have a pivot table that only has column header and data fields - no row area. I would like it to show totals for each column, but nothing happens when I...

Excel 2007 Conditional formatting is not changing formatting unless something is triggered to refresh the screen. For example, cell D5 has the following...

I would like to close existing file and go hibernate, but once this file is closed, the command hibernate cannot be run. On the other way, I run the...

I keep losing all the formating on my worksheets when going form 2003 to 2007 and vice-versa. I try to fix it and then it reverts back to a non-formatted...

Can a custom number format be created to format a value such as 9,999,999.25 to format 9 999 999,25? I know the # ### ### works to add spaces but I can't...

I accidentally moved the excel up so that the toolbar is above the screen. How do I move it back down since I can't see the tool bar to grab it?

-- Is it possible to protect/unprotect all worksheets in a workbook at once instead of having to do each individually if the password is the same? News Gal

I have a multi-tab worksheet, but I only want to send out via email 2 or 3 tabs, not my working pages. Can I just send 2 or 3 tabs or do I have to always...

How do I concatenate two date fields (2/1/2010 & 4/4/2010) with results of 2/1 - 4/4