1
vote
1answer
26 views

No Startup folder in Microsoft Office for Mac 2011

I'm trying to save a new default worksheet in Excel for Mac 2011. Instructions say to save it in the Startup folder at this location: /Applications/Microsoft Office 2011/Office/Startup/Excel There ...
0
votes
1answer
44 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
62 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
705 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
91 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
61 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
85 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
209 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
92 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
214 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
364 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
500 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
105 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
66 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
13 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
512 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
183 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
391 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
296 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
65 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
95 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
8k 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
17k 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
200 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
686 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
105 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
947 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
241 views

Use of Excel 2011 to produce a line graph showing amplitude variations with distance

I have 2 columns of numbers: Column A I want to be the X axis of a smooth line graph which goes through all of the data points which shows distance. Column B I want to be the Y axis showing ...
1
vote
1answer
234 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
515 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
971 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
267 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
377 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
491 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
400 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?