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.

View 3 Replies


ADVERTISEMENT

OS X V10.6 Snow Leopard :: Hangs Up On Loading Excel Spreadsheets?

May 15, 2012

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

View 3 Replies View Related

MacBook Pro :: Copy Excel Spreadsheets From Windows PC System?

Dec 9, 2014

Is it difficult to copy excel spreadsheets from my Windows pc system to Mac Book Pro?

View 4 Replies View Related

Applications :: How To Increase Excel Toolbar Button Size

Jul 6, 2010

How do I increase the size of my excel toolbar buttons?

View 2 Replies View Related

IMac :: Actual Size Of The 27'' Stand?

Oct 21, 2009

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.

View 9 Replies View Related

OS X :: How To Open Photos In Actual Size

May 21, 2010

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?

View 3 Replies View Related

Applications :: Size Limit For Importing Excel To Numbers / Error Message Says The File Is Too Large?

Mar 1, 2009

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.

View 4 Replies View Related

OS X Mavericks :: Acrobat Is Reducing Size Of PDFs After Update

Jun 20, 2014

Updated os to 10.9.3 and all pdfs printed from Acrobat 11.0.07 are reduced in size.

Have checked to see that "Fit to Page" is not selected and that there is no scaling selected anywhere when printing.

Can print same document from Preview and it does not scale.

Have tried different pdfs.

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

OS X :: Microsoft Excel - Creating Simple Graph

Aug 30, 2010

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.

View 3 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 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 :: IDVD Widescreen Project Too Wide For TV?

Mar 19, 2009

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?

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

QuickTime :: Quicktime 10.0 "current Size" Vs "current Size (actual)" Difference?

Mar 22, 2012

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?

View 8 Replies View Related

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

OS X :: All IWork Files Gone - No Pages / Spreadsheets

Feb 25, 2010

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.

View 4 Replies View Related

Applications :: Won't Work With Iphoto Library / Size Doesn't Match Folder Size

Dec 31, 2009

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.

View 3 Replies View Related

Applications :: ITunes Libary Size Not Matching Music Folder Size?

Nov 27, 2010

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?

View 1 Replies View Related

Applications :: Won't Work With ITunes / Library Size And Music Folder Size

Feb 12, 2009

I dragged a folder from an external hard drive into iTunes containing the songs I want on my new MacBook.

But, for some reason the file size shown in iTunes is 47.66GB whereas Finder says my iTunes Music folder is 50.38GB

View 1 Replies View Related

Applications :: Won't Work With XSlimmer / Current Size In App Different From Finder Size

May 22, 2010

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

View 3 Replies View Related

Applications :: IPhoto - How To Access The Actual Files

Oct 30, 2007

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?

View 14 Replies View Related

Applications :: IWorks VS MS Office - Actual Differences

May 20, 2009

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?

View 24 Replies View Related

Applications :: What Is The Actual Location Of The Photos That IPhoto Uses

Oct 14, 2009

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.

View 4 Replies View Related

Applications :: Making ICal Icon Set - Where Actual Are Located?

Sep 5, 2008

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?

View 2 Replies View Related

OS X V10.7 Lion :: Cannot Open Microsoft Office Documents And Spreadsheets

Mar 25, 2012

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?

View 1 Replies View Related

Applications :: Combining PDFs - Pages Come Out All Different Sizes?

Jan 11, 2010

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.

View 2 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved