I have just cleaned my keyboard and now when I type in a % then click out of the cell the % turns into three little dots ... What have I done?????

Excel 2007 I would basically like to use Excel as a Word Viewer, something like the following. In the cells in column A would be the names of files in a...

I have a problem printing a simple spreadsheet. I have a single column spreadsheet with several hundred rows. The cells contain text anywhere from a few...

I have a workbook that contains multiple worksheets. I want a particular people to be able to view and edit one specific worksheet, and not be able to see...

I have a excel workbook with 15 worksheets and every month when I produce the annualized turnover I have to go into each header on each sheet to update the...

I have columns of numbers that represent date/time info. For instance I have the number 20081029092245 which represents: 2008/10/29 09:22:45 or...

Hello, How do I specify in Excel or Access so when performaning pivot table in Excel it does not return a "(Blank)" field but instead treat it as 0? Thanks

In Excel I have many tabs and each one of those workbooks I have the date in the footer. I want to have all the dates tied together so I tried entering a...

I have no experience with macros @ all. Really need your help. I have a spreedsheet that I sort by column A, depending on what code is in column A, I need...

Can someone please tell me if it is possible to write a formula that would extract all the text that exists between the vertical bar symbol "|". Example in...

I have an Excel spreadsheet with data in column 1 that is in an order which only makes sense to me. I need to leave it in this order when I create the Pivot...

Hi, I have two Tables and I need to generate a histogram chart to compare the data of those two Tables. I want a Dropdown to select a category like total...

I would like to automatically insert a blank row in a spreadsheet everytime the cell value in a particular column changes. The blank row should appear above...

Hello, I have on a spreadsheet a column for dates. The dates are entered in the format dd/mmm/yyyy and then the cell formatting changes them to mmm-yy. This...

I am not able to rename or insert tabs in Excel 2003, and I am not able to right click on the tab. To further complicate this, I go to the Tools menu and...

I would like to know how to get to the print preview version of a document so I can email it to customers. I have only been able to figure out how to email...

I have a spreadsheet with 11 tabs. The first tab (tab A) contains all the info. The subsequent tabs are info (tabs 2 - 10) containing parts (sections) of...

am using excel xp2003 - I keep saving a spreadsheet without the read only box checked .... but when I open it later for editing it opens as a read only?! I...

I'm not even sure how to formulate this right, so please forgive the generic thread title. I'm racking my brains trying to come up with a formula for an...

We're trying to decide if it would be beneficial to upgrade from excel 2000 to excel 2007. What are the differences between excel 2000 & excel 2007?