I some spreadsheets that when I go into the page setup screen, I get the message 'margins do not fit page size'. There is nothing I can do to get out of...

I have a long list of data that is sorted by name. The total list is about 500 rows, of those could be five to 10 of one name before it switches to a new...

Hello, I am having a problem editing queries created in MS Query. I create the queries without any problems, and am able to add criteria and bring the query...

Is there a way to remove all spaces within a column of cells? Extra spaces are screwing up my subtotals. Thanks!

Hello, I can't figure out why when I set the paper size to 4x6 index card in Page Layout/Size and then view the worksheet with View/Page Layout the rulers...

Hi there. I'm doing control chart study and I have plotted one scatter plot in my graph. I want to plot three more linear line inside the graph but I do not...

How can i turn off text to speech?

I have a spreadsheet of shortpayment amounts and their invoice numbers on one spreadsheet with a column of credit amounts with their invoice numbers on...

Hi, I need to calculate the average of a column in a pivot for eg. Jan 09 and Feb 09 so on and so forth for the whole year. Now how can i calculate the...

Hi, I am trying to share my cube connections files (ODC) in a sharepoint data connection library, buy I can't set the "OLAP Server Formatting" options...

How do I make a draw for 6 teams to play each other at 3 different locations

How do I code a function CellVal(rownum, colnum ) that will be the equivalent of the worksheet formula: INDIRECT(ADDRESS(rownum, colnum )) that...

I have a phenomenon I have not seen before, despite using Excel for over 15 years. Can anyone please point to a cause? Excel 2000 on a Windows XP SP3...

I need to show latitude and longitude in my Merchant Navy Log abstract. can anybody please tell me how to show degrees, minutes and seconds Thanks

How do I stop Excel from creating a "back-up" copy everytime I "save" a document? It only does this when I "Save" not when I "save as". My folders are...

I have a master list on one worksheet with 8 columns of data. One of these columns (the 4th one) has a name entry. (there are only 4 names that would be used...

Is there any way to get #NUM! error to be hidden? The formula works great but for every instant returned that does not have a value iit shows this...

helllo again, i a have a "Y" column of date entry. Most of dates are repeated, some are entered once. I need to count only the number of dates (excldg...

I use Excel 2007 to draw. I would like to be able to add pattern fills like hash marks or dots to drawing shapes.

Hi I need to sum a cell range (F2:F90) based on two conditions of two other cell ranges (D2:D90="XXX" and I2:I90=""), where the parameter of the first...