Applications :: Creating Actual Size PDFs From Wide Excel Spreadsheets?
Sep 22, 2010
I'm actually trying to so this in Excel 2003 for Windows at work, but I have the most recent version of Office for Mac on my home computer and can do it there if the procedure is different between the two versions.
I'm working on a certain type of project that can have any combination of associated Word, PowerPoint, and Excel documents. When I'm done with a project, I want to create a single PDF containing all associated content. In principle, it's easy: create a PDF of each document, and then combine the PDFs using Acrobat. Unfortunately, most of the Excel spreadsheets are wider than any of the paper sizes in Excel's Page Setup options. For instance, if I select Legal for the paper size and then print landscape to PDF, it prints however many columns would fit on an 11" piece of paper, then prints the next 11" range of columns, and so on. The resulting document makes no sense, because all the columns aren't contiguous. I'm never going to print the PDF, just view it on screen, and I want the PDF to look just like the Excel spreadsheet does. Is there any sort of "Print Actual Width" option in Acrobat that overrides Excel's page-size options? I've Googled this topic and checked Microsoft's support site.
My Mac Pro hangs up midway through loading Excel spreadsheets, small and large. I've tested the 14GB of ram with no faults. Tried two different new versions of MS office - school and business to no avail. Maybe video card?
Info: Mac Pro, Mac OS X (10.7.4), Brand new MS Office - business
I mean when it is upright on a desk, not just length measurements for the screen. I am afraid that the 27'' might have put my current desk out of commission
..or at least the shelf on top that stabilizes it.
How do I get photos to open in Preview in their Actual Size? I have checked the Preferences to open photos in Actual Size but it still zooms out leaving me to have to zoom in. I have also checked off 'Respect image and screen DPI for scale.'
Also during slideshows, how can I get the photos to be viewed in actual size? Is there a better app out there designed at what I'm getting at here?
Is there a size limit for importing an Excel File into Numbers? The error message says the file is too large. Has this been changed in i-work 09? The file has multiple sheets that refer to each other, but i can't even open at this point. It is 3.1 MB.
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
cannot find the solution. Im currently working on a simple graph, i.e. year vs population (bar or pie). I would like to show the actual value as labels of the bars/pies..I know this is very simple in windows but I dont know in mac yet.
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.
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?
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!!
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
I'm going nutz and have read a bunch of other threads on this but most of it is way over my head. I just made a movie on iMovie and then moved it to iDVD. I am using iLife 08. The projects (the movie and dvd) were both widescreen. Everything was great! Looked great on the computer etc... But then I played the dvd on my widescreen TV and the top and bottom of the picture (including titles I had put on the bottom of the screen using the imovie templates) had been cut off. Not letter boxed but rather they seemed to not fit on the screen. I tried changing my tv settings but nothing seems to work. Does anyone know what might be up? I also tried to burn the dvd as a standard 4:3 project and the resulting DVD still had the top and bottom cut off. Is this an issue with my DVD/TV?
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.
I encoded a bunch of anamorphic h264 videos, all done with the same settings and software, and in Quicktime's inspector, some show as "current size: 640 x 480" and others say "current size: 640 x 480 (actual)". Although they all display CORRECTLY, I am worried something went wrong with the PAR on encoding or when setting the current size in Subler (to get comptibility with older devices). What does the "actual" part really mean?
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.
I have Leopard and an external FreeAgent HD. I have Quicken on the external and all my spreadsheets and letters on the Leopard I updated one of the six spreadsheets and when I went back this morning everything is gone. No pages (letters) and no spreadsheets. At first I too thought it was the hidden extension but I've tried every type of utility and finder search for file names and documents on both HD and external. How in the world you could lose all your documents?
I have never understood Time Machine. I looked there and tried to reinstall backups from the first of the month but the only thing in Time Machine is the program itself, none of the spreadsheets or letters. I'm still struggling with the conversion from Windows. Have been using the Mac for over a year now and love it but somethings are difficult to learn after many years on PC's.
why the iphoto library file size in the finder appears to be a certain size, while iphoto itself reports a very different size. Is there any way to recover any disk space or reconcile the numbers here? Please see the attachments below, it may make a bit more sense that way. I would like to recover the disk space and if it really is a 16gb difference somewhere.
I'm using iTunes 9.2.1 and it states that my music library is 159.99gb with 25,994 songs, however the folder containing music files is 171.26gb with 30,309 files. This is a difference of 11.27gb and 4315 files. The folder only contains mp3 or m4a files with their respective album and band folders; no images, text files or anything else. The iTunes folder is located elsewhere. I added the folder to iTunes again to see if there were 11gb of songs I'd forgotten to add and there was no difference. I even deleted all iTunes settings and the current library and added the folder again and it is still missing 11.27gb.
I'm about 95% sure that none of my music collection is missing from iTunes so my first thought was that iTunes is just reading the file sizes and count inaccurately and it really is 171.26gb, but I'm not sure.
Can anyone think of a solution without going though my entire collection and comparing it to iTunes to see if anything is missing?
I purchased Xslimmer recently,and I've just notice a big issue. In Xslimmer, it says the current size of the app is say 20 mb, but Finder says it is 50 mb. Same thing after I slim it. I checked on a different computer, and it said the same thing. Could someone check the filesize of Mail.app in Finder (mine was 77.4 mb), and the current size in XSlimmer (said it was 25.5mb).
How can I see the actual files of my photographs and images in Finder? iPhoto just creates an "iPhoto Library" it it gives me no access to the files themselves. If I'm uploading photos to a forum or Facebook I need to access the files. Any idea how I can do this?
So as I wait for WWDC to purchase my UMB, I've been reading about this debate b/w iworks and office. The story from an apple "genius" - iWorks allows you to open any office file (Word, excell or PPT) and work with in the native OS system without difficulty. You can also save to any of the above formats - so file transfers and exchange between workers/users should be seamless. So why get office? "Genius" answer: It's primarily for those that are comfortable with the way office looks, ie format. What I've been reading in this forum is that people do get both IWorks and Office for Macs (which apparently is not very robust), some go with boot camp and Office for Win. What are the actual differences? Other than how one looks over the other. Is there anything you can't do with iWork and need office?
As far as i can make out, all the photos I see in iPhoto are copies of the original. But where are the original ones, then?
I usually connect my camera to the mac and the photos get copied form there, I know this much.
When I use Finder to try to locate a photo, it is iPhoto that opens it - I don't seem to have a choice. I might want to open the original photo in another program, for example.
Question: I'm trying to make a Kobhens-style iCal icon set to replace the existing, default iCal icon(s). I know where all the icons/blank icons are, but can't seem to to find where the actual month & date are stored - or even if it's possible to modify these. Are they changeable? Where are they located in the file system?
I recently installed Lion on my mac and just learned that I cannot open my Microsoft Office documents and spreadsheets (I have Office 2004). If I upgrade to Office 2011 will I be able to open the original Office 2004 documents?
I've got some PDFs I'm trying to compile into one single PDF file. I'm using an automator script which is working well, except for the fact that the resultant PDF's page sizes are all over the place � some are huge whereas others are pretty tiny...
Is there something I'm missing here? Is there a way to combine PDFs and not have the pages sizes turn out weird? The PDFs are from different sources (some have been scanned at various resolutions, some are word documents that were printed to PDF from within OS X) so that could be the reason, but I'm just looking for a solution atm.
