Unlike Excel for Windows, Excel for Mac does not show Scroll Lock in the status bar. So, how can you know that Scroll Lock is on? On the Apple Extended Keyboard, press the F14 key, which is an analogue of the Scroll Lock key on a PC keyboard. If F14 exists on your keyboard, but there is no Fn.

There sure is.Here's how: From the Excel main menu: Uncheck: Summary rows below detail Does that help? *********** Regards, Ron XL2002, WinXP 'JMSprout' wrote: > When you highlight rows, go to Data, then Group or Outline, then Group, it > creates a nice plus/minus expand/collapse box for that group, only when the > group is expanded the button to collapse it is at the bottom row of the > group. Is there a way to get this button located at the top row of the group?

Is there an Excel guru that can help with this - its related to 'drop down menus' I have 2 colombs of data. AT the bottom of the first, I have created a drop down menu using the 'data validation' feature in excel.

At the bottom of the second colomb, I have used an 'IF' function that returns a result, which depends on what value is chosen from the drop down menu in colomb 1 The problem I have is that I want the TRUE result from the IF function to be another drop down menu, being the data in colomb 2. How do you write an IF function where the TRUE result is a drop down menu?? I tried to create a drop down menu of colomb2 elsewhere in the spread sheet, and used that cells location as the TRUE value, but this didn't work either. ANy suggestions??

I'm trying to come up with a solution to calculate the man hours and days worked over multiple sheets. Best apps for mac os. I have a file that has 8 sheets. The first seven sheets are the days of the week and the 8th sheet is where I want to calculate the hours.

The days of the week consists of 'Name' 'Date' Hours' The 8th sheet consists of 'Name', 'Days of the week in their own column (7 columns in total)', 'Total Hours' and 'Total Days Worked' Now. Each day is always a different group and what I'm hoping for is to create a formula that can grab each name with their hours and throw them into the 8th sheet. So when the end of the week is done I have all the Employees weekly hours and days worked all finished.

I hope this makes sense. This file is to track about 100 employees that are on a rotational work schedule.

I have attached a sample file. Thanks in advance for your help. Dear Sirs, Am in need for this solution very badly and what could be a better place than excelforum! I have an MS Excel File (2007 version) sample file attached, which has name, designation, blood group and so on. The last column is for hyperlinking photographs of individuals. In the same folder where I have saved this excel file, are lying photographs of individuals.

While scanning the photographs, I have saved them serially i.e. 1,2,3 and so on. In the Excel file, in last column, I have given the respective serial numbers. In order to hyperlink one has to select that particular Cell, press Ctrl K and you automatically go to the folder containing individual photographs, you select that photo and OK.

Problem: I have to do this hyperlinking one by one and if there 1000 photos, lot of time is wasted. Solution Needed: Just in case of excel formula, which we copy and paste, Can I get a command by virtue of which the column titled Photo or column next to it gets automatically Hyperlinked to respective photo WHEN I copy and paste such command to all cells in that column. Thanks a million and warm regards::: Jack. I'm trying to write a formula that will automatically take a group of football (soccer) scores, compare them with a set of predictions, and then allocate points according to how close the predictions are to the actual scores.

Manchester United 3 - 0 Arsenal Prediction: 4 - 1 Points: 1 I've found a formula online that works for most scores; the correct score (e.g. 3 - 0), a correct win (e.g. 4 - 1), and in the case of a draw (e.g Man Utd 1 - 1 Arsenal, and the prediction 2 -2), correct draw (but not the correct score). The points are as follows: Correct draw (Prediction = result): 4 Correct win (Prediction = result): 3 Correct win, incorrect score (Winner correct, score not): 1 Correct draw, incorrect sco 1 The formula I found online for all but the correct draw is: =IF(A3&B3=C3&D3),3,IF(AND(A3=B3,C3=D3),1,IF(AND(A3>B3,C3>D3),1,IF(AND(A3. Also, I cannot move the Pivot Table from the new Worksheet it is created in, to my existing Worksheet.

I am running Excel 2011 for Mac. I have a Worksheet with a small amount of data, and when I click the Pivot Table button it automatically creates the Pivot Table in a new Worksheet. The Pivot Table data is fine, but I want it to display alongside the source data. I've tried using the Move Pivot Table option and choosing to Create Pivot Table in Existing Worksheet and choosing a source cell alongside my current data, but nothing appears. Also, I checked in Edit menu and found that the Pivot Table appears to have not even been created/moved because there is no option to undo it. Appreciate any help, let me know if you have any further questions.