如今,人们正在快速转向触摸界面,但对于某些类型的工作来说,键盘绝对是必不可少的。如果您使用Microsoft Excel进行一些繁重的数字运算,那么毫无疑问,好的键盘不是可选的。
然而,它不仅仅是数据输入的完美设备。您的键盘实际上可以让您成为Excel 功夫(Excel Kung Fu)大师,让您更快、更高效。如何?通过使用键盘快捷键。
应用程序的真正优点一直是那些记住了最重要的键盘快捷键的人,因此他们可以像经验丰富的音乐家一样使用该应用程序。Excel也不例外,一旦您了解了典型用例的最常用快捷方式,您就可以期望更快地完成工作。
调整行高和列宽是每个Excel用户都必须做的事情。这意味着,如果您要开始使用Excel 键盘侠之路,那么在(Excel keyboard)Excel中使用键盘快捷键来设置行高或列宽是一个完美的起点。
ALT 键的魔力(The Magic Of The ALT Key)
大多数用户不费心学习键盘快捷键的主要原因是因为传统上你必须背诵一大堆。这可能就是为什么看着一个有经验的键盘快捷键用户津津有味地攻击电子表格会感觉像Voodoo的原因。
微软只用一个小按钮(Microsoft)ALT就完全解决了这个问题。
我们使用的是Excel 365,如您所见,点击ALT按钮会弹出许多小工具提示。每一个都代表您可以按下以访问相应功能的下一个字母。因此,您完全不必担心完美地记住这些快捷方式。一旦您练习了几次,这些快捷提示将始终有助于提醒您下一步该做什么。
您现在所需要知道的是,Excel的每个键盘快捷键都以轻按ALT键开始。
自动调整列宽(Autofit Column Width)
使用鼠标自动调整列宽的经典方法是双击列标题边框,但您实际上可以使用键盘来完成,这通常更快。
显然,您需要选择要自动调整列宽的单元格。完成后,这是调整列宽的最快方法。问题是列宽的文本太多。让我们解决这个问题!
- 首先,按 ALT(press ALT )将Excel置于快捷方式模式。然后按 H 键(hit the H key )切换到主页选项卡。
- 最后,按 O ,然后按 I(press O and then I)。
很(Pretty)容易吧?我们也可以对行高做类似的事情!
自动调整行高(Autofit Row Height)
使用键盘自动调整行高的方法实际上是相同的。事实上,Excel中行高的键盘快捷键仅一次击键不同。
- 首先,按 ALT(press ALT )将Excel置于快捷方式模式。然后按 H 键(hit the H key )切换到主页选项卡。
- 最后,按 O ,然后按 A(press O and then A)。
这将调整行高以匹配行中最高的单元格。工作(Job)完成!
手动行高和列宽调整快捷键(Manual Row Height & Column Width Adjustment Shortcuts)
虽然自动调整单元格的快捷方式非常有用,但有时您需要微调电子表格中单元格的确切尺寸。
如您所料,您可以使用键盘快捷键访问显示相关数字的设置。
- 要手动调整行高,请按 ALT(press ALT )将Excel置于快捷方式模式。然后按 O 键(hit the O key )访问Excel 365的旧菜单选项。
- 现在,按 R 然后 E(press R and then E)。
- 你会看到这个对话框弹出当前高度值。将其更改为您喜欢的任何内容,然后按 Enter(hit Enter)将其锁定。
- 要手动调整列宽,请按 ALT(press ALT )使Excel进入快捷模式。然后按 O 键(hit the O key )访问Excel 365的旧菜单选项。
- 现在,按 C ,然后按 W(press C and then W)。
- 同样,您将获得这个小窗口,可让您输入所需的确切列宽。选择任何一个让你感到温暖和模糊的数字。
就是这样!现在您是单元格高度和宽度的真正大师。无需鼠标,只需要键盘作为武器。
西方最快的 Excel 枪(The Fastest Excel Gun In The West)
在自己尝试了这些键盘快捷键之后,您可能会同意使用鼠标既是文字拖动也是比喻拖动。当然,这似乎(seems )更容易,但是只要有一点肌肉记忆,您就可以立即根据您的确切要求调整行高和列宽。一旦你走键盘路径,就很难回头。
请务必查看我们的其他Excel 教程(Excel tutorials),以了解其他有用的键盘快捷键和令人惊叹的Excel 提示和技巧(Excel tips and tricks),如果没有您将无法了解如何生活。
Use the Keyboard to Change Row Height and Column Width in Excel
These days people are moving over to touch interfaces at a rapid pace, but for certain tyрes of work a keуboard іs absolutely essential. If you are using Microsoft Excel to do some heаvy number crunching, there’s no question that a good keyboard is not an optional extrа.
However, it’s not just the perfect device for data entry. Your keyboard can actually turn you into a master of Excel Kung Fu, making you faster and more efficient. How? By using keyboard shortcuts.
The real pros for an application have always been those who have memorized the most important keyboard shortcuts, so they can work that application like a seasoned musician. Excel is no different and once you know the most common shortcuts for your typical use case, you can expect to get things done much more quickly.
Adjusting row height and column width is something every Excel user has to do. Which means if you’re going to start down the road of Excel keyboard warrior, using a keyboard shortcut for row height or column width in Excel is the perfect place to start.
The Magic Of The ALT Key
The main reason most users don’t bother learning keyboard shortcuts is because traditionally you have to learn a whole bunch of them by heart. That’s probably why watching an experienced keyboard shortcut user attack a spreadsheet with gusto can feel like Voodoo.
Microsoft have taken this problem completely out of the equation with just one little button – ALT.
We’re using Excel 365 and as you can see, hitting the ALT button makes numerous little tooltips pop up. Each of these represents the next letter you can press to access the corresponding function. So you don’t have to worry about perfectly memorizing these shortcuts at all. Once you’ve practiced them a few times, these shortcut prompts will always help remind you of what to do next.
All you have to know right now is that every keyboard shortcut for Excel starts with a simple tap of the ALT key.
Autofit Column Width
The classic way to automatically fit column width with the mouse, is to double-click the column header border, but you can actually do it using the keyboard, which is generally faster.
Obviously, you need to have the cell selected for which you want to automatically adjust the column width. Once you’ve done that, here’s the fastest way to adjust the column width. The problem is there is too much text for the column width. Let’s fix that!
- First, press ALT to put Excel into shortcut mode. Then hit the H key to switch to the Home tab.
- Finally, press O and then I.
Pretty easy right? We can do something similar for row height as well!
Autofit Row Height
The method to automatically adjust row height with the keyboard is practically identical. In fact, the keyboard shortcut for row height in Excel differs by just a single keystroke.
- First, press ALT to put Excel into shortcut mode. Then hit the H key to switch to the Home tab.
- Finally, press O and then A.
This will adjust the row height to match the tallest cell in the row. Job done!
Manual Row Height & Column Width Adjustment Shortcuts
While the shortcuts for automatic cell adjustment is incredibly useful, sometimes you’ll want to fine-tune the exact dimensions of the cells in your spreadsheet.
As you might expect, you can use keyboard shortcuts to access the settings that expose the numbers in question.
- To manually adjust row height, press ALT to put Excel into shortcut mode. Then hit the O key to access Excel 365’s legacy menu options.
- Now, press R and then E.
- You’ll see this dialogue box pop up with the current height value. Change it to whatever you like and hit Enter to lock it in.
- To manually adjust column width, press ALT to put Excel into shortcut mode. Then hit the O key to access Excel 365’s legacy menu options.
- Again, you’ll get this little window that lets you put in the exact column width you desire. Choose whichever number makes you feel warm and fuzzy inside.
That’s it! Now you are a true master of the height and width of your cells. Without the need for a mouse, armed with nothing but a keyboard as your weapon.
The Fastest Excel Gun In The West
After trying out these keyboard shortcuts yourself, you’ll probably agree that using the mouse is both a literal and figurative drag. Sure, it seems easier, but with a little muscle memory you can tweak your row heights and column widths to your exact requirements at a moment’s notice. Once you walk the keyboard path, it’s hard to ever turn back.
Be sure to check our other Excel tutorials to learn about other useful keyboard shortcuts and amazing Excel tips and tricks you won’t know how you lived without.