Windows On Mac :: F2 Key In PC Excel Missing In Excel For Mac?
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
When 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.
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!!
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
I 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.
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.
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.
1. What are the file extensions for MAC excel? Do they differ from PC excel? 2. What are the differences between MAC excel 08 vs PC excel 07? I have had some work done by a provider in elance in PC excel 07 and now i can not read the spread sheet in my MAC environment. The provider is saying that MAX and PC excel versions are 100% compatible - I disagree and need to know the differences but I am not tech/program savvy.
A problem occurs with MS Excel 2004 charts that are copied from Excel, pasted into MS Word 2004 as a "Picture", then sent to a colleague to open in MS Word for Windows.
The problem is that, on the Windows machine, some of the lines in the text boxes are truncated along the right side. The only workaround I have so far is to give the text boxes an extra wide right margin on the Mac. They will look odd on the Mac, but reasonable on the Windows machine.
Likewise, with legends in Excel charts, I have to stretch the legend box horizontally to ensure that legend text is not truncated when the Excel chart appears in an Office for Windows document.
Will my Excel & Word Files work on the newest OS for MAC? I know MAC has Microsoft Word and Excel but if I save all my files to a flash drive will I be able to transfer them to the MAC and will they work? This is why Im nervous about getting a mac.... All my Excel and Word files are the older version of MS OFFICE 97-2003 format.
I'm using my 13" MBP for running Windows 7 right now. I'm in Excel 2007 and I'm unable to right click. When I right click the menu pops up with the options that are usually available once someone right clicks, but it disappears after a tenth of a second. Any idea what's causing this?
I'm trying to use my MacBook more and more at work but have run into a slight problem with Excel 2008 (all the updates are installed).
When I open a Spreadsheet that was made in Excel 2003 on windows that has some cells colored in, make any change then save, all the colors that the cells are shaded change. They originally are bright colors and after saving on my Mac they've changed to muddy, dark versions.
As these sheets are used by multiple people this has made me quite unpopular in the office!
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.
I'm running an experiment that will give me a spreadsheet in Excel with 20 participants names, addresses, email addresses, and profits (from the experiment). My goal is to take this data and create individual receipts in Word that have all the above information and can be printed out and handed to the individuals (20 receipts). I have access to Office 2004 (Mac) or 2007 (Windows).
i need this addon for excel which is regression software or something for excel. I cannot find this addon for the mac version and i do not want to use a stupid pc for excel. Any addon that is like regression? i need it for school.
i believe its called rinlex cause in my syllabus it says
In addition to Microsoft Excel an Excel add in called Rinlex is available on the web page and also in the computer lab.
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.
I just got a new aluminum keyboard for my Mac Pro. Since I started using it I have noticed one peculiar issue. When I use Excel, the arrow keys no longer move from cell to cell. Instead, they shift the whole spreadsheet. It's not a huge deal, but I think I should be able to select cells using the arrow keys.
There 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.
I've created a PDF file using the PDF feature in Excel (Office 2004) on a iMac running 10.5.8 . The file appears to be OK. I open in Acrobat 8.1.5 and send to print, the file spools - but never prints.
I've sent this file to other users with the same result. They can open the file, but cannot print from acrobat. In all cases: - I can print other PDF files not created in Excel. - I can print the problem file using Mac Preview option.
When I view the file information: The Content Creator is: Microsoft Excel Encoding software: Mac OS X 10.5.8 Quartz PDF Content