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)
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 RelatedHow do i convert a excel spreadsheet to be compatible with a mac?
View 1 Replies View RelatedI have spent the last few hours trying every solution that is supposedly available for converting VCF files to an xls file. WHY can't this be an option in the Contacts program? I need to upload some contacts to Constant Contact. Come on! Really! There must be an answer that doesn't require me to convert two - three times before I can use the files.
Info:
Contacts
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.
jsut bought an imac and am having problems converting old pc excel files to pdf's. the last column keeps getting cut off.
Info:
hp, Windows Vista
I have an excel spreadsheet that I can't delete. It says that it is being used and I can't delete it.
View 7 Replies View RelatedIs there an affordable app that will move an Excel spreadsheet into an html document without losing the format? Or a method of doing it? I've done it before but can't remember how I did it.
View 1 Replies View RelatedWhy is my mac running slow, especially with excel spreadsheet?
Info:
MacBook Pro
Im currently using an Excel spreadsheet, but my business is expanding so I need to use something more functional. I have tried Sage and Quickbooks but didnt really like them, not to mention the price was ridiculous.
View 9 Replies View RelatedI would like to transfer my contacts from address book to an excel spreadsheet. Is this possible.
Info:
iMac (27-inch Mid 2011)
I transferred excell spreadsheet from my old pc to my new mac. I used it last fortnight but now cannot find it.
I have tried Spotlight but to no avail I have an Imac.
Info:
iMac, OS X Mavericks (10.9.4)
My father owns one of the original G5s, so its power pc not intel. Today while browsing an excel spreadsheet he says part of the screen turned black, then the monitor shut off, then the monitor came back on but not video. Mean while the fans started spinning out of control. Now when he tries to turn it on, he gets power, but all that happens is the fans spinning faster and faster and faster until he turns it off. No video or anything. Just speeding fans. He fears the CPUs died since they control the fans. Any suggestions? He also says the fans were spinning unusually fast these last few days.
View 6 Replies View RelatedI need to add MS Office Excel and Word to my laptop, which one should i purchase. There are many choices.
Info:
MacBook Pro (13-inch Early 2011), OS X Mavericks (10.9.3)
I was previously using Excel with no problems, then installed updates Tuesday, now can't open .xls file last used Monday?
View 2 Replies View Related i read may post about this but still do not have a solid answer. Will 20GB partition be fine with my Macbook Air SSD drive ?
I only plan on installing a antivirus software and thats about it, maybe 1 program.
At the moment I do not have Microsoft Office for my mac but I am looking into it as I will be going back to study soon and know I will encounter problems when it comes to transfering documents from my mac to a PC with Microsoft software. However I really love the mac application 'Pages' for personal projects so I am just wondering if I can still use it alongside Microsoft or I must give it up?
Info:
MacBook Air
has anyone had an issue with office mac 2011 excel and osx lion? i make excel spreadsheets with pdf storyboards on them, and too often the excel file will not reopen. instead i get a corrupt file notice. i choose fix file and the file opens without the pdf files. sounds like a pdf/excel issue to me. it is maddening.
Info:
Mac OS X (10.7.4)
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.
How do I do it? I want the document to require a password to open. I did the tools-->protection--protect workbook/sheet thing but that didn't do it, the document could still be opened, just not edited. I have a budget sheet with all of my online account passwords I don't want accessible if the computer gets stolen.
View 3 Replies View RelatedThe planned mid-January release of Office 2008 offers a significant overhaul of the productivity suite's look and features.
The previous segment described new features in Word 2008, with some comparisons to Apple's Pages 08. This article examines what's new in Excel 2008 and contrasts Microsoft's oldest application to Apple's newest: the Numbers 08 spreadsheet included with iWork.
I've seen conflicting information about the new Office Mac release. Have Macros been restored to Excel? And if so, what language are they using? Has anyone tried them or tried to import Macros from Excel 4 or Excel 5 macro languages?
View 3 Replies View RelatedDoes anyone know how to set the Excel (2008 version) toolbars at top of app to remain as a saved preference? I've tried everything and when I quit Excel and re-open, everything I've changed about the toolbar view is gone and I'm left with nothing. It wasn't like this all along, and somehow I ended up this way.
View 17 Replies View RelatedAfter latest Apple software update (3/24/12), Office for Mac crashes when trying to open Excel or Word.
Info:
iMac7.1 24, Mac OS X (10.5.1)
How do I increase the size of my excel toolbar buttons?
View 2 Replies View RelatedI have office loaded on my Mac. I work with a variety of spreadsheets and different applications like Open Office, Access, Excel. Most of my data comes from applications on the PC side. When using Office for Mac, I open a new Excel spread sheet and copy and paste data from one of the other applications. So I have a column of dates in Open Office, I copy the date column and paste into Office for Mac Excel.
When I do this the dates change by plus or minus 4 years. So if I move data labeled 10/8/2010 when I paste it into Office for Mac Excel I get 10/8/2014 or 10/8/2006. Sometimes I even get a different month or day along with the plus or minus 4 years on the year. When I move the data into Office for PC Excel I don't have the problem. The dates copy over just fine. I am not using date formulas or functions. It is simply dates put into the column that I am trying to copy into a single spreadsheet.
Does anyone know if you can label axis in excel 2008? I know before SP1 it couldnt be done, just wondering if anyone has come across this in the to SP1? Or it can be done already? Because its pretty useless for me without that feature!
View 4 Replies View RelatedAfter 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 RelatedOther products in suite work - Word, Powerpoint but excel wont open any files. The error condition is:
Error Signature:
Exception: EXC_BAD_ACCESS
Date/Time: 2012-05-16 21:53:44 +1000
Application Name: Microsoft Excel
[code]....
Info:
iMac, iOS 5.1.1
