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.

learn more… | top users | synonyms (2)

3
votes
2answers
24k views

How can I lock images to a cell in excel 2010?

Ok, so I am using Microsoft Excel 2010 and have a set up currently where I have 2 views expanded and deflated using the Group or +/- function. My problem is that the UI has images on the workbook, too....
1
vote
1answer
2k views

Remove URL Parameter in Excel

I have a URL of the following form: http://www.example.com/page.html?param1=asdf&param2=asdfg&param3=asdfgh I want to extract the value of param2 or 3 from the URL as well as remove that ...
1
vote
2answers
856 views

Why does Excel try to open password-protected URL links itself instead of just giving to the browser?

I have links to secure sites inside Excel spreadsheets (currently 2010, but I'm pretty sure it's the same with Office 2007). When I click on them, instead of just launching the system browser (...
1
vote
1answer
197 views

excel truncating phone number

I have a csv file that contains cells such as "+1.8882789780". When viewed in Excel, it loses the last digit possibly due to excel truncation. Is there a way to either change the setting in Excel to ...
-1
votes
2answers
147 views

Ranking tables from Excel data

Hi all (asking here because this meta question told me to). I have some data in an excel spreadsheet here. It's no more than a table with about five columns. Year Purchased Manufacturer ...
2
votes
1answer
5k views

Word table copy/drag formula like Excel

I am inserting formula into a Word table to get subtotals for rows and columns and a grand total. My problem is, I have got large number of rows and I don't want to enter the formula manually in each ...
1
vote
3answers
440 views

Excel equivilant of java's String.contains(String otherString)

I have a cell that has a fairly archaic String. (It's the mana cost of a Magic: the Gathering spell.) Examples are 3g, 2gg, 3ur, and bg. There are 5 possible letters (g w u b r). I have 5 columns and ...
1
vote
3answers
2k views

What Excel formats are (most) compatible with LibreOffice and Google Docs? [closed]

I use Excel (and occasionally Numbers), but I want to be able to share with users of Google Docs and LibreOffice (and I may want to switch in the future). What's the most compatible format to save my ...
0
votes
2answers
901 views

How can I set the same header/footer for all worksheets, including new ones?

Every google hit for applying the same header says to highlight all sheets and set a header. How can I ensure that new sheets I add also get the same header, without alway
2
votes
2answers
5k views

How to get the list of sheet names of ms-excel?

I have an excel file which has a lot of sheets. How could I get a list of sheet names of ms-excel? (PS: The office is mac version.)
3
votes
1answer
800 views

Is there any tool that let you batch export excel tabs to csv

I have Excel 2010. Found this: Batch XLS to CSV Converter But I actually need to export all excel worksheets as individual CSV files. Not sure if it works that way. Also if I were to use the above ...
1
vote
1answer
78 views

Is there a way through an excel formula to have it where a blank cell and a specific value show 0?

I have a cell that shows =IF(ISBLANK($E12),1,0) I have another that shows =IF($E4="Total:",1,0) Is there a way to make them do the same thing, so if the cell shows 0 or Total: it shows 1, otherwise ...
1
vote
3answers
2k views

Excel - convert days hh:mm:ss to minutes (including negative values)

Given data in the following format (i.e. days hours:minutes:seconds): -4 1:0:0.0 How can I convert this to minutes in Excel? (e.g. 5820 minutes) I currently do text to columns (days column; hh:mm:...
0
votes
2answers
1k views

Excel percent over 100%

I have two cells both of which have this formula in them =IF(ISERROR(100%-E18)," ",ABS(100%-E18)) The sells are named percentage drop and percentage increase, I want it so if the percentage is over ...
10
votes
1answer
4k views

Change Excel day name to other languages

How can I modify Excel List to get day names returned by TEXT(TODAY()) e.g. in other languages instead of English ?
4
votes
1answer
886 views

Stop Excel from changing file contents upon open

I use synchronization a lot on my machines. Excel changes the modification date right at the very moment it opens the file. Then, it changes the contents of the file (I guess to update the statistics ...
0
votes
1answer
794 views

-Inf is converted into #NAME?

I want to display the string "-Inf" in a cell in Excel (Microsoft Office Standard 2010). However, the cell displays the string "#NAME?" instead. How can I alleviate this? I have set the type of all ...
2
votes
1answer
1k views

How to hide rows in Excel if all of the columns are not blank?

I have an Excel spreadsheet with 10 columns. The cells within the first 2 columns contain text and the remaining 8 cells contain 'blank', 0 or 1. How can I hide all rows where the 8 columns do not ...
-1
votes
3answers
2k views

How to “highlight a row” in excel

Hi i know that "SHIFT + spacebar" 'highlights' an excel row. But what I want to do is actually to 'highlight' it such that the background is yellow. Is there a keyboard shortcut for that?
2
votes
1answer
3k views

Using Mac Excel, how can I delete partial duplicate rows?

I'm running Mac Office 2011 under Lion. I have a sheet of many thousands of rows of data, with a good 40 or 50 columns. One column is email address. If any two rows have a duplicate email address, ...
2
votes
3answers
19k views

How to highlight data points in a scatter chart in excel?

I have a scatter chart with a series of numbers in Excel. Most of the time, those numbers are high (>1000). I would like to display the scatter chart with those numbers in the default color, but if ...
3
votes
2answers
3k views

Adding a function to customized status bar in Excel

Is there a way to add a function to the customized status bar in Excel 2007? I want to include a subtract method next to functions such as SUM, COUNT, AVERAGE, etc.
3
votes
1answer
2k views

Filter multiple columns in Excel

I have a sheet with a bunch of data. I know it is easy to filter rows so that only data in a given column shows. I can filter by surname only for example, that's easy. Is there a way to filter with ...
0
votes
1answer
449 views

Display date serial number using TEXT in IF

I am using an IF function to insert a string into a cell if the cell specified is #N/A, the function works if I use the following =IF(AS2="#N/A","",CONCATENATE("insert in tempTable values('",AQ2,"','"...
9
votes
4answers
13k views

How do I export only visible cells from Excel to CSV?

I am running Excel 2010. At the top of my spreadsheet I have about 10 hidden rows. When I export to CSV, how do I export only visible cells?
1
vote
1answer
290 views

How to copy a row conditionally?

I've searched for a similar question here, but haven't been able to find something that answers my issue. I'm a mediocre user of Excel 2010 with no experience in macro's. I have a dataset where each ...
2
votes
2answers
757 views

Skip rows in excel

I'm doing a budgeting spreadsheet in excel. Along the top, the columns are headed for each budget item I need to account for. The rows are each labelled with dates on a daily basis. At the end of each ...
11
votes
7answers
63k views

How do I save an excel spreadsheet as a semi-colon separated values file?

I am running excel and would like to export my file as a .scsv (semi-colon separated values) sheet instead of a .csv. Is there any way to do this? ps. I can't do a .csv and search and replace ...
1
vote
1answer
147 views

Is there an excel formula that will complete this command?

I am trying to complete this command (this would be a cell value on sheet 2): A1 (sheet 1) if K(sheet 1) is current date Basically I want cells on sheet 2 to contain data from sheet one, only if Col ...
1
vote
1answer
689 views

Are there any Spreadsheet apps that are as easy and powerful to use as Vim? [closed]

I'd like to use a spreadsheet that lets me move around cells like I do in Vim. As well, the more commands that are attributed to keyboard shortcuts, the better. Particularly stuff like making Text-to-...
13
votes
5answers
121k views

Excel: If statement with #N/A

I have over 6000 records and half of them are formulas that are missing a variable so they result in #N/A on the spreadsheet, what i want to do is if the cell is #N/A then leave the cell blank, ...
2
votes
3answers
25k views

Add drop down list / combo box into excel cell

How would I add a drop down list (or combo box) into a cell on Excel 2010?
2
votes
0answers
765 views

error while Generating “xlsx” file using carlosag.excelxmlwriter dll

I am using carlosag.excelxmlwriter dll to build Excel files. When trying to build xlsx files, the following error pops up: Excel can not open the file "test.xlsx" because the file format or file ...
3
votes
2answers
2k views

EXCEL: Want to incorporate two charts in one line graph (with averages)

I'm really new to Excel...hoping someone could give me some advice. I currently have a table with 2 columns ("Date" and "Score"). I'm trying to keep track of something on a scale of 1-10 on a daily ...
1
vote
1answer
299 views

Excel Date Formula with a condition

I have 3 fields in excel as follows: Cell A1=2012 A2=12 A3=15 which contains year, month & date value respectively. And I want to make a date string out of it. I know it's very easy to achieve ...
0
votes
1answer
50 views

Excel 2007 - Cell selection

Excel 2007 Workbook with 19 linked sheet that derive a Long Term Finanacial Plan - When cell selected, instead of one square being highlighted several squares are. Occurs when using a mouse. Fixed if ...
9
votes
6answers
93k views

Excel: Delete row if cell in certain column is blank?

I am a complete newbie to Excel so please excuse me if this is something easy to do. I have looked through a lot of options but couldn't find what I needed. Basically, I want to delete all of the ...
1
vote
1answer
64 views

Nested IF's in Excel

I have two columns with the following possibilities (0 for first column, and then 0 or 1 for second column; or a string for first column, and a 0 or 1 for second column). name,flag 0,0 david,0 0,1 ...
3
votes
4answers
7k views

Excel Smart Find and Replace only specific characters

I want to change INT to INTERNATIONAL and NA to NATIONAL ASSEMBLY in whole excel workbook through an excel Macro or Find and Replace dialogue box. But when I run the macro or change it through Find ...
0
votes
2answers
857 views

Excel - How do I highlight a cell if its address is stored in a column?

I have a worksheet with a list of 'Special Cells' in a column, like 'C352', 'E11', etc. How do I write a conditional formatting rule that looks through the column on the other worksheet, and if that ...
1
vote
3answers
9k views

How can I get the Cell Reference of a Named Range in Excel?

I solved the issue, but I'm wondering if there's a better way to do this. What I have is a column of some named ranges ("NAME"), and I want a formula to the right that looks up the named range and ...
2
votes
1answer
137 views

Excel 2007 hyperlinks to other workbooks not redirecting properly

Links within the workbook seem solid. Links to other workbooks on the network get replaced with C-drive home directory addresses.
2
votes
2answers
2k views

Using Excel Built-in Functions in VBA

Functions like MIN(), MAX(), SMALL().. It is too bothersome for me to write codes for functions above(and much more) and do the trick. Any help?
1
vote
1answer
2k views

Open Excel files from Hyperlink in new window

Much like this question but I want to be able to insert a Hyperlink into one sheet that opens another sheet in a new window. P.S. Using Excel 2007
0
votes
2answers
5k views

In excel, how can I change the background colour if two cells are the same?

For example, if A1 and A2 are both positive, then I want A3 to be green. Also, if A1 and A2 are both negative, then I want A3 to be green as well. Is there a way to do this? I'm using excel 2010
1
vote
1answer
223 views

IF/THEN statement for text

In my Excel spreadsheet:- In Cells A1 and down I have cities listed. For instance Cell A1 has: "Daytona Beach, FL" In Cells B1 and down I have some generic information with the word CITY in it. For ...
0
votes
1answer
401 views

Setting Axis.MinimumScale to a small decimal number causes Automation Error

I have this piece of VBA code With sheet1.ChartObjects("Chart 2").Chart.Axes(xlValue) .MinimumScale = ChartMinY .MaximumScaleIsAuto = True End With When execution comes to ....
3
votes
3answers
3k views

I want files to open in. Excel not excel viewer

I don't understand why spreadsheets I receive open in viewer. The only way I get them I excel is if I open excel then open the desired file. Double clicking on the file in outlook or after saving ...
2
votes
2answers
9k views

How can I scrape specific data from a website

I'm trying to scrape data from a website for research. The urls are nicely organized in an example.com/x format, with x as an ascending number and all of the pages are structured in the same way. I ...
4
votes
1answer
900 views

How do I set the default file save location of an Office document to be the same folder as the template's folder?

I have a series of Microsoft Office 2010 templates (Excel, PowerPoint and Word) spread through a pre-defined folder hierarchy. I need to make sure that when a new document is created from one of ...