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.
View 1 RepliesI 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 1234500000 on sale in the new worksheet, that excel would look at past times I had 1234500000 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).
Can anyone tell me how to make a pie chart in Excel 2008 that uses different styles of black and white cross hatching for each slice. Its carefully hidden in Excel 2007 as a custom style, but I can't find a way of doing it in Excel 2008.
View 2 Replies View Relatedhas 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)
Solver for excel 2011 is not working in version 14.2.2
Info:
MacBook
Pro, Mac OS X (10.7.4)
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?
View 3 Replies View RelatedWhen I try a formula like =2^3 in Excel 2011, it throws up an error. Excel 2011 doesn't accept ^ for the exponent?
View 3 Replies View RelatedIt'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. thank you.
View 3 Replies View RelatedI 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)
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(R[5]C[465]:R[8]C[465])-COLUMN(R[5]C[465]),3)=0)*(R[5]C[465]:R[8]C[465]))
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..
Info:
MacBook Pro, Mac OS X (10.7)
Other products in suite work - Word, Powerpoint but excel wont open any files. The error condition is:
Error Signature:
Exception: EXC_BAD_ACCESS
Date/Time: 2012-05-16 21:53:44 +1000
Application Name: Microsoft Excel
[code]....
Info:
iMac, iOS 5.1.1
excel 2011 - screen frequently scrolls a few columns to the right on its own.
Info:
iMac, Mac OS X (10.7.2)
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)
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.
View 1 Replies View RelatedTwo 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.
Info:
iMac, OS X Mavericks (10.9.1)
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
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.
View 2 Replies View RelatedI 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.
I'm editing a book in which the author switched programs and from PC to Mac in mid-stream, so the styling of the footnotes is not consistent. The text of the book is now in NeoOffice, and I've been asked to bring all the footnotes in accord with each other. I wondered whether there is a command that will change them so they all are in the same typeface and size. (I know that by setting up a Footnote style, all new footnotes will be correct, but I'm talking about ones that already exist). The author hasn't yet finished with the book, or I'd just get her to give me a chapter or two at a time and change them manually. Time is too short for us to wait till the end, when she has done all her revisions. I guess you get the picture. If there is no way to do this, please just tell me. If you know of one, though, I'd be grateful. Hoping that this is clear. It's gotten rather late! By the way, I'm working on a MacBook (not Pro) 13" with OS 10.5 and NeoOffice 3.1.1.
View 2 Replies View RelatedI am having a problem with text formatting in Mail. Apparently I have inadvertently changed the "style" - the lines of text are very close together. I need to increase the spacing How can I change the line spacing? In Mail; If I go to Format, Style, Styles, it brings up a box with 'Default' in it but no way to change Font, Alignment, Spacing.
View 1 Replies View RelatedI made a specific list style that I need to use commonly, but to apply it to new documents I have to import the style from the original document I created it with. Is there a way to make it a default list so I can access it in all new pages documents?
View 1 Replies View RelatedI've been using Safari, but suddenly it started displaying pages like this: [URL] I don't know why it's doing this or what caused it. And really, it's not the same as disabling styles because some things are still controlled by the styles while the whole structure seems off. I tried reinstalling, which did nothing. Not every page renders incorrectly (google.com is fine), but most do (youtube, hulu, apple.com, etc).
View 4 Replies View RelatedDoes anyone know how to add Citation Styles into Microsoft Word 2008? I am from the UK and need the Harverd Referencing for uni, and the built in Citation Styles are all American.
View 2 Replies View RelatedI was wondering if there is a way to keep a paragraph style you've created for all future documents you'll type with Pages?
View 2 Replies View RelatedIn pages, its possible to select all uses of a particular style, but once selected, you can only do very limited things with it. You cannot for instance delete or even copy it. Is there a way to copy the content (not style) of the selected text formatted to a particular style? If not, is there anyway that apple script could be used to do a similar thing?
View 1 Replies View RelatedI have been using Matlab and Excel to plot graphs for academic papers. While both are good applications for plotting simple graphs with 3 or less curves in each graph, I run out of line styles and color when I try to plot many curves on the same graph. The situation is worsen when it is required that all the curves be in black and white. Do you know of good applications (freeware and commercial) that allow can provide nice looking graphs with lots of choices of line styles?
View 4 Replies View Related