![]() ![]() To print multiple sheets, click on the sheet tabs while holding the Ctrl key, and then choose Print Active Sheets. To print the entire sheet that you currently have open, pick Print Active Sheets. To select non-adjacent cells or ranges, hold the Ctrl key while selecting. To print only a specific range of cells, highlight it on the sheet, and then choose Print Selection. To tell Excel which data and objects should be included in the printout, under Settings, click the arrow next to Print Active Sheets, and choose one of these options:īelow you will find a brief explanation of each setting shown in the screenshot above and how to correctly use them. Under Settings, specify exactly what to print and configure the page margins, orientation, paper size, etc.Ĭhoose what to print: selection, sheet or entire workbook.Under Printer, choose which printer to use.In the Copies box, enter the number of copies you want to get.This will get you to the Print Preview window. In your worksheet, click File > Print or press Ctrl + P. ![]() To print an Excel worksheet, this is what you need to do: And then, we will have a closer look at the most important and useful features. Print to file to save output for later useįor starters, we will provide high-level instructions on how to print in Excel.Print the same range in multiple sheets.Print selection, whole sheet or entire workbook.Our tips will work for all versions of Excel for Office 365, Excel 2019, Excel 2016, Excel 2013, Excel 2010 and lower. This tutorial aims to help you get perfect hard copies of your Excel documents. This is because Excel worksheets are designed for comfortable viewing and editing on screen, not to fit on a sheet of paper. Just click the Print button, right? In reality, a well-organized and beautifully formatted sheet that looks great on a monitor is often a mess on a printed page. At first sight, printing Excel spreadsheets is super easy. Living in a digital world, we still need a printed copy every now and then. For instance, you might see the file name prefixed with "Copy of" or "Copy (1)." Thus, if the original workbook you selected in step 2 is named "Budget.xlsx," what Excel creates is a workbook named "Copy of Budget.xlsx" or "Copy (1)Budget.xlsx." If you want to rename the file, you will need to either use the Save As command, or rename the workbook after closing it.Learn how to print Excel spreadsheets exactly the way you want - print selection, sheet or entire workbook, on one page or multiple pages, with proper page breaks, gridlines, titles, and a lot more. The workbook that is opened uses the same file name, but Excel attaches some sort of phrase to the beginning of the file name, as a prefix. Excel displays a list of different ways you can open the selected workbook. Click on the down-arrow just to the right of the Open button.Select the workbook you want to make a copy of.If you are using Excel 2013 or a later version, click the File tab of the ribbon, click Open, then click Computer, and finally click Browse.) Excel displays the standard Open dialog box. If you are using Excel 2010, click the File tab of the ribbon and then click Open. (If you are using Excel 2007, click the Office button and then click on Open. There may be times when you want to make a copy of a workbook, without affecting the original.
0 Comments
Leave a Reply. |