![]() ![]() Click File > Print or press the keyboard shortcut Ctrl + P.Select columns F and G by hovering the cursor over the column name with letter “F”, then click and drag the cursor to the column letter “G”įigure 5.We want to print columns F and G below, with a list of 36 African countries. We simply have to select the columns, set as print area, then print. How to print certain columnsĮxcel also allows us to print columns in our worksheet. If the preview shows how we want the selected cells to be printed, we can then click the Print button to proceed with printing. In order to print the selected cells, we only have to click File > Print or press the keyboard shortcut Ctrl + P to launch the Print settingsĪ preview is displayed at the right side of the Print window. If we want to print non-adjacent cells, we can set multiple print areas by holding down the Ctrl key while we click the cells we want to print. ![]() We have now set the print area, which means that we are going to print only the selected cells B2:C25. Click Page Layout tab > Print Area > Set Print Area.On the worksheet, we select the cells that we want to print (B2:C25).Suppose we have a list of countries as shown below and we only want to print the North American countries in columns B and C.įigure 1. When we want to print only selected cells in a worksheet, we can set the print area prior to the actual printing. By default, Excel prints the active worksheet, regardless of the number of rows and columns. We only need specific parts that make sense and show the data and results we need. Most of the time, we don’t need to print out all the data in our file. How to print selected cells in Excel – Excelchat ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |