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)

2
votes
7answers
4k views

How do you put data from a web table into Excel?

I'm trying to build a spreadsheet from a few different webpages that have data in a table format. How do you put data from a web table into Excel?
9
votes
2answers
48k views

Excel: How to convert “string” to a “number”?

I have a user with a query from an SQL Database that returns a series of string in this form: 000123123.23000 000123123.23000 000123123.23000 000123123.23000 000123123.23000 These are really ...
2
votes
3answers
479 views

How to update all functions in Excel 2007?

Is there a way to quickly fill down a column of functions. For example, if I change my function from =3*B2 And then fill down so it does it for a lot of rows. But then change this column to: ...
1
vote
3answers
843 views

Divide humongous excel sheets into multiple excel files

Not exactly a programming question but I have an excel file which has over a few thousand records and I would like to have it divided into smaller excel files of lets say a few hundred records. Whats ...
1
vote
4answers
14k views

Excel 2007 | Remove blank fields from pivot tables

Every time I create a pivot table (available for all Excel versions) I get one or several blank fields. How can I get rid of them? One workaround I used was to select the blank field, right click | ...
0
votes
2answers
511 views

Sort highest match in excel

How can in Excel sort multiple collumns with data? Column B = Subscribe date Column A = Subscribe name I have multiple columns with a lot of doubles names (A) and different subscribe dates(B) How ...
4
votes
4answers
5k views

Excel, sort multiple columns

How can I sort multiple columns in Excel? So first sort culumn B and then A, D
4
votes
4answers
1k views

MSFT Excel pivot table links to external data

Question1: What is the best online forum to ask MSFT Excel questions of the following variety? Question2: How can I link an excel pivot-table to a potentially changing source table without having to ...
0
votes
2answers
33k views

How do you move between lines in a cell with multiple lines of text in Excel?

If I have a cell that is multiple lines of text, I can drag the top bar down to see all the different lines in the cell, but when I hit enter, the cursor goes out of the cell and onto the next. How ...
3
votes
4answers
8k views

Excel: Finding a value in a range of values

In my Excel document, I have one sheet containing a column of important dates. In another sheet I have a list of all dates. I want to conditionally format that list such that if the date is present in ...
12
votes
11answers
167k views

Recovering Excel documents that were closed without saving

Can I ensure that if I mistakenly close a Microsoft Excel document without saving the latest version, that I can recover some of the work I've done? I'm using Excel 2003.
44
votes
8answers
40k views

Open Excel files in new window

When I have Excel running and I double click an Excel file in Windows explorer, I'd like it to launch in a new window by default so that I can move documents to separate monitors. Is there any way to ...
1
vote
3answers
2k views

How can I use the Excel PMT function to calculate a mortgage payment?

The formula wizard asks for: Rate, NPER, PV, and FV. I have the following info: I guess the rate would be the annual interest rate (say 5.5%) divided by 12, or 0.48%. NPER is the number of ...
3
votes
4answers
3k views

How can I copy a formula multiple times and always refer to the same cell?

I have a number in cell A1 and a column of 20 numbers in the B column. I'd like to put a formula in each of the cells in the C column next to each number in the B column. Let's say it's =B1-A1, and ...
1
vote
2answers
167 views

Excel Shortcut to Editbar

