0
votes
1answer
37 views

Excel chart axis with personal label instead of number

I'm a simpleton with excel but writing a research dissertation. Much charting involved... My y axis has values 0-6 but each number represents a patient response (for example never, very rarely, ...
0
votes
3answers
55 views

Excel - take two csv files and map them

I have two csv files. 1 has a list of emails, another has a longer list of emails with first names, last names, address, etc. What I am looking to do is take both of these files and map the emails ...
0
votes
0answers
445 views

How to change default font size in Microsoft Excel for Mac?

I'm using Microsoft Excel for Mac 2011 and by default, a new spreadsheet has a font size of 12 for cells. On a 4k screen resolution, font size 12 is a bit small, so I have selected the whole ...
0
votes
0answers
52 views

Mac error opening hyperlinks from Windows Excel workbook

I have an Excel spreadsheet that has many hyperlinks in cells to external documents. All documents and the Excel file are in one folder. This folder is uploaded to Dropbox using a Windows 7 platform. ...
0
votes
1answer
47 views

Change border color of selected cell

When I select a cell in Excel for Mac 2011 it is shown with a blue border: How can I change the color of this border?
0
votes
1answer
64 views

Why doesn't isformula() work on Excel 2011 for OS X?

Supposedly, Excel has isformula(), but all it ever gives me is #NAME? For me, isformula() is not even listed in Excel as a valid function at all! Nor is there any mention of it in the help ...
0
votes
4answers
121 views

Convert letter grades to number

In Mac Excel 2011, how can I convert a letter grade in one column to a gpa number and place it in the column next to the letter grade. I have about 70,000 grades I need to do this for.
0
votes
1answer
2k views

How do I automatically sync/couple an Excel file to Onedrive on Mac OS X?

I know how to save a file on Onedrive and it all works fine. But I would like to couple an Excel-file on my computer (or elsewhere) to Onedrive. That is: I work on a file in Excel and when I save that ...
1
vote
1answer
87 views

head and cat don't recognize Microsoft Excel text files

I have a large .xls file with 53760 rows and 19 columns. I saved it as Tab Delimited Text in order to pre-process it through command line tools and load it into R later. However, when I run head ...
1
vote
2answers
22 views

Convert numerical result to a letter in Excel for Mac 2011

I just wanted to know how to convert the result of a calculation into a simple YES or NO outcome. I.e. if the value is less than X then 'YES' you need to reorder, if the value is greater than X then ...
0
votes
1answer
146 views

Excel icon not showing open workbooks in dock

I have a coworker who no longer sees the options to click on open workbooks. Here's how it looks when it's working correctly: Note the Workbook1 & 2 showing up. He does not have that on his Mac. ...
0
votes
1answer
310 views

How to use Excel HYPERLINK function to link to an URL with query parameters?

*This is observed under OSX 10.8.5 with Office 2011 (mac). The hyperlink function seems not working with url with query parameters, why? HYPERLINK("http://mysite.com?foo=bar&x=y", "my link") ...
0
votes
1answer
397 views

Comparing two similar lists in excel on mac to find duplicates

I have 2 rather long lists of companies (a developing main list and several other lists which need to be compared to the main) I need to find duplicates (but also fuzzy duplicates) - e.g. "A company" ...
0
votes
0answers
93 views

What is the Windows equivalent of this Mac Excel shortcut?

I can't remember how I learned how to do this, but I'm 90% sure it's a built-in default shortcut for Mac Excel 2011. Make a selection in your spreadsheet. Hit option-tab to move that selection to the ...
0
votes
1answer
3k views

Tie stock quote value to cell in Excel 2011 Mac

I've been working on a mock stock portfolio in Excel, and I've been looking for ways to automatically update the data, eg. stock price and P/E ratio. I have tried using a web query to MSN Money, but ...
2
votes
1answer
63 views

Excel opens all files in directory

Excel 2011 is behaving strange. When I open a file, Excel responds by opening all (.xlsx and .csv) files in the directory! I'm running OS X Mavericks. Tried several ways of opening: double click, ...
0
votes
0answers
11 views

Change focus in Excel to formula bar via keyboard using Excel 2011 in Mac [duplicate]

