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)

6
votes
4answers
30k views

Downsides to Microsoft Excel 2007 XLSB binary format? [closed]

Excel 2007/2010 offers an option to save my files in an "Excel Binary Workbook" format that seems to be smaller (50% of the size in some cases) and load more quickly. Is there a downside to this ...
6
votes
3answers
30k views

Can I make an Excel VBA macro available to all workbooks?

Is it possible to write a VBA script in one workbook, and use it in other workbooks in the machine? I guess I'm looking for a way to write a macro package. EDIT Following the instruction in the link ...
6
votes
2answers
15k views

How can I create a properly aligned curly brace that spans multiple rows or columns in Excel?

I would like to group a couple of columns or rows together and add a note to them. When I try that with normal letter-resizing, it gets ugly, misaligned to the rows, too bold and the centered text ...
6
votes
7answers
56k views

Map one column to x axis second to y axis in excel chart

I'm getting my ass kicked trying to plot simple data into a simple chart in excel (2010 beta). My data is a very simple one: Value Year ----- ---- 1 1900 5 1902 3 1912 ...
6
votes
1answer
1k views

Formula does not show superscript character

I have a formula which I want to show a result which includes a superscript character, but I cannot get said character as superscript. Normally I would just enter text into a cell and I can select ...
6
votes
2answers
625 views

OpenOffice Calc: reduce file size when saving as Excel

I'm working on a spreadsheet together with another person, sending new versions forth and back by email. It contains nothing fancy. While he uses Windows I'm on Ubuntu 12.04.4 LTS. The first version ...
6
votes
6answers
37k views

How to open xlsx files with Excel 2013 by default on windows 8?

My xslx files open systematically with Excel 2010 when I'd like them to use Excel 2013. Everytime I right click select open with point to C:\Program Files\Microsoft Office ...
6
votes
4answers
25k views

How do I merge two tables in Excel that have identical columns?

In Excel, I have a spreadsheet that pulls data from a SQL Database into a table and then generates a report based on that data. Unfortunately, the data in this SQL database is incomplete and I want to ...
6
votes
2answers
3k views

How to paste table from MS Excel to Wolfram Mathematica?

When I am pasting a region from MS Excel, which contains multiple numbers, to Mathematica, I am getting just a long plain sequence of digits, i.e. one integer number in Mathematica. How to have a ...
6
votes
5answers
1k views

Excel Formula to Calculate Duration of Time Based on a String of Text Such As 9:00am — 12:30pm

I'm trying to develop an Excel formula that would calculate the actual time duration for a string of a time range of the following format: 1:00am – 3:00am According to this article it seems it should ...
6
votes
3answers
14k views

How to batch convert .csv to .xls/xlsx

I am looking for a way to quickly convert a directory of .csv files into the .xls or .xlsx format (would be nice if I could do either/or). Is there an easy way to do this or do I need to install a ...
6
votes
1answer
4k views

Shortcut to accept suggested formula in Excel

I'm working with a lot of formulas in Excel 2007 and I would like to know what shortcut key you need to press to accept the suggested formula. When I type in =DEG the first suggested formula is ...
6
votes
2answers
13k 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 ...
6
votes
1answer
6k views

How to conditionally create a hyperlink based on value of a cell

ColA Col B ColC Project A A.pdf A.pdf Project B No Link I have a list of project records. One column (e.g., B) ...
6
votes
5answers
8k views

Copy/paste filtered column in Excel - error message

In short, I have filtered a worksheet by column A, and I want to copy/paste from column B to column C. Obviously I don't wish to copy/paste values from rows that were filtered-out here. The above ...
6
votes
3answers
9k views

How to Label / Tag Items in a Spreadsheet

I'm a novice at spreadsheets, so I hope you'll forgive me if I'm asking a super obvious question. Is it possible to use tags in Excel/Google Spreadsheet? I'm creating a spreadsheet to log all the ...
6
votes
1answer
3k views

break up a large CSV file

I have a large CSV file (about 6,000 rows) that I want to break up into smaller CSV files (about 100 rows each). Is there an easy way to do that?
6
votes
2answers
16k views