I currently have to do some work in an Excel sheet and as we all know Enter jumps to the next row (at the current column) and I can start typing. Until I have to use the arrows (Ctrl + ...
1
vote
1answer
2k views

Google Spreadsheets: Counting number of matches between two rows

In a spreadsheet in Google Spreadsheets, I have multiple-choice answers I would like to grade. One row (user 0) contains the answer key, and the other rows contain user answers. User Q1 Q2 Q3 ...
1
vote
5answers
593 views

Unable to create charts for all values in an entire column in Excel 2003

My Excel data looks like this: (it's a lot bigger in fact) code1 code2 01/08 02/08 X A 12 10 X B 8 15 Y A 52 0 Y B 5 5 Every day I ...
3
votes
1answer
173 views

How do you do multiple regresson in Excel (to show Mediation)?

Does anyone know how to use Excel to do multiple regession to show full and partial mediation using Baron and Kenny's method and alternatively Preacher and Hayes. I've been looking around for ...
81
votes
12answers
267k views

How do I compare two Excel documents? [closed]

The compare function in Word 2007 is very handy -- is there a similar capability in Excel 2007? I can't seem to find it... The documents I'm trying to compare are essentially two versions of the same ...
1
vote
8answers
6k views

How can I calculate the sum of all positive integers less than n?

I have the following function: f(n) = f(n - 1) + (n - 1) f(0) = 0 n >= 0 I have n declared on column A, and need the result of f(n) on column B. I'm trying to find the Excel formula equivalent ...
2
votes
3answers
6k views

Excel 2007 Sharing Violation error on a standalone PC

On my home PC, why do I get the Excel Sharing Violation error while performing a Save operation in MS Excel 2007? The exact error message is: Your changes could not be saved to 'filename.xls' ...
1
vote
2answers
3k views

Fix a (Today) Date in Excel

How to fix a Date value in excel cell? Explanation: I have a file with a VB macro who put a 'TODAY' value in a cell when i click a button. but! i would like to lock the value.. So if i open the file ...
4
votes
5answers
2k views

Excel 2007 is converting CSV fields into formulas

I have a problem with a CSV file which has telephone numbers stored in their internationalized format (+1-800-555-1234). When opening this CSV in Excel 2007, it converts that data to a formula and ...
2
votes
2answers
10k views

Unlocking Locked Drop Down boxes in Excel

I have a couple of drop down boxes on a form that are what I'd like to dub "perma-locked". Every person we've thrown at the form is unable to unlock the drop down. The drop downs do not show a ...
3
votes
1answer
7k views

Multi-value selection in an Excel cell

There's a way to make an Excel cell kind of a dropdown selection box. You would just go to Data->Validation with a cell or a range of cell selected, select list as the data type and specify the list ...
0
votes
3answers
781 views

Excel does not have enough memory to start error

Every morning I come into work and fire up excel and get greeted by a lovely "There is not enough memory to run excel." error. There are no other applications running and it is fixed by a reboot. ...
2
votes
1answer
647 views

Excel validation - can it be used to make sure duplicates are not entered?

I have an excel spreadsheet - is it possible to have validation so that a column cannot contain a value that already exists in the column?
3
votes
3answers
1k views

Alternatives to work with .xlsx files?

I don't have Excel'07 installed on my machine, but I need to work with .xlsx files. Excel'03 has a compatibility pack, but I could only open xslx files, not being able to save or create them. Do you ...
2
votes
2answers
2k views

Convert Excel 4.0 macro to VBA

Is there a tool to convert Excel 4.0 macros to VBA?
3
votes
1answer
782 views

What is the best way to share an Excel macro across multiple machines?

All computers are running Office 2007.
3
votes
1answer
175 views

Links in Excel changed after a crash

A few of my users use Excel spreadsheets that have cells linked to other spread sheats. It is set up so the catering.xslx pints to the inventory,comm2002.xls. I was told that excel will crash and all ...
1
vote
9answers
18k views

How do you split a name to get first name and last name?

I have a column which contains a list of names, I want two other columns to contain functions which extract the first and last name. So far I have this FirstName: =LEFT(D3,FIND(" ",D3)) LastName: ...
4
votes
3answers
8k views

How to synchronize Excel with Google Docs spreadsheet

This feature is not officially suported by Google. Do you know if is there a way or a product that allows to synchronize the changes performed in excel into a google spread sheet? Create file in ...
1
vote
2answers
8k views

Why can't you copy/paste images in excel, but screenshots work?

I'm not sure if this is a global issue with excel, but it's happening on all the computers here (Excel 2002, XP SP2) If you select a cell, and go Ctrl-V when there's a screenshot in the clipboard, ...
6
votes
7answers
14k views

How do you keep Microsoft Excel running at full speed even when it does not have the window focus?

I've noticed that when Excel 2007 (and probably earlier versions) has the window focus, Excel runs at full speed which means that files open fast and long-running VBA macros execute quickly. If the ...
0
votes
1answer
3k views

Simple Merge / Purge with Excel

I have four Excel files that contain email addresses. I need to find out how many unique addresses are in the first three, but not in the fourth. What's the easiest way to do that?
1
vote
1answer
801 views

Excel Word Wrap + disappearing text

Why dooes adding word wrap to a column in Excel cause it to stop showing text on some computers? If I send the file to someone else, they see the text, but on my computer the text does not show uip in ...
1
vote
2answers
1k views

Is there any way of making Excel 2007 do BACKGROUND autorecover saves like MS Word does?

I have a huge Microsoft Excel document - it is currrently about 25Mb in binary format (.xlsb)...the standard Excel format was too large and slow - but is still growing at a steady rate. (It has ...
0
votes
3answers
6k views

My file is locked in Excel 2007, what's going on?

I have a excel 2007 spreadsheet that I'm sharing with some of my coworkers while we work on a project. Recently, when I try to save the file, I get this error: "This file is locked. Try the command ...
1
vote
2answers
100 views

Excel and Pivot, avoiding buying another 3rd part component

I hope someone can help me with this Excel problem, otherwise I'll need to buy another 3rd part control to handle the Pivot problem we've encountered. I know it's somewhat off-topic, but hopefully ...
3
votes
7answers
41k views

Autonumbering a column in Excel

In my first column, I want to autonumber it from 1, 2, 3, 4, ..., x. How do I do that?
2
votes
1answer
2k views

how to swap columns to rows view

I have following two columns of data in excel 2007: a 1 b 2 ... What I need to swap the view to: a b ... 1 2 ... I think there is way to do it in excel 2007. Is this possible?
2
votes
4answers
10k views

Using two conditions with a SUMIF function in Excel 2003

For a given row on Sheet1, I use the SUMIF function to see if the value from the first cell of that row is on a list of historical values in Sheet2. That will basically summarize all the values on my ...
4
votes
6answers
37k views

How to get the Excel header on each print page to be the first row of the table

I need the first row in an Excel spreadsheet to print as the header on all pages.
3
votes
4answers
5k views

Excel formula to display a string of text and numbers

I need one column to show the following text: prxyz,(data1 here),0699,ABCD(data2 here),xxx data1 is in column A and data2 is in column B. the format of data1 needs to be 5 numbers (sometimes ...
1
vote
3answers
17k views

MS.Excel- Is it possible to password protect one or two columns in an excel file?

I have an excel file which would be available on a shared drive. I want the users to be able to access all columns except one or two columns. Except the two columns which are protected all other ...
0
votes
3answers
2k views

Sum Column, but only Filtered Rows

I have a large flat file of a bunch of ungrouped primary key values. I want to filter on a key and populate cell A1 with the value selected from the dropdown list. In the end, I want to see a sum of ...
6
votes
4answers
6k views

How do I get a reference to the last occurrence of a value in an array in Excel?

So if A1:A5 = {3, 3, 4, 4, 5} what function could I put into B1 to get a reference to A4 (the cell containing the last occurrence of 4)?
5
votes
4answers
10k views

Make Excel 2003 Open Spreadsheets in new instances

In Excel 2003, It seems to be putting each spreadsheet I open into the existing Excel application as a new window. this makes it very difficult in a dual monitor set up to put one spreadsheet on each ...
3
votes
4answers
58k views

Excel chart: How to reverse the X axis of time series data

In Excel 2003, I have a time series from a financial report that goes something like this: 2007 2006 2005 Amount 300 200 100 I want to create a graph of the time series that looks ...