1. Turned the List Manager on by accident in Excel. Can't figure out how to turn it off now. I am using Excel 2004, and a MAC mouse - so no right-clicking for me...
2. How do I move columns in Excel? I select the column on top, but then try dragging it to a place I'd like it to move, but nothing happens. How do I do that?
3. General Mac Word/Excel question - how do I get to use "Home" and "End" buttons? When I hit them I simply jump somewhere, but not to the beginning or end of the paragraph. I have a MAC keyboard with the "Home" and "End" buttons along with the "Help", "Delete", "Pg Up" and "Pg Dwn" keys - basically it looks a lot like a PC keyboard...
I have a new 27" IMac with all updates installed. I use Track pad and wireless keyboard and wireless number pad. No Blurtooth in the house . Bluetooth boards replaced. Nearest neighbor is several thousand feet away and not home during the day. When using Sarafi the screen will rapidly scroll to the bottom and stay there. It might be anywhere from 30 seconds to several minutes until I am able to scroll back to the top of the page. During this time I can't get any of the bookmark folders to stay open although if I do not take my finger off the track pad I can hold it open. Some times I have to reboot Safari to reset the page. This happens on an intermittant basis and it may be days between occurences,
Is this a know bug in either bluetoopth, Safari, or the OS?
What I'd like is for a function that can sort the categories into individual columns for the categories. So that this big list of purchases I have is sorted out into their own column that matches the category and then sums it too. Does this make sense? I was sort of avoiding any VBA for this but if thats how it has to be done then thats cool
I am using Mac OS X 10.6.4 with Excel Mac 2008. I am trying to find a compatible duplicate remover. On my PC I used Ablebits which was great. Now that I have moved to Mac I cant find a similar product that is compatible.
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.
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.
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: http://www.solver.com/ This guys also have some other really cool tools if you want to check them out.
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)
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?
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.
I was wondering if anyone might know anything about the pink flashing columns i'm experiencing on my iMac screen. at first, there was one column on the screen with pink stripes... the second time it continued the same, and the third time, another column of pink stripes opened up and it really started distorting the image on the desktop, moving up and down uncontrollably.
I'm using an iMac (late 2011) with 10.7.3. I'm doing things on the computer or some process is going on when the screen instantly goes black (no dimming first). If a video was playing, I can still hear it playing, but pushing keys on the keyboard or mouse or pad does nothing to wake the screen. Sometimes pushing the power button a number of times will get the screen to come on, sometimes it won't. When the screen goes black, if an external drive was running and then stops, I can sometimes get the screen to come to live. Sometimes this black screen happens when I'm burning a DVD; when the DVD is finished, I can bring the screen to life. I thought one of my two external drives was bad, so I disconnected it. That seemed to help (though verifying the disk revealed no problems). But a few minutes ago, the screen instantly went black again; no dimming first. There have been times I thought this was associated with a new bit of software, but then it returns even after I delete the suspect software. Sometimes I have to use the power button to shut down the iMac then restart it. Once, I had to unplug and replug the iMac before I could get the computer to respond and the screen to return to life. I don't know if this is a hardware problem (internal or external), a software problem, or some combination...or something I haven't thought of, at all.
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(RC:RC)-COLUMN(RC),3)=0)*(RC:RC))
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.
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..
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.
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.
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.
My A1226 is really giving me fits. It will display persistent vertical pink and green pixel column patterns in windows or over the entire screen at start up. I have twice performed the "PRAM Re-set" with Command-Option-P-R depressed with pwer on and that has worked. But tonight it came back and I had to do it a third time. Is this a potential or probable power/battery problem? I hope someone here is familiar with this!
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.