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

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

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

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

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

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

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

MacBook Air :: Excel Office 2011- No Standard Toolbar And Resizing Windows

Dec 1, 2010

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.

View 5 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

OS X :: Finding Add-on's For Excel?

Sep 17, 2005

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.

View 3 Replies View Related

OS X :: Excel 08 Keeps Crashing

Aug 16, 2009

My excel (office 2008) keeps crashing as soon as I open up. I receive this error message:

Microsoft Error Reporting log version: 2.0
Error Signature:
Exception: EXC_BAD_ACCESS
Date/Time: 2009-08-16 20:30:17 +0200
Application Name: Microsoft Excel
Application Bundle ID: com.microsoft.Excel
Application Signature: XCEL
Application Version: 12.2.0.090605
Crashed Module Name: libSystem.B.dylib...............

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

Applications :: No Add Ins In Excel 2008?

Jan 21, 2008

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.

View 12 Replies View Related

Applications :: Excel 08 Keeps Crashing

Apr 20, 2009

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

View 9 Replies View Related

Applications :: Doing T-tests In Excel?

May 4, 2010

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)

View 1 Replies View Related

Applications :: How To Sort In Excel

Jul 8, 2010

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 Related

Applications :: Spellcheck In Excel For OS X

Aug 3, 2010

Let'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 Replies View Related

Software :: Creating Excel PDF?

Oct 12, 2009

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

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

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

MacBook Pro :: My Excel Won't Open

May 23, 2012

Everything was working fine until I opened a mail from a friend who sent me an excel file (from a PC).

Info:iPhone 4, iOS 5

View 2 Replies View Related

MacBook Pro :: How To Get Microsoft Excel

Jun 18, 2012

On my ipad/iphone I have docstogo which I use for my Microsoft excel work, but what do i need to use to do the Microsoft excel work on my new MacBook Pro?

Info:
MacBook Pro

View 6 Replies View Related

OS X :: Excel 2008 WTF - Making Chart?

Mar 2, 2008

I have read some complaints about what happens with some big excel benchmark or something but try this one on for size: Making a chart with 6 data points took 1 full minute to make and scrolling down after the thing was rendered, damn near impossible! seriously, Office 97 on a 486 beat this! with the right IO,, a FREE CELL PHNE could beat this! I have a brand new Macbook, smoking fast... Can we sue MS for a defective product?

View 9 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 Files Disappear From Dock?

Aug 26, 2009

I have five different excel files on the dock (they appear below the line, along with the trash icon). When I click on them a question mark appears on top of the excel symbol, and "help" says this means they have been deleted. None of them were saved anywhere but on the dock. But I have not opened three of them for weeks, and cannot find any of them with "finder". I always save when prompted before closing the Excel application, and would never knowingly delete them, as they represent hundreds of hours of work.

I'm on a Mac mini, with OS X 10.4.11

View 6 Replies View Related

ADVERTISEMENT