Using find() in Excel to remove text from string

I'm using find to remove some of the test string in lookup cell value For instance I look-up the following in cell A2 Application: sales_rep_support and use find =RIGHT(a2,FIND(" ",a2)+4) to change ...
6
votes
1answer
14k views

Can I use an excel formula to extract the link location of a hyperlink in a cell?

I have a spreadsheet with a large number of cells containing hyperlinks with display text different than the hyperlink location ie: cell location: A1 display text = "Site Info" hyperlink location ...
6
votes
2answers
22k views

Fit column width to text shortcut?

I know that I can double-click a column header with my mouse, but is there a keyboard shortcut to fit a column to the text width?
6
votes
4answers
7k 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)?
6
votes
1answer
814 views

In Excel's chart wizard, how can I use the arrow keys?

This has always bugged me: In the excel chart wizard (and many other places), when you are editing ranges to be used for data (e.g., the "Values" or "Name" fields), if I try to use the arrow keys to ...
6
votes
3answers
15k views

Excel chart on one column of date/times

I have a list of date/timestamps, and I would like to plot these to a chart in Excel. What I'm looking for is a chart that shows "events per hour" or something similar. Can this be done easily if I ...
6
votes
3answers
18k views

Why is Excel removing leading leading zeros when displaying CSV data?

I have a CSV text file with the following content: "Col1","Col2" "01",A "2",B "10", C When I open it up with Excel, it displays as shown here: Note that Cell 2A attempts to display "01" as a ...
6
votes
3answers
7k views

Is there Something like a Dark Background Excel Theme?

Is there an easy way to apply a dark theme to my excel windows: black or gray background on all cells, light text. Ideally, this would be just a theme/view that could be applied, rather than ...
6
votes
3answers
6k views

Why does pasting into an unprotected cell in Excel protect it?

While researching the answer to this question, I stumbled across a rather odd behavior in Excel related to unprotected cells in protected worksheets. To see what I mean, create a new workbook, ...
6
votes
4answers
57k views

How to change x-axis min/max of Column chart in Excel?

Here i have a column chart of binomial distribution, showing how many times you can expect to roll a six in 235 dice rolls: Note: You could also call it a binomial mass distribution for p=1/6, ...
6
votes
5answers
35k views

How do you specify a specific worksheet to open for a MS Excel workbook using a hyperlink?

I have a MS Excel workbook with several worksheets. Users are directed to this spreadsheet using a hyperlink in an e-mail. Is there any way of expressing the hyperlink for getting the ...
6
votes
3answers
2k views

Excel Formula to Calculate the Third Point in a Triangle

I need an Excel formula that can help me find the third point in a triangle, given most other information. This is not homework, meaning I do not need to do this just once. I need a consistent way to ...
6
votes
4answers
27k views

How can I set a keyboard shortcut to switch between Excel tabs?

I find the Ctrl+ PgDn/PgUpnot good enough. When I have a lot of tabs it's very annoying to get to the right tab, or move it and change the order, which is sometimes important. I need Excel to switch ...
6
votes
4answers
14k views

How to insert empty rows in Excel 2013 when I have copied rows in my clipboard?

This seems like something which should be painfully simple to do but I can't figure it out. So with an empty clipboard I can right click on a row header and say insert row, no problem, it inserts a ...
6
votes
2answers
4k views

How to view large spreadsheet in Windows

What would you recommend to a non-technical Windows user for viewing (no need to edit) large spreadsheets (200MB - 5GB). Format is CSV and I am told Excel chokes.
6
votes
3answers
26k views

How to refresh data in shared Excel 2010 workbook

I have a Excel 2010 workbook that is shared by other users who periodically update various cells. Is there a shortcut key, like F5 with most web browsers, that updates the document with any changes ...
6
votes
4answers
55k views

How to combine values from multiple rows into a single row in Excel?

I have a data dump in Excel that consists of annual customer data for two different values. The data was provided with a separate row for value for every year and customer. I.e. it looks like this: ...
6
votes
2answers
3k views

Importing CSV into Excel with commas in quoted fields

I have a CSV file that contains a text field that can have commas in it. When importing it into Excel, it's picking up these commas as field separators. I have the field in quotes, and I've tried ...
6
votes
3answers
3k views

Excel: Update a value in a named range

I've got some cells in an Excel doc populated from a named range (data/validation/list source=MyNamedRange): Here, the A1:A3 range is named Foobar B5:B6 is under data validation with it's source ...
6
votes
9answers
20k views

Why is Excel 2010/2013 taking 10 seconds open any file?

I have a fast Windows 7 PC with two SSDs and 16GB of RAM, so I'm used to programs loading very fast. But recently, for no reason I can figure out, Excel has started taking way too long to open Excel ...
6
votes
2answers
4k views

Excel 2013 Help Offline View

Is there a way to enable offline viewing of Excel 2013's help window like that of 2010's? Every time I hit the F1 button, Excel wants to connect to the internet to help me! Thank you! Edit: Is ...
6
votes
2answers
23k views

How to disable the annoying compatibility warnings in Excel?

Every time I edit a CVS or 2003-2007 Excel file it gives a warning that it will be saved in compatibility mode. I have this habit of saving every other minute via Ctrl+S and the window keeps popping ...
6
votes
4answers
30k views

Microsoft Excel returns the error 'Document not saved' after generating a 2GB temporary file

Summary Saving an Excel workbook sometimes runs very slowly; A huge temp file is created; You get a 'Document not saved' error; Your current Excel session cannot save the file, no matter what you ...
6
votes
6answers
18k views

Click to select row to end of data in Excel?

In Excel, you can select an entire row by clicking its number at the left edge of the window. But doing so selects the entire row all the way to infinity. If you apply a fill color to a row selected ...
6
votes
6answers
26k views

When embedding an Excel chart on a PowerPoint slide, why does the text look awful?

I have a recurring problem with Excel 2003/PowerPoint 2003, where I have a nice-looking chart in Excel and try to embed it on a PowerPoint slide. Quite often, the text in the chart (labels, axis ...
6
votes
2answers
105 views

How do I stop excel from turning numbers and dates to # in short columns

Question I have an excel document that is being used for reports. For readability I currently have all the columns fairly narrow and am using cell overflow a lot visually. I want excel to recognize ...
6
votes
2answers
5k views

How to change the delimiter when you copy from Excel and paste to notepad

I would like to copy cells from Excel, and paste it to notepad with comma as delimiter, in stead of tab(which it is). Is there any way to do this without doing a replace in Notepad or saving the ...
6
votes
1answer
27k views

Color Cell Based On Text Value

An Excel column contains a text value representing the category of that row. Is there a way to format all the cells having a distinct value a unique color without manually creating a conditional ...
6
votes
4answers
7k views

Excel insists on formatting HTML

I need to copy around 15,000 rows of data from an MS SQL query to an Excel 2007 spreadsheet. Some of the cells contain HTML as plain text, and most of these include HTML tables. I want the HTML to ...
6
votes
2answers
598 views

How to tell Excel not to hide selection when it becomes inactive?

Excel has an annoying habit of making the current selection invisible when it becomes inactive - including the "focused cell" rectangle. When I try to process a spreadsheet in a certain way I may put ...
6
votes
3answers
1k views

Where is the PivotViewer collections excel addin gone and many other resources?

I am trying to get something working with the Silverlight PivotViewer control, and I am having a hard time getting any of the referenced resources (on the web). Most of the links are broken or gone. ...
6
votes
0answers
128 views

Keyboard shortcuts for selecting range using inputbox in Excel

I am using Excel 2010 and I have a problem with using keyboard shortcuts for choosing ranges in an Inputbox. I am using a standard Application.Inputbox with type:=8. The code prompts the user to ...
6
votes
0answers
9k views

How can I force Excel 2007 on Windows 7 to always open another instance of the application? [duplicate]

I want to be able to compare to large spreadsheets side by side... Since you can not natively expand to all monitors I would like to have the two documents open in two instances. These files are ...