Stack Exchange Network

Stack Exchange network consists of 174 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.

Visit Stack Exchange

Questions tagged [microsoft-excel-2011]

The 2011 version of Microsoft's spreadsheet application for OSX.

2
votes
1answer
4k views

How to return first non-blank cell and if it's already a value before it, return the third non-blank and so on?

How to make a function which would return the first non-blank cell value but if it's defined in the left cells next to it, it would jump 2 cells and look for the next value. Table: 1 | 2 | 3 | 4 | ...
1
vote
1answer
3k 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?
1
vote
1answer
490 views

Highlight Excel spreadsheet cells every three days

I use Excel 2011 on OS X to track down my tasks list. Now I would like to add a date cell to some tasks so that every three days these tasks get highlighted. My question is if there is any way so ...
2
votes
0answers
280 views

Can I disable Excel's warning when saving CSV files? [duplicate]

Possible Duplicate: Excel: Is there a registry setting to suppress the warning messages when saving spreadsheets in CSV format? Excel always says ...may contain features that are not ...
4
votes
2answers
14k 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
2answers
8k views

Linking a cell to a tab within an Excel workbook

I'm using Microsoft Excel 2011. One of my workbooks contains a tab. I want that tab to open when I click a link. The link should be in a cell in the same workbook. How can I create such a link?
5
votes
3answers
56k views

Excel data into PowerPoint slides

I have already found some helpful sites but I'm still unable to do what I want. My Excel file contains few columns and multiple rows. All the data from one row would be in one slide but data from ...
1
vote
2answers
9k 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 ...
0
votes
1answer
2k views

Excel: Filter Pivot Table from Another Sheet / Duplicate Filters Across Sheets

I am working with Excel for Mac 2011. I have several different pivot tables that each organize data for graphing on a summary sheet. Every pivot table should be filtered the same way. Questions: ...
19
votes
4answers
54k views

How to move columns with drag and drop in Excel 2011?

How can I move columns with drag and drop in Excel 2011?
3
votes
6answers
25k 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
1answer
2k 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 ...

15 30 50 per page