I had a very annoying quirk that suddenly appeared in my work copy of Excel 2007: whenever I opened Excel, I was presented with a blank workspace. I was...

Hi, Help Required I have 400 clients listed in Column A and Column F has 4 options for each client. The colums A and F are as follows; Column A Column...

When I am on a chart sheet and change orientation from landscape to portrait, I cannot recover the landscape orientation. I've tried creating new charts,...

In Excell 2000, I have successfully refreshed a pivot table via VBA code. However at the end of the process I get a Microsoft popup. PivotTable ImportD... ...

Once information has been entered in worksheets and saved can you rearrange worksheets in different order?

I just reinstalled ofc2003 on a win xp system and now for some reason when I open an excel attachment in outlook my computer opens a second instance of excel. ...

I am looking for a formula that will give me a recommended headcount number based on the following data. store a is 50% effective with 6 people store b is...

I am trying to put together a user form that will open windows explorer and let the person choose a file but not open it. I want it to record the file name to...

I am trying to tally the life time hours of a piece of equipment taht the hour meter has quiy working on. I know the hours on it when new meter was...

We are planning a re-organize our primary Drive and will be moving most of our folders and subfolders. We commonly use hyperlinks between workbooks. We are...

I have wide column headers to accomodate a lengthy text label. But the data only requires 5 characters. I increased my header row height, decreased the...

I have 9 Spreadsheets consisting of contact information for publications in different industries. 8 Industries and 1 Master List. I would like to link the...

how could I ordering alphabetically a column?

Hi I am using Office 2007 and need all excel windows under 1 excel frame so that i can switch between windows

I have a xls file that will not let me do any cell formatting to some cells. I can use the format painter to force changes. The sheet is not protected. I...

The formula: =sum(h10,h14,h20,h40) The result should be: =sum(4,5,4,4,4,) =21 I however get 20 as a result. Tools/Options is set to automatic and the "h"...

Is there a formula on changing numerical dollar amt to their written-out form? If there is, can you tell me?

Hi, i need a macro to delete all rows except for the smallest and biggest time in column "B". But i need the code to look in other columns before that. Some...

Hi I am trying to create a multi layered drop down a bit like the Windows Start menu. Therefore you have a drop down menu a,b,c and d. If you select one of...

My spreadsheet has auto filter set and has therefore created lists at the top of each column within my specified range of cells. I would like to retain the...