Microsoft Excel中的网格线使查看数据变得更加容易。但是,如果您不想在制作电子表格(making spreadsheets)时使用这些网格线,则可以禁用它们。有多种方法可以在Excel中删除网格线。
您可以隐藏它们,用白色填充它们以使它们消失在页面中,或者创建一个不使用网格线的模板。
在 Excel 中快速删除网格线(Quickly Remove Gridlines in Excel)
Microsoft Excel有一个选项可以定义网格线是否出现在电子表格中。您可以禁用此选项以隐藏Excel电子表格中的网格线。
此方法适用于每个工作表,这意味着您必须为每个工作表执行这些步骤才能删除网格线。
- 在 Windows 或Mac计算机上使用Microsoft Excel打开电子表格。
- 在电子表格底部选择要从中删除网格线的工作表。
- 选择Excel界面顶部的页面布局选项卡。(Page Layout)
- 取消选择网格线(Gridlines)部分中的视图(View)框。
Excel 将立即隐藏(Excel will hide)当前工作表中的所有网格线。如果您想恢复网格线,请启用网格线(Gridlines)部分中的视图(View)框。
在 Excel 中更改网格线颜色以删除网格线(Change the Gridline Color to Remove Gridlines in Excel)
从Excel(Excel)工作表中删除网格线的另一种方法是更改网格线的颜色。默认情况下,Excel使用灰色作为网格线。如果将其更改为白色,您的网格线将自动消失。
同样,此选项适用于每个工作表,这意味着您必须为每个工作表执行这些步骤才能删除网格线。
- 使用Microsoft Excel(Microsoft Excel)启动您的电子表格。
- 选择要从中删除网格线的工作表。
- 选择Excel左上角的文件(File),然后从左侧边栏中选择更多(More)>选项。(Options)
- 从Excel 选项(Excel Options)窗口的左侧边栏中选择高级。(Advanced)
- 向下滚动右窗格到此工作表的显示选项(Display options for this worksheet)部分。在这里,选择网格线颜色(Gridline color)选项。
- 在颜色列表中选择白色。(White)
- 选择窗口底部的确定。(OK)
所有网格线现在应该隐藏在您当前的工作表中。
应用填充颜色以删除 Excel 中的网格线(Apply a Fill Color to Remove Gridlines in Excel)
您可以在工作表中填充白色以使网格线消失。稍后(Later),如果您改变主意,可以删除填充颜色以恢复网格线。
- 打开要从中删除网格线的工作表。
- 选择要从中删除网格线的单元格。要从整个工作表中删除网格线,请按Ctrl + A (Windows) 或Command + A ( Mac ) 以选择整个工作表。
- 选择Excel界面顶部的主页选项卡。(Home)
- 选择水桶图标旁边的小向下箭头图标,然后选择白色(White)。
- 现在应该从您的工作表中删除网格线。
要恢复网格线,请从存储桶图标菜单中选择无填充。(No Fill)
从 Excel 中的特定行或列中删除网格线(Remove Gridlines From Specific Rows or Columns in Excel)
如果您要从特定行或列(specific rows or columns)中删除网格线,请使用 Excel 的边框(Border)选项。此选项允许您从电子表格的选定区域中删除网格线。
- 打开要在其中隐藏网格线的工作表。
- 选择要从中删除网格线的行或列。
- 右键单击(Right-click)选定的列或行,然后从菜单中选择“设置单元格格式”。(Format Cells)
- 在“设置单元格格(Format Cells)式”窗口中选择“边框(Borders)”选项卡。然后,选择颜色(Color)选项并选择白色(White)。
- 在预设(Presets)部分中选择大纲(Outline),然后选择内部。(Inside)然后,选择底部的确定。(OK)
回到工作表屏幕,您会发现所选区域的网格线现在消失了。
在 Excel 中始终保持删除网格线(Always Keep Gridlines Removed in Excel)
如果您希望将来的电子表格不使用网格线,请创建一个默认不使用网格线的 Excel 模板(an Excel template)。然后,您基于此模板的任何电子表格都将没有网格线。
要制作此模板:
- 打开 Excel 并选择空白工作簿(Blank workbook)以创建新工作簿。
- 在编辑屏幕上,选择顶部的页面布局选项卡。(Page Layout)
- 取消选择Gridlines部分中的View选项。这将禁用当前工作表中的网格线。
- 通过选择File(File) > Save As将您的工作簿保存为Excel模板。
- 从Excel 工作簿(Excel Workbook)下拉菜单中选择Excel 模板。(Excel Template)
- 输入模板的名称(类似于Gridline Free)并选择Save。
- 要使用此模板制作电子表格,请打开Excel,选择新建(New)>个人(Personal),然后在列表中选择您的模板。这将创建一个没有网格线的工作簿。
在 Excel 中打印网格线(Print Gridlines in Excel)
默认情况下,打印 Excel 电子表格(print an Excel spreadsheet)时不打印网格线。如果您想打印网格线,请在Excel应用程序中启用一个选项。
- 使用Microsoft Excel(Microsoft Excel)启动您的电子表格。
- 选择Excel界面顶部的页面布局选项卡。(Page Layout)
- 在网格线(Gridlines)部分启用打印(Print)选项。
- 按Ctrl + P (Windows) 或Command + P ( Mac ) 打开打印屏幕。您会注意到打印预览显示了网格线,这意味着当您打印电子表格时将打印您的网格线。
- 要禁用打印网格线,请关闭网格线(Gridlines)部分中的打印(Print)选项。
从 Excel 电子表格中摆脱网格线(Getting Rid of Gridlines From Excel Spreadsheets)
虽然网格线可以更轻松地在Excel(Excel)电子表格中排列数据,但您并不总是必须使用它们。对于不需要网格线的情况,上述方法应该可以帮助您从Excel电子表格中删除网格线。
How to Remove Gridlines in Excel
Gridlines in Microsoft Excel mаke it easier to view your data. However, you can disable thesе gridlines if you dоn’t want to use them while making spreadsheets. There are multiple ways to remove gridlines in Excel.
You can hide them, fill them with white to make them disappear into the page, or create a template that uses no gridlines.
Quickly Remove Gridlines in Excel
Microsoft Excel has an option that defines whether or not gridlines appear in your spreadsheets. You can disable this option to hide gridlines in your Excel spreadsheets.
This method works on a per-worksheet basis, which means you’ll have to perform these steps for each worksheet to remove gridlines.
- Open your spreadsheet with Microsoft Excel on your Windows or Mac computer.
- Select the worksheet you want to remove gridlines from at the bottom of the spreadsheet.
- Select the Page Layout tab at the top of the Excel interface.
- Deselect the View box in the Gridlines section.
Immediately, Excel will hide all gridlines in your current worksheet. If you’d like to bring gridlines back, enable the View box in the Gridlines section.
Change the Gridline Color to Remove Gridlines in Excel
Another way to remove gridlines from an Excel worksheet is by changing the gridlines’ color. By default, Excel uses the grey color for gridlines. If you change this to white, your gridlines will automatically disappear.
Again, this option works on a per-worksheet basis, which means you’ll have to follow these steps for each of your worksheets to remove gridlines.
- Launch your spreadsheet with Microsoft Excel.
- Select the worksheet you want to remove gridlines from.
- Select File at the top-left corner of Excel and then choose More > Options from the left sidebar.
- Choose Advanced from the left sidebar on the Excel Options window.
- Scroll down the right pane to the Display options for this worksheet section. Here, select the Gridline color option.
- Choose White in the color list.
- Select OK at the bottom of the window.
All gridlines should now be hidden in your current worksheet.
Apply a Fill Color to Remove Gridlines in Excel
You can fill the white color in your worksheet to make gridlines disappear. Later, if you change your mind, you can remove the fill color to get gridlines back.
- Open the worksheet you want to remove gridlines from.
- Select the cells you want to remove gridlines from. To remove gridlines from your entire worksheet, press Ctrl + A (Windows) or Command + A (Mac) to select your entire worksheet.
- Select the Home tab at the top of the Excel interface.
- Select the small down-arrow icon next to the bucket icon and choose the White color.
- Gridlines should now be removed from your worksheet.
To bring gridlines back, choose No Fill from the bucket icon menu.
Remove Gridlines From Specific Rows or Columns in Excel
If you’re looking to remove gridlines from specific rows or columns, use Excel’s Border option. This option allows you to remove gridlines from the selected area in your spreadsheet.
- Open the worksheet you want to hide gridlines in.
- Select the row or the column you want to remove gridlines from.
- Right-click the selected column or row and choose Format Cells from the menu.
- Select the Borders tab on the Format Cells window. Then, select the Color option and choose the White color.
- Choose Outline and then Inside in the Presets section. Then, select OK at the bottom.
Back on the worksheet screen, you’ll find gridlines from your selected area are now gone.
Always Keep Gridlines Removed in Excel
If you want to make your future spreadsheets without gridlines, create an Excel template that uses no gridlines by default. Then, any spreadsheets that you base on this template will have no gridlines.
To make this template:
- Open Excel and select Blank workbook to create a new workbook.
- On the editing screen, select the Page Layout tab at the top.
- Deselect the View option in the Gridlines section. This’ll disable gridlines in your current worksheet.
- Save your workbook as an Excel template by selecting File > Save As.
- Choose Excel Template from the Excel Workbook dropdown menu.
- Enter a name for your template (something like Gridline Free) and select Save.
- To use this template to make spreadsheets, open Excel, select New > Personal, and select your template in the list. This will create a workbook without gridlines.
Print Gridlines in Excel
By default, gridlines aren’t printed when you print an Excel spreadsheet. If you’d like to print gridlines, enable an option in the Excel app.
- Launch your spreadsheet with Microsoft Excel.
- Select the Page Layout tab at the top of the Excel interface.
- Enable the Print option in the Gridlines section.
- Press Ctrl + P (Windows) or Command + P (Mac) to open the print screen. You’ll notice the print preview shows gridlines, which means your gridlines will be printed when you print your spreadsheet.
- To disable printing gridlines, turn off the Print option in the Gridlines section.
Getting Rid of Gridlines From Excel Spreadsheets
While gridlines make arranging data in your Excel spreadsheets easier, you don’t always have to use them. For the occasions when you don’t need gridlines, the methods above should help you remove gridlines from your Excel spreadsheets.