Landscape Worksheet: Fill & Download for Free

Older versions of Excel used to take a performance hit if an earlier worksheet referred to values on a later worksheet. There was no performance hit if the formulas referred to an earlier worksheet. Current versions of Excel have no limitation because of improvements made to the calculation tree (which Excel maintains to tell it the most efficient sequence of calculations).I like my worksheets to be small enough that I can understand what is going on relatively quickly. And I want each worksheet to tell a complete story, simple though it may be. As a result, I fall into the “more worksheets” camp.If one worksheet is getting too big, I try to put just the raw data on one worksheet, and then use formulas to analyze it on a different one. I also frequently put lookup tables and sources for data validation dropdowns onto a worksheet named Data (which I may hide if I don’t want people messing with it).As a practical matter, I arrange my data and calculations so the workbook may be printed out and easily followed from those printouts. One page wide and many pages long is easy to follow. Several pages wide and several pages down is harder to follow, and often means a number of blank pages get printed. Whether my page is landscape or portrait depends on how wide I need to go.The purpose of a worksheet is both to perform and to communicate the results of an analysis. In many cases, somebody else will be consuming the results of my work. I therefore like the inputs and results of calculations to be visually distinct. I tend to put inputs at the top left, with results down and to the right. Frequently, I use a different font color or cell shading to indicate the input cells. This practice makes it easier for the other person to follow my logic, no matter whether they are looking at a printed copy or the actual workbook on screen.

With 16,384 columns and 1,048,576 rows, I hope you have a very long measuring tape should you be so bold as to measure an Excel 2016 worksheet. Excel tries to display the cells full size, unless you change the Zoom setting from 100% in the View…Zoom menu item. And Excel also tries to print those cells full size, unless you change the Scale setting in the Page Layout…Scale menu item (or indirectly using the Page Layout…Width or Height menu items). So assuming no overrides (and neglecting side margins and gutters between pages), the full worksheet would be 245.76 meters wide by 5242.88 meters long.That would be enough for 114 cricket fields, with space between them for cheering fans. In fact, you could hold all the matches of both men’s and women’s World Cricket Cup on top of that worksheet—and even use a time machine so players from the previous 10 competitions could repeat their days of glory on their own patch of that spreadsheet. Hope you have plenty of green ink in your printer.Excel worksheets always have the same (large) number of cells, but most workbooks don’t need anywhere near those limits. If you were to print such a worksheet, a rectangular range enclosing just the cells actually being used would be the basis of the printout—unless you change the printout properties in the Page Layout…Print Area menu item. Now you are talking about a much more manageable size measuring tape.Most of my worksheets are designed to be one page wide (either portrait or landscape) by as many pages as necessary for the data they contain. And as a mechanical engineer, I seldom need very many pages to capture my data and analysis. Your mileage, of course, may vary.

You may insert either vertical or horizontal page breaks wherever you like. As long as the pages you are printing share either all the same rows or all the same columns, those manual page breaks will give you the desired control over your page size.Most commonly, I design my worksheet layout so the printed pages all share the same columns. In such a case, I would select a cell in the the first column and use the Page Layout…Breaks…Insert Pagebreak menu item to create a manual page break at the selected cell.In a Comment, the Asker expressed a desire to print part of the worksheet in Portrait and part of it in Landscape. The least intrusive way to do this would be a Workbook_BeforePrint sub that traps the user’s print request, then controls the printing process by using Portrait for one part of the printout and Landscape for the other. Note that the print preview won’t show this change in orientation.The code below prints A1:I47 in portrait, then A48:M66 in Landscape. You will need to modify statements 5, 8, 9, 10, 11 & 12 to suit your situation. 'This code must go in ThisWorkbook code pane. It will not work at all if installed anywhere else. 'Make sure you save the workbook with either .xlsm, .xlsb or .xls file extension 'Make sure you enable macros when you open the workbook Private Sub Workbook_BeforePrint(Cancel As Boolean) With Worksheets("Sheet1")  If ActiveSheet.Name = .Name Then  Application.EnableEvents = False  .PageSetup.Orientation = xlPortrait  .Range("A1:I47").PrintOut  .PageSetup.Orientation = xlLandscape  .Range("A48:M66").PrintOut  .PageSetup.Orientation = xlPortrait  Application.EnableEvents = True  Cancel = True  End If End With End Sub