I want to ask the same question as this one but for Microsoft Excel 2011 in Mac. The issue is that in Excel 2011 for Mac there is no Tools -> Options.
0
votes
2answers
462 views

How to deal with scientific numbers in excel or matlab?

I have imported a text file to excel. The file has numeric and text columns. In the numeric column there are some scientific numbers which are only in text format. When I import the excel file to ...
3
votes
3answers
173 views

Filling empty spaces in a column with a series in Microsoft Excel

I have a list like this: A B Student ID Student Name 20496836 Barnes, Troy 28682693 Bennett, Shirley Edison, Annie 28395839 Hawthorne, Pierce ...
0
votes
1answer
331 views

Linking to Other Excel Sheets Greyed Out (Excel 2011 Mac)

I just got a file from my colleague which has some broken links. They were broken because the path to the cells pointed directly to a file on her computer. She sent over those files, and now I have to ...
0
votes
1answer
259 views

Trying to Use AppleScript to Convert .xls and .xlsx to .txt (Tab Delimited), Needs Fixing

I copied this from an answer I got from another thread. I am trying to convert ~300 .xls and .xlsx files to tab delimited. They are all in the same folder. If anyone knows a better way, please let me ...
3
votes
4answers
2k views

Mass Convert .xls and .xlsx to .txt (Tab Delimited) on a Mac

I have about 150 .xls and .xlsx files that I need converting into tab-delimited. I tried using automator, but I was only able to do it one-by-one. It's definitely faster than opening up each one ...
0
votes
0answers
63 views

Is it possible to use alt-XYZ shortcuts on Excel on OS X?

I don't want to know the equivalents -- I want to use the same commands. I'm switching between windows at work and a mac at home.
0
votes
2answers
86 views

How to disable “This workbook contains macros”

This prompt comes up each time I open a file which I trust, is there a way to disable it permanently?
1
vote
2answers
6k views

How to remove the “blank” column or row in the pivot table

I want my pivot table to auto update/refresh when I add more data to the table that I am generating the pivot table from. In that case I have selected the entire worksheet to generate the pivot table. ...
3
votes
1answer
15k views

Excel 2011 Mac auto-recover file lost

Yesterday morning my colleagues Excel 2011 (on Mac OSX 10.8) crashed. He reopened Excel and was asked if he wanted to recover the previous document. Yes, he said and then got a document named ...
-1
votes
1answer
59 views

Date in my personal Excel on MacOS displays differently from Windows

I have created a personal Excel document through zipping XML documents. The structure of this document is simpler than what Excel creates. The problem is that the date in this document is different ...
4
votes
2answers
196 views

Can I set cells to remember a certain input method in Excel? If so, how?

I have an Excel document with two columns. In one column, I write using the Japanese input method. In the next one I write using the standard one (Latin based). So, can I set Excel to automatically ...
1
vote
0answers
110 views

Encrypt Excel file on Windows for use on Mac

I have an Excel file open using Excel 2007 on a Vista PC. I wish to encrypt this file, and send it to someone to open on a Mac running Excel 11.6.6 (Office 2004). Is this easily achievable? I ...
4
votes
1answer
634 views

Function argument delimiter - Excel 2011 for Mac OS X

I have two Mac OS X machines, both running Microsoft EXCEL 2011. One uses a comma to separate function parameters, e.g: function(arg1, arg2) Yet my work machine uses semi-colons, e.g: ...
0
votes
0answers
98 views

work with huge 15000 lines excel files containing formulas

We work on a huge excel file. it contains a sheet setting 22000 lines We use Excel 2011 on Mac and Windows on Intel i7 with 8Gb Ram. We have disabled the automatic computation of the file the file ...
2
votes
1answer
839 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.)
1
vote
1answer
221 views

Excel for Mac: Convert Windows split to txt macro

I'm a total VB hack - as in cut/copy/paste and try to make things work. The code below worked on my Windows machine, but won't work on my Mac. I get a file/path access error on this line: Open ...
1
vote
2answers
1k views

Automating data from an Excel file and interacting with browser

How can I automate copying records from an Excel file or CSV and interacting with a browser? Example Task: Extract or Copy record(s) from an Excel file row Go to a URL (probably using Google ...
2
votes
1answer
492 views

Spreadsheet application that can handle big data OS X

I've been working with Excel for quite a while for some statistical analysis that I do regularly. The size of the data that I'm working with has gotten much larger as of late, however. The layout of ...
1
vote
2answers
894 views

excel - generate a username from a full name field

I'm trying to generate a username using a single name field in excel which has the person's first name and last name. I'm open to what the username would be, as long as its intuitive for the user. The ...
1
vote
1answer
256 views

Create text file named after a cell containing other cell data

I tried using the code below for the Excel program on my `Mac Mini using the OS X Version 10.7.2 and it keeps saying Error due to file name / path: (The Excel file I am creating is going to be a ...
0
votes
1answer
366 views

Did Lion eat Excel

I'm running on OSX 10.7.3 using Microsoft Office 2008 (with the latest updates). Recently, Excel started crashing on startup. It happens so fast it is hard for me to detect what's going on but ...
0
votes
1answer
459 views

iodbctest works but Excel says “No ODBC driver installed”

I'm trying to connect Excel in OS X to a Vertica database and I have their ODBC driver working with iodbctest but when I boot Excel and click on Database I get "No ODBC driver installed" What are the ...
1
vote
0answers
32 views

Microsoft Excel on Mac unintentionally clears my cells

When I navigate through cells using the arrow keys I have encountered some annoying behavior. If I stop at some cell for a second or so, it automatically enters edit mode for that cell clearing ...
1
vote
1answer
371 views

OS X Excel 2008: Export All Document Sheets to Separate Tab Delimited Files

Is it possible to bulk export multiple sheets in an Excel Document to separate tab-delimited text files? As it is, it only exports the active sheet. I've got a document with 850 sheets, all of which ...
2
votes
1answer
1k views

How come I can only forecast a trendline 5 periods backwards, while I can forecast it 1000+ forward?

It doesn't make any sense. I can do it in Excel 2010 on Windows, but not Excel 2011 on OS X. Workbook I used: http://cl.ly/Ewfe Screenie:
0
votes
1answer
125 views

CSV - Microsoft office for mac 2008 doesn't add all the commas?

Let's say I have 5 column headings and I only complete the first 2 values. I then save the file as CSV (Windows). It ends up looking like this: ID,Product,Name,Value,Interest 1,PC Which is no good ...
4
votes
1answer
1k views

Excel - Formula Cell Entry by Click, can I get eg $A$1 instead of A1?

It is possible in Excel to create a cell reference using $ to prevent Excel from incrementing the row/column designator when the formula is copied. IE, if you fill a formula containing the reference ...
2
votes
2answers
1k views

Change line endings and delimiter format (permanently) when saving to CSV from Excel

I'm using Excel on Mac and it's always painful to have to reopen all exported CSVs in another text editor just to change the line endings from "CR" to "LF" and the delimiter from ";" to "," Is there ...
1
vote
1answer
6k views

How to import (and view correctly) Chinese UTF-8 encoded CSV file with Excel 2011 on Mac OS X

I have a CSV file which I can open and view the column with Chinese letters normally with TextMate. However, when I try to import this file into Excel 2011, the field comes with unreadable fonts. ...
2
votes
1answer
2k views

How can I break out of an infinite loop in Excel 2011 for OS X?

I am working on Excel macros on OS X. I am fairly new to Excel, so I commonly encounter infinite loops. How can I interrupt a running macro subroutine without killing the process?
0
votes
2answers
55 views

How to open a certain document at login?

I have a file: mydoc.xlsx (Excel spreadsheet). Is there some sort of terminal command or other setting in Excel or otherwise that makes this particular document open automatically when I login?
3
votes
2answers
780 views

How do you show the toolbar in Excel 2008 on Mac OS X Lion if it's hidden?

In Snow Leopard and earlier, there was a "tic-tac" control in the top right of the window, but after upgrading to Lion, it's no longer there. Any ideas?
3
votes
1answer
221 views

How can I select the region that should be viewed in Word from an embedded spreadsheet object?

Embedding Excel worksheet objects directly into Word seems like a killer feature to me, but it would only be useful for publication if I could choose the "printable area" of the spreadsheet that gets ...