# Questions tagged [microsoft-excel]

A spreadsheet application by Microsoft. Use this tag along with [vba] if your question involves programming Excel in VBA, and with [worksheet-function] if it involves an Excel formula or worksheet function.

20,375
questions

**2**

votes

**3**answers

16k views

### Google Chrome opening Excel spreadsheet annoyance

When I go online with Google Chrome and select to "open" an Excel spreadsheet from a specific web site, it opens the file in Excel 2003. The annoyance is that even though I did not choose to "save" ...

**11**

votes

**2**answers

49k 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 ...

**2**

votes

**2**answers

2k views

### In-cell Validation Drop-down list - widen

I have quite a few cells with Data Validation with options in the list that are long strings. Short of widening the column, is there any way to widen the drop-down list so that the user can see the ...

**1**

vote

**4**answers

13k views

### How to filter an Excel column for entries matching a master list

The general question entails sorting a large Excel 2007 list to find entries that match smaller subset list.
I have a couple of ideas on how to approach the problem, but I lack the technical ...

**0**

votes

**1**answer

3k views

### merging two excel files into one

I have two files with multiple worksheets in each that I would like to combine into one file. I want the formulas to remain but without the association to the old file.

**27**

votes

**4**answers

42k views

### Open Multiple Instances of Excel without PERSONAL.xlsb Lock Message

Whenever I open more than I instance of Excel, I get the following message:
PERSONAL.xlsb is locked for editing
Q: How can I disable or hide this message?
Alternatively, if someone could ...

**1**

vote

**2**answers

3k views

### Comparing two Excel Sheets in same XLS Document? [duplicate]

Possible Duplicate:
Compare between Excel worksheets
The title actually explains it all.
I would like to be able to compare two Excel Sheets in one Excel document.
Comparing two different files ...

**23**

votes

**8**answers

444k views

### How can I get a cell in Excel to automatically adjust its height to fit the wrapped text contents? [duplicate]

I have a cell with wrapped text content in Excel and I want to format the cell so that its height will adjust to fit the content which can span over several lines. How can I achieve this behavior?

**1**

vote

**1**answer

4k views

### Adding a custom format to the format drop down menu in Excel 2007

How do I add a custom format to the format drop down menu in Excel 2007? On the Home tab there is a "Number" section that has a format drop down box. Is there a way to customize the formats in that ...

**37**

votes

**3**answers

173k views

### Reverse order of rows in Excel

Is there any simple way to reverse the order of some rows in Excel? I'd rather hoped that there might be a suitable option in Paste Special, as there is for Transpose, but apparently not.

**1**

vote

**3**answers

1k views

### Excel select column

In excel, if I want to perform a function with the column to the left, how do I go about this?

**0**

votes

**1**answer

8k views

### Excel - creating a master template?

Sorry for my second Excel question in as many days! Almost there now though :)
I've created a template for an invoice for my mum... is there anyway I can sort of lock the file, and create sub ...

**10**

votes

**4**answers

35k views

### Specifying delimiter for Excel 2007 export

I'm trying to save an Excel 2007 file as a pipe-delimited text file but in the Save As list, I see only tab-delimited and csv options. How do I go about specifying the delimiter, which as I recall ...

**4**

votes

**9**answers

71k views

### Huge Excel spreadsheet taking too long to update links or calculate formulae

I have an Excel spreadsheet with 5000 rows and columns till AY (size 12MB). Except for the first six columns, the rest contain either vlookups or other formulae. All the vlookups are in a separate ...

**4**

votes

**4**answers

3k views

### Get Excel 2007 to close completely after creating a macro in the personal macro workbook

I created a few macros in Excel 2007 and I saved them in the personal macro workbook.
Since then, I've deleted the macros. Note: You have to unhide the workbook, delete the macro and then hide it ...

**2**

votes

**7**answers

6k 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?

**17**

votes

**3**answers

82k 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 numbers,...

**2**

votes

**3**answers

544 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:
=10*...

**1**

vote

**3**answers

905 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

**4**answers

24k 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

**2**answers

561 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 ...

**5**

votes

**4**answers

9k views

### Excel, sort multiple columns

How can I sort multiple columns in Excel? So first sort culumn B and then A, D

**4**

votes

**4**answers

2k 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

**2**answers

52k 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

**4**answers

12k 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 ...

**16**

votes

**11**answers

319k 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.

**107**

votes

**14**answers

184k 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

**3**answers

3k 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 periods,...

**3**

votes

**4**answers

14k 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

**2**answers

218 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 + ←/→),...

**2**

votes

**1**answer

3k 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

**5**answers

738 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 add ...

**3**

votes

**1**answer

257 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 ...

**3**

votes

**8**answers

15k 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 ...

**4**

votes

**3**answers

10k 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' ...

**2**

votes

**3**answers

5k views

### Fix a (Today) Date in Excel

I have a file with a VB macro that puts a TODAY() formula in a cell when I click a button. The formula is volatile and updates every time the sheet is calculated. Instead, I would like to lock the ...

**7**

votes

**5**answers

6k 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 ...

**3**

votes

**3**answers

48k 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 ...

**4**

votes

**1**answer

8k 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 ...

**1**

vote

**3**answers

1k 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.
It'...

**2**

votes

**1**answer

801 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?

**5**

votes

**3**answers

3k 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 ...

**3**

votes

**2**answers

3k views

**4**

votes

**1**answer

880 views

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

All computers are running Office 2007.

**4**

votes

**1**answer

192 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

**9**answers

23k 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

**2**answers

11k 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 ...

**4**

votes

**2**answers

37k 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, ...

**10**

votes

**7**answers

32k 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

**1**answer

6k 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?