即使您有一个很大的电子表格，有时您也可能只想在 Google 表格或 Microsoft Excel 中打印选定的单元格^{(print only selected cells in Google Sheets or Microsoft Excel)}。有一些内置选项可让您快速完成。借助此分步指南，您可以仅自定义和打印Excel和Google 表格^{(Google Sheets)}中的特定单元格选择。

如果您使用Google 表格^{(Google Sheets)}或Microsoft Excel中的默认设置或选项，它将打印整个活动电子表格。现在，让我们假设您有一个包含大量数据的大型电子表格，但由于任何原因您只需要打印一些行和列。这些行和列可以放置在电子表格中的任何位置。

两种工具都有相似的选项，但它们的名称不同。换言之，无需在Google Sheets或Microsoft Excel中安装插件。

如何在Excel中打印选定的单元格^(Excel)

要在Excel^(Excel)中打印选定的单元格，请按照下列步骤操作：

1. 打开Excel电子表格并选择所有单元格。
2. 按 Ctrl+P 打印。
3. 从列表中选择打印选择。^(Print)
4. 自定义工作表并打印。

如果您使用的是Microsoft Excel^{(Microsoft Excel)}，则需要打开并选择所有要打印的单元格。选择后，按Ctrl+P 快捷键打开打印^(Print)提示。从这里，您需要展开Print Active Sheets下拉菜单并选择Print Selection选项。

现在您可以进行其他更改并打印电子表格。

如何在Google表格中打印选定的单元格

要打印Google 表格^{(Google Sheets)}中的选定单元格，请按以下步骤操作：

1. 在Google 表格^{(Google Sheets)}中打开电子表格并使用鼠标选择所有单元格。
2. 按打印按钮。
3. ^{(Choose Selected)}从列表中选择选定的单元格选项。
4. 自定义其他设置并打印电子表格。

您需要在Google 表格^{(Google Sheets)}中打开电子表格才能开始学习本教程。之后，使用鼠标选择要打印的所有单元格。您可以单击单元格并拖动鼠标以根据需要选择所有内容。

之后，单击导航栏上可见的打印按钮。^{(Print )}File/Edit选项下获得图标。或者，您可以转到“文件^{(File )}”菜单并选择“打印^{(Print )}”选项。此外，您可以按Ctrl+P执行相同操作。

现在您可以在右侧找到一些选项。默认情况下，第一个选项是Current sheet。您需要展开该下拉列表并选择Selected cells选项。

在这里您可以看到您之前选择的单元格编号。之后，您可以自定义所有内容以相应地打印电子表格。

就是这样！希望能帮助到你。

How to print selected cells in Excel or Google Sheets on one page

Even if you haνe a big spreadsheet, somеtimes, you may want to print only selected cells in Google Sheets or Microsoft Excel. There are some in-built options that let you do it quickly. You can customize and print only a specific selection of cells in Excel and Google Sheets with the help of this step by step guide.

If you use the default settings or options in Google Sheets or Microsoft Excel, it will print the whole active spreadsheet. Now, let’s assume that you have a big spreadsheet with a lot of data, but you need to print only some rows and columns due to any reason. These rows and columns can be placed anywhere in your spreadsheet.

Both tools have similar options, but they carry different names. In other words, there is no need to install an add-on in Google Sheets or Microsoft Excel.

How to print selected cells in Excel

To print selected cells in Excel, follow these steps:

1. Open the Excel spreadsheet and select all cells.
2. Press Ctrl+P to print.
3. Select Print Selection from the list.
4. Customize the sheet and print it.

You need to open and select all the cells that you want to print, if you are using Microsoft Excel. After selecting, press the Ctrl+P shortcut to open the Print prompt. From here, you need to expand the Print Active Sheets drop-down menu and choose the Print Selection option.

Now you can make other changes and print the spreadsheet.

How to print selected cells in Google Sheets

To print selected cells in Google Sheets, follow these steps:

1. Open the spreadsheet in Google Sheets and use your mouse to select all cells.
2. Press the Print button.
3. Choose Selected cells option from the list.
4. Customize other settings and print the spreadsheet.

You need to open the spreadsheet in Google Sheets to get started with this tutorial. After that, use your mouse to select all the cells that you want to print. You can click on a cell and drag your mouse to choose everything as per your needs.

After that, click the Print button visible on the navigation bar. You should get the icon under the File/Edit options. Alternatively, you can go to the File menu and select the Print option. Also, you can press Ctrl+P to do the same.

Now you can find some options on your right side. By default, the first option would be the Current sheet. You need to expand that drop-down list and select the Selected cells option.

Here you can see the cell numbers as you selected earlier. After that, you can customize everything to print the spreadsheet accordingly.

That’s it! Hope it helps.

Related posts

• 如何在Excel and Google Sheets中显示Current Date and Time

• 如何在Excel and Google Sheets中创建下拉列表

• 如何使用Excel连接Google Sheets

• 如何在Excel and Google Sheets中制作弯曲的line graph

• 最好的Google Sheets and Excel Online Calendar templates

• 如何在Excel中使用Percentile.Exc function

• 如何在Microsoft Excel中提取URLs中的域名

• 如何在Excel and Google Sheets中设置Character limit

• 如何将数据从另一张表格导入 Google 表格

• 在没有Google Workspace subscription的情况下创建一个Google Sheets模板

• Google 表格与 Microsoft Excel – 有什么区别？

• 如何插入WordArt在Google Sheets使用Google图纸

• 如何在 Excel 中隐藏工作表、单元格、列和公式

• 如何使用NETWORKDAYS function在Excel

• Microsoft Excel正试图恢复您的信息

• 如何在Google Sheets Quickly Wrap Text？

• 14 个日常使用的实用 Google 表格模板

• 如何在Excel中使用Automatic Data Type feature

• 如何使用Macros自动化Google Sheets中的任务

• 如何分割Text给Columns在Excel and Google Sheets