Applications :: Spellcheck In Excel For OS X
Aug 3, 2010Let's ignore for a moment how awful Microsoft Office products are on a mac. Anyone know how to turn on spellcheck? I don't see it in the preferences.
View 1 RepliesLet's ignore for a moment how awful Microsoft Office products are on a mac. Anyone know how to turn on spellcheck? I don't see it in the preferences.
View 1 RepliesIs this possible? Firefox can do it with right click -> language or something along those lines, surely Safari can load a different dictionary as well.
View 3 Replies View RelatedWhen I open up a new word doc (doc 1) and start typing randomly with loads of spelling errors the little red line does not appear under the mis-spelled word. When I Manually select spell check it tells me that there are no mistakes even though there blatantly are. If I open up a new blank doc (doc 2) and begin typing away again the same mis-spelled words, the red lines appears as it normally should. This is where it gets weird.......In doc 2 if I go into preferences>spelling and grammar, The boxes, "check spelling as you type" and "always suggest corrections" are ticked under both the spelling and grammr sections. If I then go into the same preferences for doc 1 the same boxes are ticked under the spelling and grammar sections however the grammar section is greyed out so I can't change the settings.
I am currently typing my thesis so having a wacky spell check is driving me insane. What I have been doing is opening a new doc then opening another new doc (doc 2) and typing in that however I have also noticed that the spell check doesn't always seem to work.
I am searching for a plugin, software or a solution for a situation I have with an Excel/Word Mail Merge.
It's a law firm we specialize in DUI/DWI and Reckless Driving defense. We subscribe to a data collection service that pulls data from various court systems around the state. We are then given this data by jurisdiction. The Excel files we receive come with 2 workbooks in one file for Traffic and Criminal arrests data with name, address, reason for arrest, etc, etc.
What I have been doing is opening each Excel file and copying and pasting into a new worksheet only grabbing the DUI and Reckless driving arrests because tis is all I am needing from the various files. I then save the new workbook and do a mail merge with Word from this newly created workbook.
Now my question is there such a plugin or software that will combine all the Excel files I receive from the Data collection house and then be able to filter out only the DUI and Reckless Driving arrests to a single Excel Workbook?
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 been asked to do a project at work in Excel. I am keeping track of around 7,000 properties all over the United States. My boss wants to know a lot about each one. I am really struggling with the weather part!! I need to somehow pull the temp and if its snowing or raining from the internet into excel. I have all the addresses and zip codes for each property. I was thinking i could write a formula that looks at an RSS feed or website (like yahoo or Google weather) based on the zip code of the address. I could also write the formula that pulls the weather to excel then VLOOKUP the zip. Does anyone have any ideas about this?? I am not sure what to do!!
View 3 Replies View RelatedI have been asked to do a project at work in Excel. I am keeping track of around 7,000 properties all over the United States. My boss wants to know a lot about each one. I am really struggling with the weather part!! I need to somehow pull the temp and if its snowing or raining from the internet into excel. I have all the addresses and zip codes for each property. I was thinking i could write a formula that looks at an RSS feed or website (like yahoo or Google weather) based on the zip code of the address. I could also write the formula that pulls the weather to excel then VLOOKUP the zip. Does anyone have any ideas about this?? I am not sure what to do
View 1 Replies View RelatedI recently purchased my first MAC with Excel for Mac 2008. I am unable to open any files created in it on my PC which has Excel 2003. Apple is of no help. They had assured me of compatibility at purchase citing the new open format. The MAC Excel 08 file won't open on the MAC on which is was created with their Numbers program either.
View 4 Replies View RelatedWe are using Mail in Leopard and I can't seem to find a way to change the spell-check from US to UK English, to get rid of all those ZZZs and the like.
View 3 Replies View RelatedWhen I send my .xls files from my Mac (Office 2008) to my boss's Windows machine (Office 2003), he gets an error message when he attempts to open the excel spreadsheet: Excel has encountered an error and must shut down. I've sent files to other computers and not had a problem, and my boss has received other excel files and been able to open them. So it must be something between these two machines/softwares that is affecting it. Any suggestions or ideas? I can add any additional info you need.
View 2 Replies View RelatedI was looking for a Russian spell-check.
I have installed some custom dictionaries (dic and aff), in addition to trying to use the Built-in OSX one, but it doesn't seem to pick up 99% of spelling errors.
What I also tried, is using them in FireFox. FireFox does a great job of using them and offering suggestions. The issue comes from OSX. For example, the word
"Приевт" – Which should be "Привет" (trans), does not show as an error, however. Furthermore, from all my button mashing (диоа аскдк ачф дисфйоасдч йасчдфйачсдиоайдпис) only йасчдфйачсдиоайдпис shows up as incorrect...
Is there some 3rd party tool for spell-check, or some way to fix this?
I am at a loss. I have tried to re-install OSX (but not because of this error ), however a fresh install updated to 10.9.4 did nothing.
I work a lot in Excel for Mac and I have noticed an annoying feature that I can't seem to change. No matter how many times I save a document in "landscape" it keeps on reverting back to "portrait" every time I open it. I have tried to default to landscape but it has not worked.
View 14 Replies View RelatedThere are absolutely no add-ins for Excel 2008 for mac! I really need the data analysis toolpak for school and work. Does anybody know if it's possible to download this toolpak from somewhere and install it? I've tried looking and have come up with nothing so far.
View 12 Replies View RelatedMicrosoft Error Reporting log version: 2.0
Exception: EXC_BAD_ACCESS
Date/Time: 2009-04-20 23:11:30 -0400
Application Name: Microsoft Excel
Application Bundle ID: com.microsoft.Excel
Application Signature: XCEL
Application Version: 12.1.7.090302
Crashed Module Name: libobjc.A.dylib
Crashed Module Version: unknown
Crashed Module Offset: 0x0001568c............
I am wanting to do a t-test in Excel (for a class I am teaching). So as a practice, I did this (in columns A and B):
3413
3523
2329
13200000
14200000
5612
43
These are my two groups, with means:
31.1428571466679.5
Certainly the means seem different!
However, the ttest procedure gave me this p-value:
0.174751284
The formula was this:
=TTEST(A1:A7,B1:B6,2,3)
I was wanting to know how to sort a list of birthdays in excel by month and day only (Not including years); I also tried to add only the month and day data but it kept sticking 2010 on the end.
View 1 Replies View RelatedI'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!
I want to sort out my finance spreadsheet where I have the category of the spending and the adjacent cell is the amount I spent.
[Category, Price]
[Gas , $50]
[Grocery , $80]
[Lunch , $15]
[Gas , $34.50]
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
Most of my company is PC based, but we artists are Mac based. We all work on the same Excel file, updating, saving, replacing. When we open the PC excel file on our Macs, none of the hyperlinks work ... then if we save something to the file, when the PC guys open the file, none of the hyperlinks work for them anymore either. We really want to be able to use Excel and not have to use VMware in order to update our file on the Mac. Any thoughts??
View 4 Replies View RelatedI have this weird problem.I can not open Excel and Powerpoint at the same time. I have to quit PP in order to open Excel or it won't open. Also Excel needs to be off or PP will crash when opened. Word seems to be working fine. I have reinstalled Office 2008 now twice with no help. I have also updated to the lates 12.1.5 version and no help. I also tried to repair permissions and deleted the .plist files but that did nothing.
View 2 Replies View RelatedI spent at least 30 minutes struggling with my new computer because the path name of my macros had changed. Turns out, you must manually change every item in your Excel palettes that calls a macro. That's easy, you control click on the palette icon, select 'assign macro', and choose the macro.
But although that command was not greyed-out, when I selected it, nothing would happen. There was no error message.
I found no solutions on the internet, and in the course of the 30 minutes, tried various desperate things involving new taskbars, searching for mysterious excel.xlb files, VBA scripts to build taskbars. In the course of that, I broke a bunch of things on the palette. But I found the solution, and joined this group, just so I could tell the world.
You have to have some worksheet open.
Yes, that's it. It makes no sense, but that's it.
From an Excel spreadsheet I've created a graph using the chart wizard. Is it possible to save a copy of that graph as a gif or jpg file?. If so, I'd appreciate some instruction on how to do that.
View 2 Replies View RelatedI'm trying to create a chart on excel 08 that for the following type of data:
A X Y
1 a 4
1 b 5
1 c 8
2 d 4
2 e 7
2 f 6
3 g 4
3 h 7
3 i 2
The graph has column X on the X-axis and Y on the y-axis. Is there a way graph the means of the Y column for each of the groups in column A (1's, 2's, 3's)?
I have an address book-created VCARD list that I need to get into some form of comma delimited or Excel.
I have not touched WINDOWS in 9 years so please don't suggest anything that has anything to do with Windows. I am a MAC user.
Being forced to use OFFICE in this Word/Excel/powerpoint world I attempted to do something through Entourage.
After I wasted an hour with that, I posted this on this forum.
If anyone knows of any program that will allow you to create an address list so a MAC user who has created vCARDS in address book can share with Excel users, let me know.
I recently bought a Macbook Pro (and loving it) with iWork 09 pre-installed. I really like using numbers compared to office. However, I have just started working in a group where all the other members use Windows with Office 2007. I have been able to save my numbers (and pages) documents as the office equivalent. My problem lies when I am working on a document in numbers that is the office format. I like to continuously save my progress but whenever i press save, I have to save it as a whole new document or replace the existing one. When I used to work in office 2007 I used to just press save every now and then and it would save my changes. Am I doing something wrong or is it because I am working on an excel spreadsheet in numbers (word document in pages)?
View 3 Replies View RelatedA sheet of ply comes 1220mm wide and my staircase is 1200 wide. Therefore I get two out of one cut of ply. Used an 'if' function <1220 to divide by two as I get two out of one sheet if it's less than 1220.
Cell D11 calculates the amount of ply (as width measurement) needed by using an 'if' function, and E11 works it out as an actual sheet. The problem is it's showing 0.47 instead of rounding it to the nearest whole sheet (1), even if only 10mm is used I need to buy a whole sheet.
I'm having a problem where whenever I change a particular cell in a relatively complex spreadsheet I built, Excel crashes. The cell is a trigger cell that changes a list of assumptions to calculate a particular scenario. The spreadsheet was working fine and then, all of sudden, this problem arose. I had this same problem about 3 weeks ago and ended up copying individual tabs into a new spreadsheet and globally replacing the links so it was working. That worked okay until this most recent incident. The stranger thing is it seems I can open the spreadsheet using Excel for Windows and it doesn't crash.
View 8 Replies View RelatedI 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.
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.
One of my favorite functions doesn't work - really weird. When I get to line 50 of the workbook it stops working! It doesn't matter if I cut n paste, drag or manually input the formulae it just stops ! Every row above row 50 - it works - below 50 ... nope #value appears. So an argument is wrong - but I'm inserting the same argument that works above !!!!
Is this an Mac Office glitch or am I losing my mind
Any advice appreciated . . . Stu
edit: just realised that if I increase the lookup to row 75 the reference works up to row 75 but not beyond - weird. I can't replicate the problem on MS Office on a pc !
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