excel中的常用技巧_在Excel中控制技巧

excel中的常用技巧

Last week I listed a few tricks with the Shift key in Excel, and in the comments, Jon Peltier mentioned a trick he'd discovered with the Ctrl key.

上周，我用Excel中的Shift键列出了一些技巧，在评论中， 乔恩·Perl捷 ( Jon Peltier)提到了他通过Ctrl键发现的一个技巧 。

Here are a few more things you can do with the Ctrl key in Excel. There are many other Ctrl tricks, so if you have favourites, please share them in the comments.

您还可以在Excel中使用Ctrl键来做一些其他事情。 还有许多其他Ctrl技巧，因此，如果您有收藏夹，请在评论中分享。

选择不相邻范围 (Select Nonadjacent Ranges)

This is my favourite use of the Ctrl key -- to select nonadjacent ranges. For example:

这是我最喜欢的Ctrl键用法-选择不相邻的范围。 例如：

1. Click on cell A1 to select it
   单击单元格A1将其选中
2. Press the Ctrl key, and click on cell A5, then click on cell B3
   按Ctrl键，然后单击单元格A5，然后单击单元格B3
3. Release the Ctrl key, and all three cells are selected, with B3 as the active cell.
   释放Ctrl键，并选择所有三个单元格，并以B3作为活动单元格。

在多个单元格中输入数据 (Enter Data in Several Cells)

After you've selected several cells, adjacent or nonadjacent, you can enter the same data or formula in all of them

选择多个相邻或不相邻的单元格后，可以在所有单元格中输入相同的数据或公式

1. Select the cells, and type the data or a formula.
   选择单元格，然后键入数据或公式。
2. Press the Ctrl key, then tap the Enter key, to enter the data or formula in all the selected cells
   按Ctrl键，然后按Enter键，以在所有选定的单元格中输入数据或公式

显示活动单元 (Show the Active Cell)

Sometimes I scroll to the bottom or far side of a worksheet, to view something, then want to get back to the active cell quickly.

有时，我滚动到工作表的底部或远端，以查看某些内容，然后想要快速返回到活动单元格。

• To show the active cell, press Ctrl + Backspace
  要显示活动单元格，请按Ctrl +退格键

选择优先单元 (Select Precendent Cells)

If you're analyzing a formula, you might want to go to the precedent cells -- those cells that are used in the current cell's formula.

如果要分析公式，则可能需要转到先前的单元格-当前单元格公式中使用的那些单元格。

• Select a cell with a formula that refers to other cells
  选择具有引用其他单元格的公式的单元格
• Press Ctrl + [
  按Ctrl + [

The first cell referenced in the formula will be the active cell, and other referenced cells on the same sheet will be selected.

公式中引用的第一个单元格将是活动单元格，并且将选择同一工作表上的其他引用的单元格。

翻译自: https://contexturesblog.com/archives/2008/07/22/controlly-tricks-in-excel/

excel中的常用技巧