Microsoft Excel is a commercial spreadsheet application written and distributed by Microsoft for Microsoft Windows and Mac OS X. If your question is about programming Excel in VBA then also tag it excel-vba. If it is about an Excel formula or worksheet function, then also tag it worksheet-function.

learn more… | top users | synonyms (2)

1
vote
1answer
2k views

Converting a five digit number to date format in excel?

In these spread sheets I have an entire column of values that are supposed to be dates, such as. 200701 = 1/1/2007 200702 = 2/1/2007 200905 = 5/1/2009 And so on and so forth. These will all be in ...
3
votes
1answer
5k views

Excel: #NAME? appearing when linking/referencing other spreadsheets/workbook cells

I'm updating a spreadsheet that refers to data in another worksheet =NameofWorksheet for some reason I get #NAME? in some of the cells, even when the actual path is correct. The only way to overcome ...
1
vote
2answers
1k views

software tools for cleaning up messy data (flat files, Excel etc) semi-automatically?

I routinely receive files, usually Excel spreadsheets, which contain manually-entered data that have outgrown the utility of spreadsheets. I then clean up these files for import into a database. ...
5
votes
1answer
945 views

How to cancel tedious Excel charting operation without crash

I'm charting about 17,000 data points in Excel. Needless to say charting is slowwww. I accidentally selected the wrong chart type (Bubble thing?) and it is loading forever. I did not save my last ...
1
vote
1answer
3k views

Excel file causes Excel to crash when saving file

I have an Excel (2007) file that I successfully save at work and email. The emailed version I can open with no problems. But when I try to save it in Excel 2010, it immediately hangs and goes to ...
0
votes
1answer
111 views

Looking to append a tab separated line from word to excel with a macro

Or something.... Word is integrated with our software so it does only one account at a time. Each tab separated line is formatted like: name address acct# dob amtdue For each account I have to load ...
5
votes
4answers
6k views

Work with hours and minutes in Excel 2007

I'm working on a spreadsheet that holds phone calls durations. So, each call (row) has a value like 00:01:30, 01:02:12, etc. When I sum the duration column, it will give me something like 687:23:42. ...
8
votes
4answers
22k views

Excel Scatter Chart with Labels

I have three columns of data. Column 1 has a short description, column 2 has a benefit number and column 3 has a cost. I can create a cost/benefit scatter chart, but what I want is to be able to ...
3
votes
3answers
3k views

Excel trendline accuracy

This is a problem I have every once in a while, and it annoys me tremendously, beacuse I have always to recheck every trendline I get. An example: r L (mm) 30,00 97,0 60,00 103,2 ...
1
vote
2answers
201 views

Checkbook programs for excel?

Are there any good checkbook programs for exel (or other software) that will take a csv file from the bank? The banks now seem to be trying to force you to install a newer version of quicken and ...
0
votes
1answer
314 views

Total an access database by quarter?

I'm looking for a way to split a large block of data in access into quarters and then total all of the data by quarter. I know how to generate a report and have it break everything off into quarters ...
0
votes
2answers
5k views

How do I write a query in Microsoft SQL Server Management Studio and then use that Query in Excel

I have an Excel file that I want to open up, hit refesh, and it pulls in the data from the SQL server and then I manipulate the data and create some dashboards. I actually have this but I'm pulling ...
3
votes
3answers
4k views

Multiple versions of Excel

I'm running Windows 7 and Microsoft Office 2003, 2007, 2010 together. I would like to open all .xls files per default with Excel 2003 instead of Excel 2010. How do I do this on Windows 7?
2
votes
1answer
463 views

Microsoft Excel 97 easter egg [closed]

Does anyone remember the Microsoft Excel 97 easter egg? There were a series of inputs and keyboard presses you have to do in the cells that would take you to a 3-D space world with mountains and you ...
0
votes
4answers
2k views

.xls to .csv on Mac

How can I convert an xls file to a pipe delimited file?
0
votes
2answers
811 views

Condensing and grouping results from a database in Access or Excel

What I have to do is take the results from a database, and condense them all into one line per date. Right now, each date has numerous amounts of rows, and the data I need is spread throughout each of ...
1
vote
3answers
4k views

Auto-fill rows between two cells in iWork - Numbers (or MS Excel)

This is my table ...A............ 1 1 2 3 4 5 9 I know the minimum value (A1=1) and I know the maxiumum value (A5=9). Now I want to fill the rows in between with the numbers leading up to ...
9
votes
6answers
32k views

Change year in many date fields in excel?

So I've noticed in a worksheet I have many dates that are four years off, no doubt because of improper copy/paste from earlier question. Is there an easy way to convert a bunch of dates I select to a ...
1
vote
2answers
501 views

group by - excel

Is there any way i can group similar rows in Excel?I tried group option in excel 2007 and it did not work for all entries. I selected the whole column and used group by option. Example: name ...
3
votes
2answers
442 views

Fill sparse rows in Excel

I have an Excel sheet which is sparsely filled: I'm looking for a way to turn the left column into the right column. Basically all empty rows should be set to the first filled row above them. Is ...
12
votes
3answers
57k views

How to copy conditional formating to another Excel Worksheet

I have set up conditional formatting in a set of cells of "Sheet2" on my workbook. I'd like to reuse this formatting on "Sheet1" (I've spent quite some time setting it up). Is there a way to do it? ...
1
vote
1answer
242 views

Merging cells in Excel 2007 because the web exporter is a punk

I have to use a web site to export data in XLS format, to be converted to CSV, to be dumped into a MySQL database. My problem is that this POS exporter treats carriage returns in the original data as ...
2
votes
1answer
3k views

Can Excel perform constrained nonlinear optimization?

Can Excel perform constrained nonlinear optimization?
1
vote
1answer
6k views

“Paste special” stopped working properly in Excel 2007

I'm using Windows XP SP3 and am having some annoying problems with the "Paste Special" function in Excel 2007. Usually when I copy something from Excel to Excel and use Paste Special I get this ...
1
vote
2answers
4k views

Horizontal scrolling with mouse wheel/keyboard in Excel 2003?

How can I scroll horizontally in Excel 2003 using the mouse wheel with the keyboard? Operating system is Windows XP.
2
votes
3answers
13k 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
1k views

Best way to bring a large PDF to a readable Excel spreadsheet?

The problem here is, the database/report running software we use can not do certain things that we need (total by quarter/person/year, total for everyone for each one of those, etc.) so we have to ...
1
vote
1answer
339 views

Excel: I copy pasted list 200 links from website to Excel and I want to extract text from the link

The links appear hyperlinked with blue line in Excel, I want to extract the text from the link e.g. The url http:\sea.craigslist.com appears as "seattle" in excel. I want to extract the text "sea" out ...
1
vote
1answer
347 views

How can I add an image in the page header when printing Excel 2000 spreadsheets?

I'm using Excel 2000. I have a spreadsheet document that covers several pages when printed. I am able to add page numbers and basic text to the header (and footer) of the printed sheets, but I would ...
1
vote
1answer
64 views

Linked Lists in Excel

In a spreadsheet, I have multiple workbooks, I would like to sync the names in the first column between the workbooks, addition and removal. is this posible?
3
votes
1answer
3k views

Excel: Why does double-clicking in a cell jump to a different cell?

Normally, when you double-click a cell, you enter in-cell editing mode, right? This works most of the time, but occasionally on random cells, a double-click instead moves the focus to a different cell ...
26
votes
7answers
114k views

How to count number of distinct values in a range?

I've got a large table that is already organized using filters etc. I'd like to add a summary underneath certain columns that contain the number of distinct values in that column. There's no ...
0
votes
2answers
11k views

Dynamically updating list of unique column entries in excel?

I am trying to extract all unique names in a list. Optimally, this would work like the FREQUENCY function, that returns an array (that can then be accessed via the INDEX function). I know both ...
5
votes
3answers
9k views

Does Excel have command-line options?

It would be handy if I could tell Excel to open a file and resave it as a CSV file without making the user do it, or having to write a program to do this. Does it provide any such functionality?
1
vote
2answers
3k views

