0
votes
0answers
26 views

Why does Excel 2007 change 13 to 14 when typed in?

Every time my co-worker types 13 into an excel cell, excel changes it to 14. She was using excel 2003 and this was happening. Our tech installed 2007 and it is still happening. We have to use a ...
1
vote
1answer
73 views

Microsoft Excel lookup match without sorting data

Have a value list and need to insert points by looking up the data table. Data table has value for points in 1000 increments. Actual value that I lookup will not be rounded to 1000 so I tried using ...
0
votes
1answer
320 views

MS Excel 2007 Warning Significant loss of functionality

I have created a template in MS Excel 2003. In MS Excel 2007, when I save it in MS Excel 1997 - 2003 format, it gives a compatibility warning; Significant loss of functionality This workbook ...
1
vote
1answer
313 views

Convert multiple rows into single column based on values

I have a excel sheet as A 1 2 3 4 B 1 2 C 1 2 3 4 5 I need the output to be looked as A 1 A 2 A 3 A 4 B 1 B 2 C 1 C 2 C 3 C 4 C 5 I will be greatful if anyone will help in finding a solution ...
1
vote
2answers
3k views

Can I use “Fill Down” to make a vertical series reference a horizontal series?

Say I have a data series going from A1 to E1. I would like to make a second copy of these cells going vertically, for instance from G1-G5. I can achieve what I want just by typing =A1 into G1, =B1 ...
2
votes
2answers
544 views

Rearranging a 15 X 25 Excel matrix into three columns

In Excel I have data in cells from A1 to O5 (15 X 25). I wish to rearrange things such that I have the following [A1][B1][C1] [D1][E1][F1] [G1][H1][I1] [J1][K1][L1] ...
0
votes
2answers
245 views

Template is working for Excel2003 but not for Excel2007

I created an Excel worksheet (Book.xlt) under C:\Documents and Settings\username\Application Data\Microsoft\Excel\XLSTART with my own setting. That settings are occurring only for Excel2003(.xls) ...
1
vote
1answer
304 views

How to calculate the total sum of hours with automatic filter

I have an Excel sheet where I sum hours to get the total amount of my work. It works without problems, but if I add an automatic filter I'd like the calculations to be done only on the portion of ...
2
votes
2answers
16k views

How to get excel row numbers to skip the header

This is really a cosmetic question. Excel by default starts counting from line one which is the header. Is there some way to have it start counting from the real line one (the line after the header). ...
1
vote
1answer
1k views

Drag-and-drop a new series onto an Excel chart

In Excel 2003, I can select a new data series and drag it onto an existing chart to add it to that chart. In Excel 2007 I can't. Does anyone know if this functionality was removed or if it is ...
0
votes
3answers
3k views

Move markers of line chart/ Format legend

I have a combination chart with a bar chart and 2 line graphs on secondary axis. have to exactly match the formatting in the screenshot attached ( I do not have the actual excel file. just have a ...
2
votes
5answers
1k views

Excel not properly recalculating values

I have an Excel sheet with values in it (this sheet is generated by a custom perl script, but I don't think that's where the problem lies). In it, I have a formula: ...
0
votes
1answer
746 views

Excel file with macros saved in 2007 crashes when opened in 2003

My team keeps a large Excel file on a SharePoint server. Recently I've edited this file with Excel 2007 and saved it. Afterwards, everyone who opened the file with Excel 2003 and chose to "Enable ...
0
votes
1answer
689 views

Select graph data to display using checkbox

I dont know if this can be done in excel or not. I tried to look around but could not find anything. Here is a simple example - There is a simple column graph for sales, expenditure and profits. There ...
3
votes
2answers
7k views

Fill an area between two lines in a chart in Excel

There are a lot of hacks to fill the area between two lines in a chart; however, I want one that works seamlessly between 2003/2007 and mac 2011. Preferably, something that is not a hack.
2
votes
3answers
12k views

Excel 2003 upgrading to Excel 2010, will it break our models?

My office is upgrading from Excel 2003 to Excel 2010 and we have a lot of tools in Excel 2003 (complex custom formulas, named ranges, VBA, pivots... almost every feature of excel can be found in at ...
2
votes
1answer
539 views

Conversion Pdf 2 Excel

Hello to everyone and thank you in advance to all the superusers that will help me. I need to find a freeware (not trial) able to convert a pdf document on a excel sheet. Could the superusers ...
0
votes
3answers
1k views

custom format for cells with nothing in them without using conditional formatting

if a cell is blank I would like to add text using a custom format. I've seen where text is added if a value is above or below a certain value. Can you add text to the cell if the cell is blank? I've ...
8
votes
1answer
15k views

Hyperlink font in Excel always changes to the default font face/size

For cells containing hyperlinks the font changes automatically into the default one (even though I have selected all cells and applied a different font). How can you configure Excel to use the same ...
1
vote
2answers
943 views

ASCII codes appear in Excel '03 but not '07

Part I - I have a spreadsheet that was from data exported from an application. When I open it, I can see the 'boxes' that usually are from a line break or paragraph break in a cell. IF I view the ...
2
votes
2answers
17k views

Converting excel 2007 files to excel 2003

I'm currently using a library named http://www.codeplex.com/ExcelPackage>ExcelPackage to generate a large number of excel files. Unfortunately it saves in an xlsx format, the Excel 2007 OOXML format. ...