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

ADVERTISEMENT

Applications :: Using Mac Excel To Windows Excel?

Nov 10, 2009

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.

View 2 Replies View Related

Applications :: Using Mac Excel - Merge/Filter/Extract Into A Single Excel File?

Feb 6, 2009

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?

View 6 Replies View Related

Applications :: Difference From MAC Excel 08 To PC Excel 2003

May 22, 2010

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.

View 4 Replies View Related

Software :: Formula Array In Excel For Mac 2011 (Brackets Missing)

Jan 21, 2011

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.

View 1 Replies View Related

OS X V10.7 Lion :: Office 2008 Mac Excel/Word Text Missing?

Feb 7, 2012

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. 

View 2 Replies View Related

OS X :: MAC Excel 08 Versus PC Excel 07

May 30, 2010

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.

View 1 Replies View Related

Applications :: Turning List Manager In Excel Off / Moving Columns In Excel?

Apr 13, 2010

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...

View 1 Replies View Related

Software :: Mac/Windows Excel Translation

Aug 21, 2008

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.

View 1 Replies View Related

Applications :: Excel: Pulling Weather Into Excel Spreadsheet?

Oct 21, 2010

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 Related

Applications :: Excel: Pulling Weather Into Excel Spreadsheet??

Oct 21, 2010

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 1 Replies View Related

Software :: Mac And Excel File Transfer From Windows To Mac

Dec 1, 2009

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.

View 3 Replies View Related

OS X :: Microsoft Excel 2007 Windows Versus 2008 (Mac)

Sep 14, 2009

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?

View 4 Replies View Related

Applications :: Using Excel 2008 - Colors Change From Windows To Mac And Back

Dec 15, 2009

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!

View 3 Replies View Related

Windows On Mac :: Unable To Right-click In Excel 2007 / What's Causing This?

Apr 21, 2010

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?

View 4 Replies View Related

MacBook Air :: Windows Excel Spreadsheet Size Different Than Office For Mac?

May 21, 2012

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)

View 1 Replies View Related

OS X Technologies :: AppleScript To Press Escape Key (3x) For Excel

Mar 20, 2012

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)

View 4 Replies View Related

Windows On Mac :: Mail Merge - Trying To Split Data From Excel To Word Documents

Jul 1, 2009

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).

View 1 Replies View Related

MacBook Pro :: Microsoft Excel Keeps Freezing On Back After Using Backspace Key

Jun 1, 2012

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)

View 2 Replies View Related

Applications :: Using Excel For Mac - How To Landscape?

Sep 10, 2010

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 Related

Hardware :: Using Mac Keyboard And Excel

Nov 26, 2007

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.

View 2 Replies View Related

Intel Mac :: Excel Will Not Open?

Mar 25, 2012

Cannot get Excel to open; any ideas?

Info:
iMac, Mac OS X (10.6.8)

View 2 Replies View Related

Software :: Excel / Word Compatibility MAC / PC?

Jul 8, 2008

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

View 3 Replies View Related

OS X :: Excel For Mac - Graph Not Plotted Correctly

Oct 14, 2010

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.

View 2 Replies View Related

Applications :: Broken Hyperlinks Going From Mac To PC In Excel?

Dec 14, 2010

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 Related

Applications :: Excel For Mac 2008 Crashing

Jan 4, 2010

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 Related

Applications :: Mac Excel 2008 - Vlookup

Jun 17, 2010

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 !

View 2 Replies View Related

OS X V10.7 Lion :: Why Is Excel On Mac So Slow

Apr 24, 2012

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)

View 5 Replies View Related

Intel Mac :: MS Word And Excel Keep Crashing?

May 25, 2012

MS Word and Excel keep crashing. I've tried restarting my computer.

Info:
iMac, Mac OS X (10.6.8)

View 3 Replies View Related

Intel Mac :: What Application Is Similar To Excel

Jun 3, 2012

What is the best application on Mac / apple that is good as a spreadsheet? Best Spreadsheet Application? 

View 3 Replies View Related

Power Mac :: Use Excel Now Have Upgraded To Lion?

Jun 18, 2012

how do i use excel now i have upgraded to lion

Info:
MacBook, Mac OS X (10.7.4)

View 1 Replies View Related

Software :: Moving Excel Files From PC To Mac PowerBook G4

Sep 27, 2008

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 .

View 3 Replies View Related

Applications :: Insert Calendar In Excel For Mac 2008

Sep 24, 2010

I have been trying to insert a simple monthly calendar into an excel spreadsheet, but cant find a way to do this on the mac version that im running. Any hints would be great. Idealy i would like to be able to just insert a calendar for that month but if i had to insert the whole calendar each time that would be fine too

View 2 Replies View Related

Applications :: Solver For Office Excel Mac 2011 Now Available

Oct 28, 2010

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.

View 3 Replies View Related

Applications :: Excel Mac 2008 Macros Support

Jan 28, 2008

I know Excel 2008 does not support VB macros, but did anyone notice that "Macros..." is still available under the Tools menu? I wonder why it's there? BTW, I saved an old file in Excel 2008 that had macros and then opened it in Excel 2004 to see if the macros are still there. They are. That's a big relief, because I know I can at least work on files that have VB code in them without worrying that if I save the file in Excel 2008 format the macros will go poof. Ooof

View 8 Replies View Related

ADVERTISEMENT