Getting Excel to handle CRLF's correctly in CSV

I am creating CSV files to be opened in Excel. The rows are separated by CRLF and that's fine, but some of the input data contains CRLF data in it as well. Per the usual standards, I surround them ...
3
votes
3answers
3k views

Excel Graph: how can I show two values in the same bar? Not using stacked?

I've created some data for inventory items over time. Each item has two models (A & B), and the scale is (-) or (+). I've included example images of the type of graph (drawn) I'm aiming for, with ...
0
votes
1answer
548 views

On copying a sheet, a warning mentions an undefined name range

When attempting to save a Excel 2007 document I get an error saying, "A formula or sheet you want to move or copy contains the name <...> which already exists on the destination worksheet."
0
votes
1answer
212 views

Excel Formula: trouble with the low % values not showing up in an in-cell chart? (image included)

I've a few tables that have % values like -4.5%; -16%; 15%; 6%; 2.5%. I'm interested in creating some in-Cell charts that show positive and negative values. My smaller values aren't showing up, so ...
6
votes
8answers
17k views

Changing bounds of excel file embedded in powerpoint

When I embed an excel files into powerpoint, I'm having two issues. On some of the spreadsheets, empty columns are displayed on the right hand side of the powerpoint slide On other spreadsheets that ...
0
votes
1answer
166 views

copy/paste vlookup,that looks up 2 criteria,where 1 of criteria is static and other dynamic

=VLOOKUP(B1&A3,'cstmr data'!1:65536,8,FALSE) hi, I am unable to drag this formula to other cells in the same column. I need cell B1 to remain static and cell A3 would correspond to the ...
11
votes
2answers
93k views

Excel chart with two X-axes (horizontal), possible?

Is it possible to create an Excel chart which has two X-axes (i.e. horizontal axes, not vertical Y-axes!) ? I want to use the second axis to plot the normalized value of the default horizontal axis. ...
2
votes
3answers
10k views

Excel workbook protection: how can I stop users tampering with a workbook?

I have a workbook with a lot of sheets, macro's and calculations going on. I now need to send this sheet out (not forseen before yesterday). How do I lock it down so that users: are unable to ...
0
votes
2answers
200 views

Use excel sheet as a template and quickly switch to other input values

I have a sheet that takes 10 input parameters and a whole bunch of caluculations. Now I would like Excel to do the calculations on another array of input parameters, without having to copy the sheet. ...
0
votes
2answers
75 views

Counting Excel Files on a File Server

I'd like to know how many Excel files are on my File Server. There may be hundreds of thousands. When I remote into it and search for *.xls I get a huge list of files. However, when I try to right ...
1
vote
1answer
104 views

Excel is inserting address into existing cell content problem

Excel 2003. A schedule template used for years has never had this issue until the new user started and I can't reproduce the error because we never see it happen, only that it HAS. Cells have content ...
1
vote
1answer
1k views

How to mark cell in Excel spreadsheet as non-page-breaking?

Is there any way to declare a cell/row in Excel as a cell/row that should not be used for page break. Example: A1: 1. My content title in bold A2: Empty row A3: More and more content, description, ...
1
vote
3answers
306 views

check of date with functions lookup

i have input date in sheet1 say in A! 15/07/2010 and in another sheet range of dates with interval of six months in a1 01/01/2010 and in b1 30/06/2010 and c1 15 likewise data is there i want to ...
3
votes
1answer
66 views

Using data from a table in other table

By example table1 Position Salary Seller 150 Management 200 Technical 120 Maintenance 100 table2 (in same sheet or diferent, doesn't matter) Name Position salary ...
2
votes
2answers
698 views

Using excel sheet as a function

I wonder how I can use an excel sheet as a function. Let's say I have a complex calculation in Sheet1 with one parameter I would like to iterate over a range like [1 to 400] in a second sheet to ...
1
vote
3answers
9k views

How to start Excel as a different user?

How can I start Excel as a different user? I'm using Win XP and Excel 2003