Hi all, I have an excel with the following format. I have to find out subtotal of the each date column. The empty date column should be considered under the...

Using Office 2003 and Windows XP; Is there a way to get Arial font to appear in small caps in XL? If so, how? Thanks much in advance...

I have version 2003 of excel and love hot keys... Often at work I have to format rows and columns to others nearby.. I have tried to figure out the hotkey...

I have created a document in Excel 2007 with some normal cell formatting, such as bold text, merge & center, and border lines. When checked for compatibility...

The text box is with in the print area. I can not see it in print preview, and it does not print out. But I can see it when working the sheet

Hi, I find it difficult to read the cell content correctly at a distant column of the same row. For example to read the cell content of PQ 354 when the...

How can I print my worksheet without the default numbering on the left next to colum A.

i am new to excel 2007 and when closing the only visible sheet in my workbook i need it to close the workbook without offering option to save. i have tried...

We are creating files in 2007, but have to save in 2003 because not all users have 2007. As a result, we are losing formating. It will wipe out colors,...

I have a very large spreadsheet of all of our cases. The headings correspond to the following columns: case # = column A, client # = B, last name = C, first...

Hello All, I download from SAP to excel a database. But unfortunately I can't convert date cells to text. For Example: 2010.02.01 and if I convert to text...

I have Office 2007 and recently upgraded to Windows 7. I have a minor problem. Sometimes when I open an Excel document (about 50% of the time) the ribbon...

I have Office 2007 and recently upgraded to Windows 7. When I open an existing document in Excel, sometimes (about 50% of the time) it opens a second blank...

Somehow I have managed to change the grey column headings from capital letters to numbers and I don't know how to change them back. Please help Thanks Will

Hi I have Change event macro that sorts a table in G3:O6 when a value in F3:F6 is changed. What I need to happen is that if the range of the entered data is...

I keep getting an error in Solver, "Set Target Cell must be a single cell on the active sheet". The problem I am doing is very basic. I have tried solving...

I'm using Excel 2004 for Mac on a MacBook Pro with OS 10.5.8. When I go to enter data into a cell, the window automatically moves so that A1 is the...

I have a formula that references another excel workbook. The name of this workbook will be different depending on the date. Yesterday, I summed numbers...

I have created my own conditional formating. Condition 1 Cell value is greater than =$F$14, colour red Condition 2 Cell Value is greater than =$G$14, colour...

First post so please be gently. I have a customer who is experiencing issues with a particular process in Excel 2007 and I wanted to seek clarification on...