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)

0
votes
3answers
30k views

IE won't open Excel files

I'm visiting a web site that is opening an Excel file in a new window. From one PC (Windows XP, IE8, Office 2003), everything works. By works I mean that the new window appears, and I'm asked to ...
0
votes
1answer
3k views

How to lookup an IP address in an Excel spreadsheet?

I'm working with a decent sized spreadsheet of domains and server names. Another user of the spreadsheet needs the IP address for each of the DNS entries on the worksheet. Instead of manually adding ...
1
vote
3answers
242 views

How to stop Excel 2003 from loading a Gazillion files

One of my soon-to-be-ex-friends got an Excel file from another friend of his and decided to click on it. It started opening all kinds of files from within Excel. Over 200 and still counting when he ...
0
votes
1answer
1k views

Office 2007 Compatibility Pack and .XLSX Issues

I've installed the Microsoft Office 2007 Compatibility Pack and Service Pack 2 on client machines. In one case the user reports he can open .docx files successfully but is unable to open .xlsx files. ...
0
votes
3answers
1k views

automatic hyperlink to worksheets in excel 2007

I have a worksheet called 'summary' this contains a list of english counties, and I then have a seperate worksheet for each county. What I want to do is automatically make my list of counties on the ...
0
votes
2answers
368 views

Excel regression output - funky p-value

Anybody know what it means when the p-value for X in an Excel regression output isn't something like ".0263," but instead is "3.9081E-86"? By the way, this is for one independent and one dependent ...
20
votes
5answers
166k views

How to write multi lines in one Excel cell?

I want to write multi-lines in one MS Excel cell. But whenever I press the Enter key, the cell editing ends and the cursor moves to next cell. How can I avoid this?
5
votes
1answer
2k views

Excel: Is there a registry setting to suppress the warning messages when saving spreadsheets in CSV format?

I work with many CSV files, and am constantly annoyed by the Excel dialog that pops up when I try to save a file: "[your spreadsheet] may contain features that are not compatible with CSV (Comma ...
1
vote
1answer
398 views

Creating 1 spreadsheet per row with MS Project

I'd like to create a script that creates a set of spreadsheets, 1 for each selected row in an MS project schedule. This is more complex that what I've seen the "export function" do, since the export ...
2
votes
1answer
5k views

Enter “return” in excel?

It took me a while to find out how to do it on Windows. Now, how do I do the same in Mac? What's the equivalent for Alt+Enter for Excel on Mac?
0
votes
1answer
907 views

Product sales chart in Excel, from data in Access

I have a table in an Excel 2007 worksheet containing details of orders (note: I have manually changed the details to be fake on everything) I want to count the number of products ordered for a ...
0
votes
1answer
249 views

How to plot Excel graph of multiple series of data using smooth lines

Long time reader, first time questioner. I'm wondering how I'd use the following Excel cell data: http://screencast.com/t/ZjNkODQ3O Into a graph which looks like: http://screencast.com/t/MTVhYTY1YTMt ...
0
votes
1answer
477 views

Is this way of using Excel 2007 Pivot table for BI scalable?

Background: We need to consolidate sales data across the country to do analysis Our Internet connection/IT expertise/IT investment is not quite strong, therefore full BI solution is out of question ...
0
votes
5answers
4k views

I have a spreadsheet were lots of cells have the character ' in the first position of each value, how to remove it?

Hi want to format all of the values in a column to be a phone number, but the first character in many cells is ' This prevents the cells from being recognized as a number. I can't do a search ...
4
votes
3answers
5k views

Making Excel formulas only evaluate once

Is there any way to embed the result of a formula evaluation in a cell, such that the evaluation only happens once? For example: If I put =TODAY() formula in a cell today, if I open the spreadsheet ...
0
votes
1answer
219 views

How to make add-on visible on toolbar by script or batch process?

I have an add-on for Excel 2003. I tried to use MSDN's .VBS script to make it installed, see my previous post question. It seems working as add-on, but it does not displayed on toolbar when it is ...
0
votes
2answers
3k views

