Shortcuts give the ease of working and improves the speed as well. These shortcuts help with creating, opening, saving, closing, protecting, and viewing files. Of course, when you want to print a different area, you must go back to Print Area and click on Clear the Print Area. Now when you try and print a worksheet, only the print area would be printed (and only this will be shown in the.
Select the worksheet range that you want to print. expression A variable that represents a PageSetup object. Here, we selected cells A1 through F13, held the Ctrl key, and then selected cells H1 through M13. To set a single print area, select the cells. Pertama, Blok seluruh sel yang hendak di print (Poin 01 pada gambar di bawah). Jalankan aplikasi Microsoft Excel terlebih dahulu, buka file yang ingin dicetak dan kemudian seleksi area untuk dicetak. If you try to print the document before setting print area, Excel will try to print the whole worksheet. The Print Area button is located on the Page Layout tab in Excel. To print a specific portion of your Sheet, select the cells you want to print (e.g., click-and-hold your cursor in one corner cell of your desired print area, then drag to select adjacent cells) as shown in Figure A.
SET PRINT AREA EXCEL ONLINE HOW TO
Even though Grahame asked for how to set the print range in a macro, it should be noted that you can automatically set the print range without using a macro.
On the worksheet, select the cells that you want to define as the print area. On the Page Layout tab, in the Page Setup group, click Print Area, and then click Set Print Area.
SET PRINT AREA EXCEL ONLINE CODE
Enter or copy the following code into This Workbook code module You will now see the This Workbook code module- double click to open itĤ. Click on ThisWorkBook in the Project VBA Windowģ. Well, with a little bit of VBA code we can achieve a more permanent scroll restriction.Ģ. Now then, unfortunately this isn’t a persistent feature and is reset when you save your file, close it then reopen. In the properties window enter the scroll area you want, this has to be entered manually (typed) in this example its B2:D10Īfter you have done this, you can then only scroll those few cells and cannot activate anything outside that area. First of all you need to make sure the Developer Tab is visible. It’s really easy to do this and can control user access to the cells you choose. Sometimes you may want to limit the access of a user to a particular range of cells in a worksheet, for example you may have a worksheet set up that only a certain range can be modified or activated -perhaps data entry cells or formula cells.
0 kommentar(er)
