Tracking Forums, Newsgroups, Maling Lists
Home Scripts Tutorials Tracker Forums
  Advanced Search
  HOME    TRACKER    mac


Advertisements:






Windows On Mac :: F2 Key In PC Excel Missing In Excel For Mac?


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


View 2 Replies (Posted: Mar 24, 2010)

Sponsored Links:

Related Forum Messages for Mac:
Applications :: Using Mac Excel To Windows Excel?
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.

Posted: Nov 10, 2009

View 2 Replies!   View Related
Applications :: Using Mac Excel - Merge/Filter/Extract Into A Single Excel File?
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?

Posted: Feb 6, 2009

View 6 Replies!   View Related
Applications :: Difference From MAC Excel 08 To PC Excel 2003
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.

Posted: May 22, 2010

View 4 Replies!   View Related
OS X :: MAC Excel 08 Versus PC Excel 07
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.

Posted: May 30, 2010

View 1 Replies!   View Related
Software :: Formula Array In Excel For Mac 2011 (Brackets Missing)
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.

Posted: Jan 21, 2011

View 1 Replies!   View Related
OS X V10.7 Lion :: Office 2008 Mac Excel/Word Text Missing?
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. 

Posted: Feb 7, 2012

View 2 Replies!   View Related
Software :: Mac/Windows Excel Translation
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.

Posted: Aug 21, 2008

View 1 Replies!   View Related
MacBook Pro :: MS Excel - Out Of Memory Error - Excel Won't Open
I have a Macbook pro with 2 GB of memory and never had any issues opening MS Excel until now.

The issue is Excel will not open and gives an error stating "Not enough Memory" for some reason and no spreadsheet can be opened regardless of the size (most are small, under 1 MB files).

I cant imaging buying more memory because MS Excel was working fine for over 1 year and all of a sudden this "not enough memory" error appears.

Information:
Macbook Pro 13"
Mac OS X (10.5.8)

Posted: Apr 26, 2010

View 3 Replies!   View Related
Applications :: Turning List Manager In Excel Off / Moving Columns In Excel?
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...

Posted: Apr 13, 2010

View 1 Replies!   View Related
Software :: Mac And Excel File Transfer From Windows To Mac
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.

Posted: Dec 1, 2009

View 3 Replies!   View Related
OS X :: Microsoft Excel 2007 Windows Versus 2008 (Mac)
I'm taking a class with a professor who uses Windows. We're using Excel (2003) tomorrow in class, and I'd like to use my Excel Mac to do the class.

Is there a big difference with the Mac version versus the Windows counterpart? Enough to make a significant difference?

Posted: Sep 14, 2009

View 4 Replies!   View Related
Applications :: Excel: Pulling Weather Into Excel Spreadsheet?
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!!

Posted: Oct 21, 2010

View 3 Replies!   View Related
Applications :: Excel: Pulling Weather Into Excel Spreadsheet??
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

Posted: Oct 21, 2010

View 1 Replies!   View Related
Applications :: Using Excel 2008 - Colors Change From Windows To Mac And Back
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!

Posted: Dec 15, 2009

View 3 Replies!   View Related
Windows On Mac :: Unable To Right-click In Excel 2007 / What's Causing This?
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?

Posted: Apr 21, 2010

View 4 Replies!   View Related
MacBook Air :: Windows Excel Spreadsheet Size Different Than Office For Mac?
How can I resize my spreadsheet so that it fits in the office for Mac excel spreadsheet when opening an existing windows file? Last column goes to another page.

Info:
MacBook Air, Mac OS X (10.7.4)

Posted: May 21, 2012

View 1 Replies!   View Related
Windows On Mac :: Mail Merge - Trying To Split Data From Excel To Word Documents
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).

Posted: Jul 1, 2009

View 1 Replies!   View Related
OS X Technologies :: AppleScript To Press Escape Key (3x) For Excel
I'm trying to automatically convert Excel files to PDFs using Automator. Although, every time the Excel file is opened, I get a message about links to other workbooks. I really don't care about these links and just want to convert the file to a PDF. I just can't get Automator to press the "Ignore links" button on the Excel message.Now I've found out that pressing the escape key on my keyboard activates the following buttons on the Excel message about the links:

- "Update links" (then there's a Finder window popping up)

- "Cancel" (the search for other workbooks) (another Finder window pops up)

- "Cancel" again

Then Excel opens up the file I need to convert, so I can actually convert it using Automator and do whatever I want with it.I have absolutely no experience using AppleScript.Is there a way to make a AppleScript that presses the escape key three times, so that Excel just opens my file?

Info:
Mac OSX Lion Server, Mac OS X (10.7.3)

Posted: Mar 20, 2012

View 4 Replies!   View Related
MacBook Pro :: Microsoft Excel Keeps Freezing On Back After Using Backspace Key
Don't know if this can be answered here, but I keep trying to use the backspace key in Excel and I keep getting a beachball, where only Excel freezes but I can use the rest of my computer.

I am running Snow Leopard 10.6.8, no office updates needed. Office 2004. Never had issues with this until recently.

Info:MacBookPro, Mac OS X (10.6.7)

Posted: Jun 1, 2012

View 2 Replies!   View Related
Numbers 09 :: Possible To Open IWork Files In Windows Excel
I have a file created in iWork Numbers, can I open it in Windows Excel? File not exported.

Posted: May 27, 2009

View 4 Replies!   View Related
OS X Leopard :: Excel For Mac Not Responding
I have the Mac Excel version. Suddenly the Excel icon in the dock will not respond to my double click. I went directly to the hard drive and all my files are visible and even show in the tiny preview. But I cannot open any of them.

Information:
IMAc white 24 Inch
Mac OS X (10.5.2)

Posted: May 30, 2009

View 8 Replies!   View Related
Applications :: Using Excel For Mac - How To Landscape?
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.

Posted: Sep 10, 2010

View 14 Replies!   View Related
Hardware :: Using Mac Keyboard And Excel
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.

Posted: Nov 26, 2007

View 2 Replies!   View Related
Intel Mac :: Excel Will Not Open?
Cannot get Excel to open; any ideas?

Info:
iMac, Mac OS X (10.6.8)

Posted: Mar 25, 2012

View 2 Replies!   View Related
MacBook Pro :: Convert Address Book Data To Windows Excel?
I have synchronised all my contacts from my I phone to Mac book pro address book. Now,I would like to convert all contacts to windows excel to enable me to send bulk sms. kindly help me how to do it.

Information:
A1278
Mac OS X (10.6.5)

Posted: Feb 3, 2011

View 4 Replies!   View Related
IMac Intel :: Opening Excel Files Emailed From Windows Computer
I have been unable to open an Excel .xlsx file sent as an attachment from an Windows computer. I did download the free version of WinZip Mac, and although I can open it, it is a read-only file. I want to be able to make changes and send it back as I am able to with .xls files. Stuffit doesn't work either. Apple support doesn't understand why I am unable to access it properly.

Information:
iMacG5
Mac OS X (10.6.6)

Posted: Jan 11, 2011

View 7 Replies!   View Related
Software :: Excel / Word Compatibility MAC / PC?
Does anyone else have problems copying figures (charts) made in Excel into Word? When I copy the figures into Word, they appear ok on a MAC, but when viewed on a PC, the y-axis disappears. I am using Office 2004

Posted: Jul 8, 2008

View 3 Replies!   View Related
OS X :: Excel For Mac - Graph Not Plotted Correctly
I'm currently trying to create some graphs in Excel, and the data isn't plotting as I would like it to be - not sure if there is something I am doing wrong here or if there is a setting to change. My data goes like this:

Mass (g)Average Period (s)
502.074
752.089
1002.110
1252.111

and I would like mass on the x-axis and average period on the y-axis. However, my graph is placing both values on the y-axis and placing a key beside the graph. The graph and the way I have set out the data are attached below.

Posted: Oct 14, 2010

View 2 Replies!   View Related
Applications :: Broken Hyperlinks Going From Mac To PC In Excel?
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??

Posted: Dec 14, 2010

View 4 Replies!   View Related
Applications :: Excel For Mac 2008 Crashing
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.

Posted: Jan 4, 2010

View 8 Replies!   View Related
Applications :: Mac Excel 2008 - Vlookup
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 !

Posted: Jun 17, 2010

View 2 Replies!   View Related
OS X V10.7 Lion :: Why Is Excel On Mac So Slow
In Excel for Mac (Office 2011), simple copy-paste operations can take a few seconds even with small files with no complex content. Sometimes Excel files also take very long to open.

Info:
Mail, Mac OS X (10.7.3)

Posted: Apr 24, 2012

View 5 Replies!   View Related
Intel Mac :: MS Word And Excel Keep Crashing?
MS Word and Excel keep crashing. I've tried restarting my computer.

Info:
iMac, Mac OS X (10.6.8)

Posted: May 25, 2012

View 3 Replies!   View Related
Intel Mac :: What Application Is Similar To Excel
What is the best application on Mac / apple that is good as a spreadsheet? Best Spreadsheet Application? 

Posted: Jun 3, 2012

View 3 Replies!   View Related
Power Mac :: Use Excel Now Have Upgraded To Lion?
how do i use excel now i have upgraded to lion

Info:
MacBook, Mac OS X (10.7.4)

Posted: Jun 18, 2012

View 1 Replies!   View Related
MacBook Air :: Excel Office 2011- No Standard Toolbar And Resizing Windows
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.

Posted: Dec 1, 2010

View 5 Replies!   View Related
Mac Pro :: Icons And Excel Page Shaking
I have a iDrive setup on my computer, and when ever I put my pointer into the iDrive window, all the icons in the window starts to shake left to right. As soon as the pointer leaves the windows, it stops. Also, when I launch an Excel and spread sheet, same thing happens. It shakes the whole spread sheet left to right when the pointer is in the page and stops when the pointer comes out.

Information:
Mac Pro
Mac OS X (10.6.3)

Posted: May 25, 2010

View 1 Replies!   View Related
ITunes Mac :: Copying Data To A Spreadsheet (Excel)?
I have an iTunes library that is said to contain 92,039 songs on it. When I select all the songs & choose EDIT - COPY, then open an Excel spreadsheet & choose EDIT -PASTE, it only copies over 91,797 songs! This does NOT include the 155 movies and 7 podcasts which would only bring it to 91,959, which is still a difference of 80 songs!!!

Can someone PLEASE EXPLAIN how the information I copy FROM the iTunes Library window does NOT copy over EXCACTLY as it reads? I have done this in the past AND with other libraries and have not had this problem!

Information:
Power Mac G4
Mac OS X (10.6.5)
Computer is under 1 yr old.

Posted: Jan 10, 2011

View 1 Replies!   View Related
Software :: Moving Excel Files From PC To Mac PowerBook G4
Will NeoOffice program successfully read .EXE from my PC ?

What changes will I encounter?

detail the steps I take to accomplish the transfer.

Is it safe?

I am using OS X Tiger .

Posted: Sep 27, 2008

View 3 Replies!   View Related
Copyright 2005-08 www.BigResource.com, All rights reserved