课程: Excel Tips Weekly

免费学习该课程！

今天就开通帐号，23,100 门业界名师课程任您挑！

Quick number formatting with keystroke shortcuts and icon buttons

Quick number formatting with keystroke shortcuts and icon buttons - Microsoft Excel教程

课程: Excel Tips Weekly

开始一个月试用 购买团队方案

Quick number formatting with keystroke shortcuts and icon buttons

“

- Excel has a number of keystroke shortcuts for changing numeric formats. And we see them listed on this worksheet in two ways over in columns N through T. We see that by using control shift and then one of those six number keys or the key to the left of the number one. we can apply different kinds of formats. Also in the green panel below you'll see them listed in a slightly different way. Sometimes you encounter these keystroke shortcuts on the web or somebody tells you this one or that one. If you say, control shift three, that's the same as saying control shift hashtag or pound sign as you prefer. Control shift one, the same as control shift, exclamation point. We're talking about the same kinds of keystroke shortcuts here. Now, also available to us are some buttons on the home tab and the number group. And if I want to format the data in columns B and C and column D the same. I might want to use the comma…

内容