![]() Finally, you will also learn how to print named ranges and how to use them to set a permanent print area. Additionally, you will learn how to repeat headers on all print pages. You will also learn how to customize the print settings, such as orientation, scale, margins, page breaks, headers, and footers. Highlight the print area you want, then select 'Set Print. The cells aren't simply shaded, because Excel says they have no fill, and they aren't hidden/locked/protected because I can still edit them just like normal cells. The print area is set, and all cells outside the print area are greyed out. Choose 'Set Print Area.' Hit 'Enter' or 'Return' on your keyboard to set the print area. 10 I'm trying to replicate an Excel spreadsheet that someone sent me and I can't figure out how. You will learn how to set the print area to include the cells you need, such as a selected range of cells, the current sheet, or the current workbook. Click on the 'Print Area' button in the top menu. In this guide, you will learn how to print exactly what you want and exactly how you want it in Google Sheets. Finally, you can customize the headers and footers to include any information you want. Additionally, you can add custom page breaks and choose from several formatting options, such as the alignment, the order in which pages are printed, or whether to show gridlines. The print settings allow you to select the paper size, orientation, scale, and margins. You can also customize every aspect of how Google Sheets prints your selection. If you don’t want to print the entire sheet or workbook, you can choose to print selected ranges or objects. The printed data will not exceed your specifications, but the data will not expand to fill any empty space.When printing in Google Sheets, you can control every step of the process. When you change the values for Fit to, the data will shrink to fit the specified number of pages. If you have set any manual page breaks, these will be ignored when you use the ‘fit to’ option ![]() In Excel of Office 365 the Print Area in the Page Setup/ Sheet / Print Area is grayed out. ![]() To view how the data will look on the page, view a print preview first MA MAK5551 Created on ApSet the Print Area In earlier versions of Excel, one could set the print area via Page Setup/ Sheet / Print Area and one could put in a string like 'A1:K63'. Now all you need to do is print as normal. On the Page Layout tab > Page Setup group > Orientation > choose either ‘ Portrait’ or ‘ Landscape’ In order to use this setting, the height and width options must be set to automatic.ĭepending upon the size and shape of your data, it may be better to change the orientation of the page to print your spreadsheet landscape rather than portrait. Choose 'Set Print Area.' Hit 'Enter' or 'Return' on your keyboard to set the print area. ![]() Scale the dataĪlternatively, in the same group settings here you can set the ‘scale’ percentage, which is set to 100% by default, to stretch or shrink your data to a percentage of it’s actual size. Click on the 'Print Area' button in the top menu. Note: you will see the the ‘scale’ option is greyed out once you have changed settings for the width and height – the percentage will be altered automatically for best fit to your requirements. In this example, we want the data to fit one A4 page, so we will select 1 page wide and 1 page high as in the example below. By default these are set to ‘automatic’ but if you click the dropdown arrows here you are able to choose how many pages high or wide you want your data to be. There are two dropdown boxes – one for width and one for height. On the Page Layout tab > Scale to fit group you will see a number of options Define the number of pages to print onįirst, open the worksheet the you want to print Now and again you might want to print out the contents of a spreadsheet worksheet, perhaps for an attendance list or address database for an event.Įxcel spreadsheets don’t really have default settings to have them print nicely on a standard A4 page, as you might find in Word, and you will have probably experienced the issue of printing your spreadsheet to find the rows split over multiple pages – often wasting paper and making the information hard to read.īy scaling a worksheet in page setup before you print, you can control its width and number of pages, there are two ways of doing this: 1. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |