I have a file created in Excel 2003 on a PC at work. I have now converted to a Mac and I am using Parallels to run Windows. Mpc hc setup guide. I have a file with 45 tabs in 2003 Excel that I use two times a month for tax paying purposes. I have wanted to use it in my mac 2011 excel but when I open the file the sizing is incorrect. Do I have to resize each of the 45 tabs or is there a way to save it from the 2003 excel where it will open up correctly? Or a way to open it in 2011 excel so that there are no changes?

Thanks for any help you may have! It is a fact that 'sizing' (like column width, font size, etc) look different in Mac Excel and Win Excel. This is also why the default font in Mac Excel and Win Excel are different. Beside, because the Mac laptops generally have much higher resolutions than Windows laptops, you'll feel that all Windows spreadsheets look very small in Mac Excel. From my experience, there is not a perfect way to make a complex workbook which look identical in Win Excel and Mac Excel. To make the spreadsheet 'readable' on both PC and Mac, you need to test them on both platforms.

Buy Excel For Mac

Therefore, during your migration, you may need to do a long of re-formatting of your files on the Mac to make them look nice and readable. You can begin with font, font size and zoom ratio. (The default font of Mac Excel 2011 is 'Calibri (Body)' 12 points.) Regards, Edwin Tam http://www.vonixx.com. I can't save as an.xlsx file because I am taking a file saved from excel 2003 to mac excel 2011. I can't save it as an.xlsx from excel 2003, can i?

When I open the file in excel 2011 the size of the columns and rows are different so i have to resize everything. Each of the 45 tabs has 3-4 pages in it. If I print it to fit correctly it sizes it down to about 70%. Unfortunately they are forms for the government, and that is not acceptable. I just don't want to take the hours I would have to spend on that one file to resize it all. I have many many other files that I have a similar problem with, but this one is the most crucial. I was just wondering if there was a way to get it to open the exact same in 2003 as in 2011.

Thanks for any help! It is a fact that 'sizing' (like column width, font size, etc) look different in Mac Excel and Win Excel. This is also why the default font in Mac Excel and Win Excel are different. Beside, because the Mac laptops generally have much higher resolutions than Windows laptops, you'll feel that all Windows spreadsheets look very small in Mac Excel. From my experience, there is not a perfect way to make a complex workbook which look identical in Win Excel and Mac Excel. To make the spreadsheet 'readable' on both PC and Mac, you need to test them on both platforms. Therefore, during your migration, you may need to do a long of re-formatting of your files on the Mac to make them look nice and readable.

You can begin with font, font size and zoom ratio. (The default font of Mac Excel 2011 is 'Calibri (Body)' 12 points.) Regards, Edwin Tam http://www.vonixx.com. I use this code within an AutoOpen macro to adjust the size by platform. It seems to do a nice job for must purporses.

File Handling In Excel For Mac Mac

'maximize & set zoom, allow Mac users to choose If Application.OperatingSystem Like '.Mac.' Then With ActiveWindow.WindowState = xlMaximized.Top = 1.Left = 1.Height = Application.UsableHeight.Width = Application.UsableWidth End With With Application 'Allow user to choose zoom.Dialogs(xlDialogZoom).Show 130 End With Else With ActiveWindow.WindowState = xlMaximized End With ActiveWindow.Zoom = 100 End If ' Mac MVP.