NOTE: Changing system function key preferences affects how the function keys work for your Mac, not just Excel. After changing this setting, you can still perform the special features printed on a function key.
Excel 2008 for Mac makes it easy to create formulas for cells. You could always do it before, but now with the new Formula Builder feature, building formulas just got one step closer to simple.
Download links to all our Windows and Apple Mac Downloaders, Recorders and Converters. Jaksta media recorder. Jaksta Media Recorder for Mac The Video and Music Downloader that Captures Video & Audio from 100,000+ Web Sites. More than just an ordinary video and music downloader, Jaksta Media Recorder makes it incredibly easy to save and convert videos and music from thousands of web sites directly to your mac. Jaksta Media Recorder can download. Download and install Jaksta Converter to your Mac. Get great Video, Music and Radio downloaders and converters for your Windows PC and Apple Mac. Jaksta recorders are easy to use and fast! For Windows and Mac. The Ultimate Video downloader that works great for Music too! More Info Buy Now Download. Jaksta downloads and converts videos and music from more sites now than any other downloader!
Just press the FN key. For example, to use the F12 key to change your volume, you would press FN+F12. If a function key doesn't work as you expect it to, press the FN key in addition to the function key. If you don't want to press the FN key each time, you can change your Apple system preferences: Change function key preferences with the mouse. On the Apple menu, press System Preferences. Select Keyboard. On the Keyboard tab, select the check box for Use all F1, F2, etc.
Keys as standard function keys.
Software:: Formula Array In Excel For Mac 2011 (Brackets Missing) Jan 21, 2011 I am experienced in Excel VBA on the PC but not on the Mac. I am building an application on my PC that will run on my sister's Mac (latest OS, Excel V14.0.2). The problem involves the use of FormulaARRAY in my code. I have extracted the problem statement into a small example routine shown below: Public Sub example Dim lastcol As Long With ActiveSheet lastcol = 12.Cells(4, 6).FormulaArray = '=SUM((MOD(COLUMN(RC9:RC' & lastcol & ') -COLUMN(RC9),3)=0).(RC9:RC' & lastcol & '))' End With End Sub Here is one of the correct and working formulas that resulted on the PC (note the brackets for the array formulas are missing but they are there. I got what I am showing by using the 'display formulas' option which apparently does not show the brackets): =SUM((MOD(COLUMN(RC9:RC12)-COLUMN(RC9),3)=0).(RC9:RC12)) Here is the incorrect and non working formula that resulted on my sister's Mac: (again the brackets are there) =SUM((MOD(COLUMN(R5C465:R8C465)-COLUMN(R5C465),3)=0).(R5C465:R8C465)) Both systems were set to display R1C1 Reference Style.
This is irrelevant on the PC and I would assume the same for the Mac. I bought an old G4 for $60 to use to debug my PC code in the Mac environment. Curiously the code runs fine on it under Excel 2004.
Similar Messages:. ADVERTISEMENT Sep 2, 2010 I'm lucky enough to be in Excel 2007 and have infront of me 3 columns of data. As an example, in the first column is the colour of a product, 2nd = the price, 3rd column = quantity in stock. Now I know that I can use an array formula to come up with a way of finding out the number of red products that are 2 and have 2 items in stock - unfortunately I am not sure how to do this! Feb 22, 2010 I am a newly converted Mac user and have some entrenched Excel habits, and try as I might, I couldn't locate this Excel formula in Numbers.
Yes, connecting an external hard drive or USB flash key to a Mac will generally read and work fine as is because the Mac can easily read other filesystem formats, including Windows MSDOS, FAT, FAT32, ExFat, and NTFS formats, but unless you intend on using the drive between a Windows and Mac machine, formatting it to be entirely Mac compatible filesystem is highly recommended, and necessary for Time Machine and to make disks bootable. To format a drive on a Mac, you’ll need the built-in Disk Utility application. Press Command+Space to open the Spotlight search dialog, type “Disk Utility”, and press “Enter” to launch the app. You can also open a Finder window, select “Applications” in the sidebar, and head to Utilities > Disk Utility. To do so, plug it into one of your Mac's USB ports, which resemble thin, rectangular slots on your computer's housing. Some Macs don't have USB ports, so you'll need to purchase an adapter. To share a USB drive between a Mac and a Windows PC, there are two disk formats to choose from: exFAT and FAT32. The other formats -- Microsoft's NTFS and Apple's Mac OS Extended -- don't work well on the other operating system. How do you format usb macbook.
In Excel, I use '=C55 (or cell reference)' to copy that particular value from one worksheet to another. I do this by clicking on the cell where I want the value to be copied to, type = and then switch to the other worksheet and click on the cell I want to copy. And voila, I am now back onto my 1st worksheet with the value showing.
I do this because the value I want to copy to this cell changes regularly. Feb 28, 2009 I have a very limited knowledge of Excel, but generally find that I can figure things out eventually. However, this time, I just can't seem to tweek it so the result is what I want. I have a spreadsheet for tracking parts ordered, and simply need to display how many days a part has been on order. I have a column for date ordered, and one for date received. Is there a way to program the formula to tell me the days that a part has been on order without displaying today's date in the spreadsheet (leaving it blank), and still be able to enter the date that it does arrive for our records?
Jan 25, 2010 I have recently run a 13 page excel spread sheet for a budget on Windows and on transferring it to Numbers on my new mac, one of the formulas is not compatable. This is what I do. There is a balance figure on each of pages 2 to 13 which are then required to be transferred as a total figure in one of the columns on page 1. This was the formula on windows: =SUM(xmas:Savings!F2) Mar 19, 2008 The left edge of my excel formula bar is not showing-almost as if it was pushed off the left side of the desktop (see picture). Unfortunately, the only part of the formula bar that allows it to move is now hidden, so I can no longer move the formula bar. I have tried switching the formula bar on and of in 'View' and also tried re-loading excel, but it is stuck.
Does anybody know how to reset the formula bar position? Apr 3, 2009 I am currently using excel 08 and have made a workbook with multiple worksheets in it. Each worksheet contains information on multiple products, such as description, UPC, cost, retail, sale cost, sale retail, how many items sold during sale, etc. Sales are two weeks, so every two weeks, I add a new worksheet with new information for sales I will be running a few weeks down the road. I would like to see if there is a way that I can have excel look through the past worksheets so when I enter a UPC into the new worksheet, there would be a column at the end that would take the average items sold during past sales.
For example, if I want to put UPC on sale in the new worksheet, that excel would look at past times I had on sale and take the average of how many sold during past sales and enter that number in a cell on the new worksheet. I don't know if this is relevant or not, but Column D is where I enter UPC info, Column P is where I put how many sold, and Column Q is where I want this average sold to appear (no matter what worksheet). Mar 24, 2010 Recently switched from PC to Mac, I really miss the F2 functionality in Excel for Mac Or, more specifically, I am missing the possibility to place the cursor in a cell and hit F2 to edit the formula as well as Excel color-coding all cells that are referred to from the current cell. I know I can do the same by clicking in the 'formula builder toolbar' but I don't wan't to have to reach for the mouse each time. Does anyone know if Excel for Mac has a similar feature / keystroke to use Jun 9, 2012 has anyone had an issue with office mac 2011 excel and osx lion?
I make excel spreadsheets with pdf storyboards on them, and too often the excel file will not reopen. Instead i get a corrupt file notice.
I choose fix file and the file opens without the pdf files. Sounds like a pdf/excel issue to me. It is maddening. Info: Mac OS X (10.7.4) Jun 16, 2012 Solver for excel 2011 is not working in version 14.2.2 Info: MacBook Pro, Mac OS X (10.7.4) Oct 28, 2010 I looked and I didn't find any info so I just wanted to tell you that Solver for Excel Mac 2011 is now available as a free download here: This guys also have some other really cool tools if you want to check them out. Apr 29, 2012 I've had great success with Excel 2011 on OS 10.6.8. Up until today.
Now, Excel crashes on launch, tries to recover, and crashes again. I read the previous comments about a) hold down shift key and launch and b) delete the /plist file. Tried both, no success. I can still launch Excel 2008, fyi.
And Word, etc, all other MS office products. Info: MacBook (13-inch Aluminum Late 2008), Mac OS X (10.6.8) Oct 27, 2010 I've seen conflicting information about the new Office Mac release. Have Macros been restored to Excel? And if so, what language are they using? Has anyone tried them or tried to import Macros from Excel 4 or Excel 5 macro languages? Oct 30, 2010 MS has added many styles to default worksheet in 2011. Previous versions I could create my own default workbook and put it in the Startup folder for Excel.
That does not work in 2011. Anyone able to tell me how to use my former default sheet in 2011 (don't want to Template feature)?
I am talking about the sheet created when you start Excel. Oct 23, 2010 When I try a formula like =2^3 in Excel 2011, it throws up an error. Excel 2011 doesn't accept ^ for the exponent? Oct 28, 2010 It's supposedly the shortcut to Paste Special in Excel 2011. It's not working for me.
Maybe I'm hitting the keys wrong? You can see it if you go to the Edit menu. May 10, 2012 I am upgrading to Lion and Microsoft Excel and Office will not run under Lion.I am upgrading to office 2011.Do I need to uninstall office 2004 prior to installing 2011.If so how do I uninstall 2044.
Info: iMac, Mac OS X (10.6.8) Feb 14, 2012 Excel on my mac is so confusing and i have never used it before. It prints out everything but the grid lines for the graph.without the gridlines, the graph looks weird and not easy to read.The print preview shows the grid lines on the mac but when it prints out, i get a weird graph. Info: MacBook Pro, Mac OS X (10.7) May 16, 2012 Other products in suite work - Word, Powerpoint but excel wont open any files. The error condition is: Error Signature: Exception: EXCBADACCESS Date/Time: 2012-05-16 21:53:44 +1000 Application Name: Microsoft Excel code. Info: iMac, iOS 5.1.1 Jun 18, 2012 excel 2011 - screen frequently scrolls a few columns to the right on its own.
Info: iMac, Mac OS X (10.7.2) Jul 1, 2012 MS Excel and MS Powerpoint (2011)does not work on my Macbook Pro after installing (updating) to 10.6.8. MS Word does though. Extremely irritating. Info: MacBook Pro, Mac OS X (10.6.8) Oct 26, 2010 Does anybody know where the controls / forms toolboxes are. Just got to the end of building a spreadsheet, and cannot find the control toolbox anywhere for adding spinners, check boxes etc.
Is it even included anymore, as web searches draw a total blank for me. Dec 1, 2010 Two strange issues that I can't fix on my new MB Air 13 with MS Office for MAC 2011 and Excel. 1) I can't get the Standard Toolbar to show up when I open a new worksheet. I go to view, toolbars and then see that the Standard Toolbar is checked, but it doesn't show up.
The only way to get it to show up is to do a series of steps: - uncheck Standard Toolbar menu and go back out; - go back in and check the Standard Toolbar and back to the spreadsheet - the Standard Toolbar still doesn't show up; - so then I click on the Layout tab on the ribbon and then it shows up! 2) I can't see the bottom of the window/spreadsheet - which means I can't resize the window. To resolve this, I have to do these steps: - open system preferences and change my MBA screen resolution from 1440 x 900 down to 1280 x 800 - then go back to the spreadsheet, and resize the window (make it smaller on the screen) - go back and resize the window back to 1440 x 900 - and then close the system preferences at this point, the Excel spreadsheet window is smaller and I can see/use the bottom of the screen to resize, etc. Can't figure out what setting I have wrong or why I can't get Excel for Mac 2011 to work correctly on the MB Air screen. Dec 10, 2014 The printing area is smaller than the page I want to print, 3 or 4 columns are on an other page to the right of the print area that I can print, I am not great on excel but would like to move the printing area so it can take all of it.
Info: iMac, OS X Mavericks (10.9.1) Nov 30, 2014 I'm trying to turn on the excel functionality where I can see shortcuts when I hover over a button e.g. The bold button i would expect to see something like this 'bold cmd+B'. I have tried searching communities but I could find the answer.
I found the answer for windows but not for mac. Below you can see a screen print to illustrate the issue. Excel only shows 'bold' when I hover over the bold button and not 'bold cmd+b'. Im using excel 2011. Info: MacBook, iOS 8.1.1 Oct 29, 2010 Upgraded to Office 2011 from 2008, when I open existing spreadsheet on MacBook the bottom of the page extends below the dock so I cannot access resize corner. I can maximize to get access to resize but am looking for fix so that when a sheet is opened the page does not fall below dock. Even happens on new default spreadsheet.
Feb 7, 2012 I am running Lion 10.7.3 on a 2.8GHz CoreDuo iMac from 2007 and on a Macbok Air 2.13 GHz Core duo from 2010. The iMac has 4GB of RAM the Macbook has 2 GB RAM. I run Microsoft Office 2011 on both machines. For the same file the Macbook operates normally on Word and Excel.
The iMac is slow at best and when I try a Save As it hangs for up to 15 minutes brfor letting me change the FIle Name. This effectively makes it unusable. As far as I can tell the set up of Office on both Machines is identical and I have eliminated duplicate Fonts as suggested by some posts but the problem remains. I have checked Activity Monitor and I am not getting any Page Outs so RAM does not appear to be an issue. Feb 7, 2012 After upgrading to Lion, I can no longer see the text in my word documents or excel worksheets. I know the text is there because it appears in the formula bar - it just isn't visible in the cells.
I can also see the text if I quickview the excel files. In the word documents, all I can see are the pictures/images.no text. Weird. I have the latest version of Office 2008 and Lion OS. Apr 28, 2012 When opening Word 2011 I get a message coming up that spell checker is missing and as a result I can close the dialoge box and use the program. It has been working fine until today. Sep 7, 2014 During math I have to type a lot of (curly brackets). This is making my little finger numb.
Can I change the default shift+9/0 shortcut to cmd+9/0? This only has to work in Safari. I don't need the 9 and 0 bookmark hotkeys.
I tried creating a Safari shortcut in the settings but it does nothing.