Shulou(Shulou.com)11/24 Report--

The original title: "after learning Excel for so many years, can you really use Ctrl+Shift?" "

Hello, everyone! I am a lovely book that is frantically waiting for manuscript.

Recently, I have seen that colleagues in the company are often asked to change the cell format, such as time format, date format, currency format and percentage format.

In general, in this case, I believe your first idea must be to modify the cell format under the start tab.

Although this method is not slow, but this small problem, shortcut keys, it is not fragrant.

❶ [Ctrl+Shift+1]: rounded.

❷ [Ctrl+Shift+2]: time format.

❸ [Ctrl+Shift+3]: date format.

❹ [Ctrl+Shfit+4]: currency format.

❺ [Ctrl+Shfit+5]: percentage format.

❻ [Ctrl+Shfit+6]: scientific counting.

❼ [Ctrl+Shfit+7]: add a bounding line.

How's it going? Do you remember everything?

With the proper use of these shortcuts, I believe your job will be easier!

This article comes from the official account of Wechat: Akiba Excel (ID:excel100), by the witty Qiu Xiao E, edited by Chang Xiaoan and Zhu Lan.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.