To see the grid on your screen, under Grid settings, check the Display grid on screen box.Normally, when you print a blank worksheet, it will not be printed as following screenshot shown. To position shapes or objects to the closest intersection of the grid, under Snap to, check the Snap objects to grid box. The Grid and Guides dialog box appears. Select View on the ribbon, and in the Show group, select the dialog-box launcher.
![]() After setting print area for the cells, now, when you print the blank worksheet, you can see the gridlines in the blank worksheet are displayed as following screenshot shown:The Best Office Productivity Tools Kutools for Excel Solves Most of Your Problems, and Increases Your Productivity by 80% Then click OK button, and then select the cells that you want to print, and go on clicking Page Layout > Print Area > Set Print Area, see screenshot:4. Then in the Page Setup dialog box, check Gridlines from the Print section under Sheet tab, see screenshot:3. ![]() Combine Workbooks and WorkSheets Merge Tables based on key columns Split Data into Multiple Sheets Batch Convert xls, xlsx and PDF. Super Filter (save and apply filter schemes to other sheets) Advanced Sort by month/week/day, frequency and more Special Filter by bold, italic. Extract Text, Add Text, Remove by Position, Remove Space Create and Print Paging Subtotals Convert Between Cells Content and Comments. Exact Copy Multiple Cells without changing formula reference Auto Create References to Multiple Sheets Insert Bullets, Check Boxes and more. Dr cleaner mac reviewFull features30-day free trial. Easy deploying in your enterprise or organization. Supports Office/Excel2007-2019 and 365.
0 Comments
Leave a Reply. |
AuthorSarah ArchivesCategories |