When selecting "print preview", (printing to PDF), error message states margins will not fit...in addition each cell appears as a page ot be printed. For...

I need to calculate square footage totals...The dimensions are in a single cell (example: 132 1/4 x 52 1/8). I know that width x height (calculated as...

I am trying to use the Auto-Numbering feature but with alphabets: what I need; to auto add the alphabet when i drag scroll down so it should look like...

I have a spread sheet that I enter new data at the bottom of the sheet. I have a unique formula for each column that ends at the last entry. How do I entend...

Hi All, Thanks in advance. I have a situation where a user is trying to use the CTRL + PAGE UP function to switch worksheets but gets the following...

I just upgraded to microsoft office 2007 from 2003. I also installed the latest office service pack. Everything seems to be working fine, just a bit of a...

Currently I have a data sheet that looks like this: _____A_______B___ 1____A_____Data 1 2____B_____Data 2 3____A_____Data 3 4____C_____Data 4 5____B_____Data...

I have an access database (2007) containing data which I have summarised via Pivot Tables in an Excel spreadsheet (2007) using Microsoft query (and pivot the...

I have a pivot table that has had more data added to it. The page fields are no longer sorted (since the addition). I'm using Excel 2007. How can this...

once you change the value of a data label in a PivotTable, is there any way to restore the label back to its original value?

When I am opening dbf file in excel 2007 , some date is showing as 04/01/2009 04/01/2009 20090423 20090425 So how I can convert all the date into same...

I have a cover page that does not require the header/footer information that is required for the remainder of my document.

Hi, I've got a couple hundred links to folders in an excel spreadsheet. The folders are all moving to another drive. Is there a way I can do a Find&Replace...

If for example I put a formaul such as =5/3 into a cell, I know I can format the cell to display just 1.67. But if I copy and paste the value into a cell...

Is it possible for me to fit 17 columns on one page and still be able to read it well? Thanks! -- Sherry Vinturella

All of a sudden, worksheets with formulas that I have been using forever are not responding to changes in data. I checked formulas and formatting - all is...

Hi Scenario 2 workbooks with the same information . I need to do a vlookup ( I think) to get the total number of orders for the company . ...

1. Name="Data" B4:B11 = {"data", 1,2,3,4,5,6,7} 2. formula =OFFSET(Data,1,0,3,1) 's value is 2 when at E6 , seems fine 3. But same formula becomes an error...

I have a coulmn with numbers, but they are formatted as text. ESN #s 268435456106743252 But when I format it to numbers, I get the following...

I have a user using Office 2007. When the print from each application except Excel they get 1 print job. When they print from excel they get 2 copies of...