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 RepliesIs there a way to set part of the document to landscape? In Word I would select the section and it allowed the option of setting the selected section to landscape. I don't see that option Pages. I was playing around with the different section breaks and margins, but couldn't figure out how to make it work. I want some tables in landscape and the rest of the document in portrait. This document will be going back and forth from Word on a PC to me. I have not had any problems so far, but I have only had my mac for a month.
View 5 Replies View RelatedI 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!!
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 RelatedI 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 RelatedWhen 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 RelatedI can't change FaceTime to Landscape. Video, Use Landscape is greyed out. Do I need to be on an active call to make the change or is there some other way to change to Landscape? I'm using a MacBook Pro with Lion 10.7.2
Info:MacBook Pro (13-inch Late 2011), Mac OS X (10.7.2)
This new version of iTunes (Mac OS X) creates a folder by the name of "Automatically Add to iTunes" on my Desktop (which is also the Music/Download folder by default). No idea what it's supposed to be good for, but no matter how much I trash it to stop cluttering the landscape, it gets re-created at every launch.
QUICK WORKAROUND: Using FileXaminer (or similar utility), make it invisible.
When printing from an email or other web-based source, I hit Cmd P and the print dialogue comes up with the landscape configuration as default. How do I get it to come up with the portrait configuration as default?
View 1 Replies View RelatedHow the hell do I print in landscape in Apple Preview.
I go to layout tab in the print menubox, and it has these 4 fancy diagrams, but none of them seem to mean landscape. Why isn't there a simple "Print landscape"/"Print portrait" button. At times like these I want to stick a rusty pole up Steve Jobs' bottom. Come back Microsoft - all is forgiven.
And also, why, once I click on "preview" (within the print menubox) to see what my settings look like - and I see it hasn't worked - I then have to reinput all of my settings again?
I'm trying to print a PDF in landscape format with 2 pages per sheet. Which I can do no problem in the print settings of Preview. The problem is controlling which order the sheets print in. As far as I can see, none of the print options actually change anything. I can change the order, select reverse layout, etc etc, and it always prints out the same, incorrect way. What am I doing wrong?
View 1 Replies View RelatedFor some reason my MacBook Pro now has the default print orientation as landscape. I have searched the forums and found what I believe is the correct solution: delete the com.apple.print.PrintingPrefs.plist file from the user Library/Preferences. Now I am a little nervious about throwing away what may be a system type file, so I would really appreciate if someone would confirm that when this preference file is trashed, the system will rebuild it, I am guessing, on a restart.
View 1 Replies View RelatedHow can I change a template document - Business Plan - to have landscape from portrait mid document?
Info:
MacBook Pro (15-inch Core 2 Duo), iOS 5.1.1
Been trying to add a page I made in landscape mode to my portrait based document but if I do that I either change the whole document into portrait or landscape which isn't ideal. How to use both modes in the same document?. Like I can I make page 1 portrait and say page 3 landscape?
View 3 Replies View RelatedThere 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 RelatedMicrosoft 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............
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)
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 RelatedLet'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 RelatedI'm lucky enough to be in Excel 2007 and have infront of me 3 columns of data.
As an example, in the first column is the colour of a product, 2nd = the price, 3rd column = quantity in stock.
Now I know that I can use an array formula to come up with a way of finding out the number of red products that are �2 and have 2 items in stock - unfortunately I am not sure how to do this!
I want to sort out my finance spreadsheet where I have the category of the spending and the adjacent cell is the amount I spent.
[Category, Price]
[Gas , $50]
[Grocery , $80]
[Lunch , $15]
[Gas , $34.50]
What I'd like is for a function that can sort the categories into individual columns for the categories. So that this big list of purchases I have is sorted out into their own column that matches the category and then sums it too. Does this make sense? I was sort of avoiding any VBA for this but if thats how it has to be done then thats cool
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 RelatedI have this weird problem.I can not open Excel and Powerpoint at the same time. I have to quit PP in order to open Excel or it won't open. Also Excel needs to be off or PP will crash when opened. Word seems to be working fine. I have reinstalled Office 2008 now twice with no help. I have also updated to the lates 12.1.5 version and no help. I also tried to repair permissions and deleted the .plist files but that did nothing.
View 2 Replies View RelatedI spent at least 30 minutes struggling with my new computer because the path name of my macros had changed. Turns out, you must manually change every item in your Excel palettes that calls a macro. That's easy, you control click on the palette icon, select 'assign macro', and choose the macro.
But although that command was not greyed-out, when I selected it, nothing would happen. There was no error message.
I found no solutions on the internet, and in the course of the 30 minutes, tried various desperate things involving new taskbars, searching for mysterious excel.xlb files, VBA scripts to build taskbars. In the course of that, I broke a bunch of things on the palette. But I found the solution, and joined this group, just so I could tell the world.
You have to have some worksheet open.
Yes, that's it. It makes no sense, but that's it.
From an Excel spreadsheet I've created a graph using the chart wizard. Is it possible to save a copy of that graph as a gif or jpg file?. If so, I'd appreciate some instruction on how to do that.
View 2 Replies View RelatedI'm trying to create a chart on excel 08 that for the following type of data:
A X Y
1 a 4
1 b 5
1 c 8
2 d 4
2 e 7
2 f 6
3 g 4
3 h 7
3 i 2
The graph has column X on the X-axis and Y on the y-axis. Is there a way graph the means of the Y column for each of the groups in column A (1's, 2's, 3's)?
I have an address book-created VCARD list that I need to get into some form of comma delimited or Excel.
I have not touched WINDOWS in 9 years so please don't suggest anything that has anything to do with Windows. I am a MAC user.
Being forced to use OFFICE in this Word/Excel/powerpoint world I attempted to do something through Entourage.
After I wasted an hour with that, I posted this on this forum.
If anyone knows of any program that will allow you to create an address list so a MAC user who has created vCARDS in address book can share with Excel users, let me know.
I recently bought a Macbook Pro (and loving it) with iWork 09 pre-installed. I really like using numbers compared to office. However, I have just started working in a group where all the other members use Windows with Office 2007. I have been able to save my numbers (and pages) documents as the office equivalent. My problem lies when I am working on a document in numbers that is the office format. I like to continuously save my progress but whenever i press save, I have to save it as a whole new document or replace the existing one. When I used to work in office 2007 I used to just press save every now and then and it would save my changes. Am I doing something wrong or is it because I am working on an excel spreadsheet in numbers (word document in pages)?
View 3 Replies View Related