What is lookup tables in excel?

I have the below entry when I go to the Insert > Name > Define name ='Lookup Tables'!$I$29:$I$65 What does it mean?
0
votes
3answers
11k views

Tool to automatically combine many large pivot table in many large Excel sheet?

We have several Excel files that contains large pivot data table with the same structure For example File A Pivot table (Field A, B, C) File B Pivot table (Field A, B, C) We want to combine them ...
2
votes
2answers
5k views

Excel formula displays formula rather than result

I am copying and pasting a formula in excel and instead of showing the value it is just displaying the formula. (the formula is ='G:\Corporate[NewOrder.xls]Sheet1'!Q21 ). Is there some setting that I ...
8
votes
4answers
25k views

Select each nth row in Excel

I have an Excel spreadsheet with thousands of rows. I want to select every 7th row from that spreadsheet. (By "select," I mean delete all of the other rows, or copy the selected rows into a new ...
3
votes
2answers
11k views

Split Excel table over multiple PowerPoint slides

I have a table in Excel which is too long for one PowerPoint slide. So I would like to split it over 2 or 3 slides, but have the header on each of the slides. What is the easiest way to accomplish ...
0
votes
1answer
2k views

Print multiple sheets with different orientations

I have a multisheet Excel Spreadsheet. Some pages are setup as Portrait others are setup as Landscape. Is there a way to define which pages should print as Portrait or Landscape, or is it an all one ...
0
votes
2answers
27k views

Excel opens file as read only; won't save after unflagging the file on disk

I open a file that's read only. I change some stuff. When saving, Excel whines that it's read only. I uncheck the read-only attribute. However, the readable attribute does not propogate upwards to ...
2
votes
1answer
3k views

Excel Chart X Axis Values

I'm trying to create a line chart in Excel with the following values from my sheet: (0,100) (1,90) (2,80) (4,70) (8,60) (16,50) The problem I can't work around is that I want the 0, 1, 2, 4, 8, 16 ...
3
votes
1answer
3k views

Is there any way to suppress the Excel 2007 warning “in a different format than specified by the file extension”?

We have an application that exports data using the older Office XP/2003 XML Spreadsheet format. These files are saved with a .xls extension so that they can be launched directly, without having to ...
7
votes
1answer
4k views

Excel automatic hyperlinks

After years of not wanting Word and Excel to automatically turn things into hyperlinks, the one time I want them to they refuse. I have a list of strings in Excel which I am concatenating with a ...
7
votes
3answers
8k views

Saving filtered results from an Excel workbook to a CSV file

I have an Excel workbook with a lot of rows in it. I filter it using the values of one column and then I want to save the filtered results to a CSV file. When I do "Save as..." I get all the rows. I ...
21
votes
9answers
90k views

Excel displays ### for long text - what's wrong?

We've got an excel sheet with a pretty long text in one cell. Instead of line breaks (as set in the cell format), we get a long line of ####s. We can go back and forth by deleting and adding chars at ...
0
votes
1answer
580 views

How do I prevent Excel 2007 from opening hidden workbooks, so the X button exits Excel completely?

I've been frustrated recently because Excel 2007 no longer exits when I click the upper-right X button. Instead, it simply closes the current workbook. I've found a partial answer here: the behavior ...
2
votes
3answers
35k views

How to set Function “formula” for whole column in Excel 2007?

I want to set "Formula" to all cells in certain column whatever the number of rows was. But i don't want to set this function to first cell "Header" of this column. How do i make it ?.
3
votes
1answer
5k views

Excel: why doesn't “File-> Save As” remember the last directory that you saved a file in

i have to save about 1000 different csv files and every time i click file save as, it goes to some default directory. is there anyway it can default to remember the directory that i saved the last ...
2
votes
2answers
5k views

What is an excel formula that will return me the last row number of a cell within a range that contains specific data?

I have a spreadsheet that will default with values of "No". Over time, these values will be changed to "Yes". I need a formula (no VB, please, VB is useless to me) that will get me the row number of ...
3
votes
7answers
14k views

Excel file suddenly 35MB?

What could cause a 945KB Excel file to grow to 35MB without any warnings? Tips: There are table formattings that converted ranges to Tables and I converted them back to Range. Can it be that? ...
6
votes
3answers
6k views

xlsx files are being interpreted as zip files on download, why?

Background: For some reason, whenever a user tries to open an xslx (excel 2007) file from our intranet using MSIE, the file download dialog interprets it as a "zip" file. Admittedly, xslx files ...
0
votes
1answer
2k views

How to dynamically highlight the minimum value in Excel or OpenOffice.org Calc?

I am using Microsoft spreadsheet to record the numeric values in columns. I would like to compute the minimum of the row and want to highlight it when the cursor moves to next row. Could you kindly ...
9
votes
10answers
35k views

Multi-row headers and excel 2007 sort/filtering

I have a spreadsheet which uses 2 rows for header information. Filtering implicitly is assuming only 1 row of header information. Sorting has a header row checkbox but that only toggles treating the ...
-1
votes
1answer
170 views

Excel, deleted data recovery

How do I make sure that in Excel, if I delete some sensitive data and send the file around this is not recoverable?
0
votes
1answer
112 views

excel list of values selections to be reduced as you type

Hi all what i want is to be able to: i have created a cell with a list of values available for selection (this is ok and can do ok) when i am selecting a value in the above list i would like the ...
1
vote
4answers
2k views

SUM condition on one set of columns where another includes certain values

I have the following data in Excel where I want a formula that will give me the sum of all of the total rows: A B australia 10 australia total ...
2
votes
1answer
1k views

Why does my regular expressions invoke error '5018' in my VBA script in Excel

I just wrote my first VBA script for Excel because I have to write many "*.txt" files from a folder into an excel spreadsheet. But when I run this script, I get the error '5018'. It is invoked by the ...
4
votes
1answer
231 views

Is it Possible to not copy all 65,537 cells when copying a column in Open Office

I'm using Open Office 3.01 on OS X. When I select an entire column of data by clicking its header, and the copy that to the clipboard, Open Office appears to copy all 65,537 cells to the clipboard. ...
0
votes
3answers
451 views

How to create label on chart containing contents from a cell on another sheet?

Simple problem. I have a chart in Excel and some text data on a sheet. I want to create labels on the chart that reference text on another sheet. I want to be able to update the text and have the ...
1
vote
2answers
3k views

Date selector popup in Excel

I'd like to setup an entire column, so that it will only contain dates, and I won't have to manully enter the date string. Instead, I'd like a click on the cell to pop up a calender selector. How can ...
4
votes
3answers
20k views

Fixing the first row as sortable title in Excel 2007

I know this is super easy, I just couldn't find it. I'd like the first row in an excel document to be the "title" field. I want that: Whenever I scroll down, this row will remain fixed I can sort ...
6
votes
2answers
16k views

Setting up a column of “enum”-fields in Excel

I'd like to setup a column in excel with several fixed possible values (like 'in-progress', 'done', 'canceled'). I'd like to set it up so the only possible values in these column are from the fixed ...
0
votes
1answer
5k views

How to install Excel 2003 add-on (*.xla)

I need to create something, bat scripts(?), to install an add-on for Excel 2003 so that the end user will not required to manually install add-on from Excel's manual Tool->Addin... then browse. For ...
5
votes
1answer
2k views

Excel, drop down lists

When I created custom drop down lists in excel, my excel sheets don't trim down to a smaller list when I start typing in the drop down list cell. For example if my drop down list is for USA States ...
6
votes
2answers
12k views

Remove password from an Excel Document

I'm providing internal support and one of our users has managed to put a password on an excel file by accident, I've done the proper checks to make sure that the user should have access to the ...
0
votes
3answers
2k 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 ...
0
votes
1answer
52 views

Script for preriodic emailing to a list of addresses from an Excel/Access DB?

I'm looking for a program/script, better if it's OpenSource/Free, that can periodically send an email to a list of addresses that are in an Excel File or Access DB. I know I could hack something ...