In this article you'll learn how to show gridlines in an entire worksheet or in certain cells only, and how to hide lines by changing cells background or borders' color.
When you open an Excel document, you can see the horizontal and vertical faint lines that divide the worksheet into cells.
These lines are called gridlines. It is very convenient to show gridlines in Excel spreadsheets as the key idea of the application is to organize the data in rows and columns. And you don't need to draw cell borders to make your data-table more readable. All Excel spreadsheets have gridlines by default, but sometimes you can receive a sheet without cell lines from another person.
In this case you may want them to become visible again. Removing lines is also a very common task. If you think that your spreadsheet will look more accurate and presentable without them, you can make Excel hide gridlines. Whether you decide to show gridlines in your worksheet or hide them, go ahead and find below different ways to fulfil these tasks in Excel , and Suppose you want to see gridlines in the entire worksheet or workbook, but they are just turned off.
In this case you need to check one of the following options in the Excel - Ribbon. Note: Gridlines cannot be customized. To change the width, color, or other attributes of the lines around cells, use border formatting.
To hide gridlines: On the Layout tab, under View , clear the Gridlines check box. Gridlines are used to distinguish cells on a worksheet. When working with gridlines, consider the following:. By default, gridlines are displayed on worksheets using a color that is assigned by Excel. If you want, you can change the color of the gridlines for a particular worksheet.
Gridlines cannot be customized in the same way that borders can. If you apply a fill color to cells on a worksheet, you won't be able to see or print the cell gridlines for those cells. To see or print the gridlines for these cells, you must remove the fill color. Keep in mind that you must remove the fill entirely. If you simply change the fill color to white, the gridlines will remain hidden. To retain the fill color and still see lines that serve to separate cells, you can use borders instead of gridlines.
Gridlines are always applied to the entire worksheet or workbook and can't be applied to specific cells or ranges. If you want to selectively apply lines around specific cells or ranges of cells, you should use borders instead of, or in addition to, gridlines. On the View tab, in the Show group, select the Gridlines check box to show gridlines, or clear the check box to hide them. Excel for the web works seamlessly with the Office desktop programs.
Try or buy the latest version of Office now. Show or hide gridlines in Word, PowerPoint, and Excel. Print gridlines in a worksheet. Enter and format data. Format data. Show or hide gridlines on a worksheet. When working with gridlines, consider the following: By default, gridlines are displayed in worksheets using a color that is assigned by Excel.
If the design of your workbook requires it, you can hide the gridlines: Select one or more worksheets. If the gridlines on your worksheet are hidden, you can follow these steps to show them again. In fact, you could even choose to print gridlines, but not show them on your screen. Continue reading below to learn how to remove the gridlines from the Excel spreadsheet on your computer screen.
Step 3: Click the box to the left of View under Gridlines in the Sheet Options section of the ribbon at the top of the window to remove the check mark. The lines that previously separated your cells should now be gone from view.
If you want to print your gridlines, despite them not being visible on your screen, you can check the option to the left of Print under Gridlines in the ribbon at the top of your window.
Matthew Burleigh has been writing tech tutorials since His writing has appeared on dozens of different websites and been read over 50 million times.
0コメント