# Tagged Questions

**0**

votes

**0**answers

140 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

**1**answer

31 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

**0**answers

145 views

### VBA not working in Excel for Mac 2011

I bought a Macbook Pro and Office 2011. Am trying to use an Excel file with VBA code and macros, which works on every other Windows PC I've tried. Unfortunately it doesn't on my Mac. Office 2011 is ...

**1**

vote

**2**answers

20 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

**1**answer

220 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

**1**answer

240 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

**1**answer

2k 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

**1**answer

53 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

**1**answer

149 views

### How to set a shortcut to “Customize Keyboard…” in Excel Mac 2011

I would like to set a shortcut to "Customize Keyboard..." in Excel Mac 2011 so I could open the "Customize Keyboard" menu via a simple shortcut.
Apparently we can't do do it via Excel because there ...

**0**

votes

**0**answers

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.

**1**

vote

**1**answer

219 views

### Insert blank row into excel

I've been using this Excel program as a data base with this particular information for 5 years, inserting rows for alphabetical arranging on a regular basis. Now all of a sudden, can't do it. This ...

**0**

votes

**1**answer

258 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

**0**answers

61 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.

**1**

vote

**1**answer

76 views

### Copying an absolute reference in Excel

I am trying to copy an absolute cell reference from one sheet to another. The nature of the second sheet means that the formula will move from cell to cell depending on where it is placed. Is there a ...

**2**

votes

**1**answer

718 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.)

**2**

votes

**1**answer

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:

**1**

vote

**2**answers

3k views

### Set Zoom Default to 125% Excel 2011 on OS X

I don't like smal fonts. Therefore I would like to have a default zoom level of 125% for all spread sheets in Excel 2011 on OS X Lion. Is there a way to tell Excel to open all spread sheets with a ...

**1**

vote

**1**answer

2k views

### Alternating Row Colour with Conditional Formatting in Excel 2011 for Mac?

Does anyone know how to create a formula that causes the row colour to alternate when using conditional formatting?

**3**

votes

**2**answers

5k views

### How can I process million rows of data in Excel?

I understand that Excel can only process 65,536 rows of data. If I'm trying to analyze 7 million rows of data (say, plot a histogram distribution of 7 million values), is there any workaround?
Can I ...

**1**

vote

**2**answers

3k views

### Opening a file for output/input in Microsoft Visual Basic on Mac OS X

I am working in Excel for Mac 2011 and my goal is to create a simple macro that writes particular cells to a file. This is generally a simple task, but VB chooses not to accept a file path. For ...

**1**

vote

**3**answers

5k views

### How can I get Excel 2011 to stop opening my Personal Macro Workbook?

Ever since I created a couple of macros in Excel for Mac 2011, the Personal Macro Workbook opens every time I open Excel. How do I keep that from happening?
I have since deleted the macros, but I ...

**0**

votes

**1**answer

895 views

### How can I sort by word/token in Excel 2011

Is it possible to sort a spreadsheet based on if a word is contained in cells within a column?
Like if I take the "title" column and sort, keeping the rows connected, to bring all the rows with a ...