Scaling spreadsheet in Excel for Mac

%3CLINGO-SUB%20id%3D%22lingo-sub-2121896%22%20slang%3D%22en-US%22%3EScaling%20spreadsheet%20in%20Excel%20for%20Mac%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2121896%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20am%20running%20Excel%20for%20Mac%20and%20want%20to%20print%20a%20worksheet.%26nbsp%3B%3CSPAN%3EThe%20sheet%20has%20around%2070%20rows%20and%20about%2040%20columns.%26nbsp%3BI%20want%20the%20sheet%20to%20print%20out%20on%20one%20page%20wide%20and%202%20pages%20tall%2C%20maybe%20even%20three%20pages.%26nbsp%3BI%20have%20selected%2011x17%20in%20the%20print%20options.%26nbsp%3BIf%20I%20try%20to%20print%201%20page%20wide%20by%202%20tall%2C%20the%20content%20of%20the%20spreadsheet%20becomes%20extremely%20small.%26nbsp%3BIf%20I%20try%20to%20scale%20to%20fit%20then%2C%20it%20reduces%20my%20number%20of%20pages%20to%201%20but%20enlarges%20the%20content.%20I%20cannot%20seem%20to%20have%20two%20printed%20pages%20with%20larger%20content%20size.%20%26nbsp%3B%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%3EAny%20help%20would%20be%20greatly%20appreciated.%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2121896%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2121939%22%20slang%3D%22en-US%22%3ERe%3A%20Scaling%20spreadsheet%20in%20Excel%20for%20Mac%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2121939%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F963740%22%20target%3D%22_blank%22%3E%40Mark_Singleton_93%3C%2FA%3E%26nbsp%3BI'm%20on%20a%20Mac%20as%20well.%20Big%20Sur%2011.2.%20That's%20why%20it%20may%20look%20different%20from%20yours.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2121925%22%20slang%3D%22en-US%22%3ERe%3A%20Scaling%20spreadsheet%20in%20Excel%20for%20Mac%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2121925%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F403176%22%20target%3D%22_blank%22%3E%40Riny_van_Eekelen%3C%2FA%3E%26nbsp%3BMy%20window%20looks%20a%20little%20different%20than%20yours%20because%20I%20have%20Excel%20for%20Mac%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2121924%22%20slang%3D%22en-US%22%3ERe%3A%20Scaling%20spreadsheet%20in%20Excel%20for%20Mac%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2121924%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F403176%22%20target%3D%22_blank%22%3E%40Riny_van_Eekelen%3C%2FA%3E%26nbsp%3BYes%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2121920%22%20slang%3D%22en-US%22%3ERe%3A%20Scaling%20spreadsheet%20in%20Excel%20for%20Mac%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2121920%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F963740%22%20target%3D%22_blank%22%3E%40Mark_Singleton_93%3C%2FA%3E%26nbsp%3BNot%20sure%20I%20follow%2C%20but%20did%20you%20try%20it%20this%20way%3F%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Screenshot%202021-02-11%20at%2017.26.42.png%22%20style%3D%22width%3A%20500px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F254247i31E50F236AEB9D3D%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%22Screenshot%202021-02-11%20at%2017.26.42.png%22%20alt%3D%22Screenshot%202021-02-11%20at%2017.26.42.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ERepeat%20header%20rows%20in%20the%20Sheet%20tab%2C%20if%20needed.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2129473%22%20slang%3D%22en-US%22%3ERe%3A%20Scaling%20spreadsheet%20in%20Excel%20for%20Mac%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2129473%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F403176%22%20target%3D%22_blank%22%3E%40Riny_van_Eekelen%3C%2FA%3E%26nbsp%3BOk.%20Thanks.%20I%20am%20running%20Big%20Sur%2011.2.1.%20Mine%20looks%20like%20the%20below.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Mark_Singleton_93_0-1613156731020.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F254563i6E48DCC00EA02230%2Fimage-size%2Fmedium%3Fv%3D1.0%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22Mark_Singleton_93_0-1613156731020.png%22%20alt%3D%22Mark_Singleton_93_0-1613156731020.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ENot%20sure%20why%20there%20is%20a%20difference%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Contributor

Hi,

 

I am running Excel for Mac and want to print a worksheet. The sheet has around 70 rows and about 40 columns. I want the sheet to print out on one page wide and 2 pages tall, maybe even three pages. I have selected 11x17 in the print options. If I try to print 1 page wide by 2 tall, the content of the spreadsheet becomes extremely small. If I try to scale to fit then, it reduces my number of pages to 1 but enlarges the content. I cannot seem to have two printed pages with larger content size.  

 

Any help would be greatly appreciated.

9 Replies

@Mark_Singleton_93 Not sure I follow, but did you try it this way?

Screenshot 2021-02-11 at 17.26.42.png

 

Repeat header rows in the Sheet tab, if needed.

@Riny_van_Eekelen My window looks a little different than yours because I have Excel for Mac

 

@Mark_Singleton_93 I'm on a Mac as well. Big Sur 11.2. That's why it may look different from yours.

@Riny_van_Eekelen Ok. Thanks. I am running Big Sur 11.2.1. Mine looks like the below.

 

Mark_Singleton_93_0-1613156731020.png

 

Not sure why there is a difference

@Mark_Singleton_93 This looks like your print settings. You need to look at page set-up first, On the Page lay-out ribbon.

Screenshot 2021-02-12 at 20.31.18.png

 

@Riny_van_Eekelen Thanks, Riny. I did look at that. The spreadsheet I have is 40 columns and is a client spreadsheet. I was on a chat with Microsoft yesterday and saw something about spreadsheets with over 30 columns of data cannot have the scaling changed for printing. Do you know anything about this rule?

 

 

@Mark_Singleton_93 Never heard of that. Sorry!

 

@Riny_van_Eekelen No worries. Thank you for your help!