All Questions
Tagged with microsoft-excel-2016 mac
13
questions
0
votes
1
answer
188
views
Mac Excel 2016 formula to add selected cells just by clicking on them
In a previous version of Excel, I could just click on each cell that I wanted to add and it would automatically put a + between each one. I can't figure out how to do that on this version.
So if I ...
- 3
1
vote
1
answer
608
views
Extracting data from one Excel sheet to another, with no spaces in rows
I've got an Excel workbook with 3 sheets. One is MasterList. One is Assigned. One is Contacted.
In the MasterList, there's a dropdown next to a name. In that dropdown is "assigned" or "contacted." ...
- 15
2
votes
2
answers
3k
views
Excel on Mac - conditional formatting only works until other condition
Excel's driving me crazy again... I'm trying to do conditional formatting with 3 conditions - Yes should be green, No should be red and any other text should be yellow. For this, I have (please note ...
- 197
0
votes
0
answers
46
views
Excel's IRR function seemingly differs from actual math
I am currently developing a web application that will have to do IRR calculations and as such need to develop a math formula for it.
Never the less, after messing around with online formula's. I ...
- 103
1
vote
2
answers
5k
views
If Sheet1 A2 Matches Sheet2 B2 Copy A2 to sheet2 A2
I have two reports with matching "reference numbers".
But one sheet has an order number and one doesn't.
I need help with a formula that basically says if the two reference numbers match copy ...
- 87
0
votes
1
answer
2k
views
How to perform the same operation on multiple excel files
I have a series of excel files all numbered sequentially, having data that is of the same format, but taken at different times. I would like to perform the same operations on all the excel files, ...
1
vote
1
answer
65
views
Count if cell = X, based on data in a column
My data shows how many orders clients have made over the last year.
In column A, cells contain CAD, HEL or PBN (client types)
In column C, cells contain the number of orders that client has made.
I ...
- 15
1
vote
1
answer
691
views
Excel - Conditional Formatting: Why can't I format decimal rounding? Only Font, Border, Fill?
In another post that is asking the same question that I ultimately have, the top answer says to conditionally format the cells using the formula ###,###. But when I go into conditional formatting, my ...
- 135
6
votes
1
answer
14k
views
As a US user, how can I change the default date format in Excel 2016 (Mac) to YYYY-MM-DD?
Note: I see several questions (q1, q2) on this topic that describe how to accomplish this with the Windows version of Office, but I haven't found anything on Mac version of Office.
I'm a US user, and ...
- 377
4
votes
1
answer
21k
views
How to move columns with drag and drop in Excel 2016?
How to move/reorder columns with drag and drop in Excel 2016 for Mac? The method that worked for Excel 2011 no longer works in 2016. The cursor never changes to the pointer or hand.
- 245
1
vote
1
answer
2k
views
Frequency function in excel 2016
I'm attempting to array data using the frequency function in excel. When I select my data and bin, hit control enter, I get only the answer of the first cell. When I attempt to drag the t cursor down ...
- 11
8
votes
2
answers
7k
views
Microsoft Excel 2016 Mac: Smooth cell transition
Changing cells in Excel 2016 Mac by clicking arrow keys results in smooth (i.e., painfully slow) transitions. Is there a way to disable this?
(Note: distinguish this, I think, from 'smooth scrolling'...
- 183
6
votes
5
answers
8k
views
How to export a spreadsheet to a UTF-8 .csv from Excel 2016 on mac?
Hoping you can help me out with this one...
For my work, I've been assisting a DBA for the last few weeks and we've now been given the task of uploading a very large spreadsheet which has several ...
- 160