I have a long list of various components that I want to summarize. For example: Column A Column B Material 1 ...

This is not chart. I get this error message when try to refresh PivotTable report in my excel file. I see lot of online posting the error message related to...

I've hit some combination of keys that makes my workbook open at a specific cell everytime. When I close, I am always at another location and hit Save. But...

I have an excel sheet with thousands of email addresses listed down one column. There are numerous bad emails that are missing the @____ in the address and...

I am setting up spreadsheets for 2009 and I am using spreadsheets from 2008. 1 spreadsheet is a monthly summary of items done weekly and is associated to 3...

In Excel 2003, I went to tools customize options always show full menus. In 2007, I went to Excel Options customize but I never found anything about...

I have a workbook with 41 sheets. When printed out each sheet may be more than one page. However, each sheet is a separate tab in a notebook. So I wonder...

Hey all - Got a head-scratcher here. Hoping someone can help. Here's the scoop I have a pile of data (6k+ rows). Amongst this data, there are two columns I...

I'm used to doing this without a thought in earlier versions of Excel, but I was recently upgraded to 2007, and I can't for the life of me figure it out....

I am trying to make labels from my excel worksheet to Word's mail merge. I have 1364 entries on the Excel worksheet and when I select the data source for...

Excel 2007 - need to repeat values in Pivot Table rows even when duplicate, e.g.: Database Table db1 tbl1 tbl2 ...

I am working to create a Macro that will look at a specific column and fill down a formula. The Macro is working properly to identify the column, but it is...

Hello, Is there any way to format a cell so that it displays what is typed in as a password (ie. as *****) rather than showing what has been typed in? Thanks

I need to set up a sequence number system through excel for an excel sheet for audit purposes. I need a numbering system that is going to work every time...

I have a vlookup in a number of cells that is activated once another cell has a value entered into it. The vlookup works just fine. #VALUE! diplays in the...

Hi, Does anybody know how can I change the five accounting formats that appear by default when I click on the Accounting Formats dropdown menu on the Home...

My table consists of accounts with the same name, date received, dated needed, etc. Also, there can be multiple rows with the same account name and date...

Good Morning, How can I display a change in value of Cell A1 in cell A2?

Hi, I am creating an excel file that has all our forecasting information for multiple geographies. I created 1 master file that has all the locations and...

Trying to read/open a WK4 file. I am getting the message "File Blocked by Registry Policy setting". How can I correct this so that I can read Lotus files?