If you can use F5 key in Excel, why work late at night
Xiao Li 2021-02-23 01:36:10
In the process of surfing the Internet , Directly by F5 Key can automatically refresh the page , That's in Excel in , What's the magic of this shortcut key ? In this issue, I'd like to share some usage with you .

Actually F5 The key in Excel It's the positioning function , And Ctrl+G Consistent function .

 If you can use it Excel Inside F5 key , Why work late at night


Let's take a look at the common usage of positioning function .


1、 Locating null values

Selected area , Press F5 Turn on the positioning conditions , choice 【 Null value 】, And then enter something like “\”, Press Ctrl+Enter The key combination ends .

 If you can use it Excel Inside F5 key , Why work late at night


2、 Quick delete comments

Hold down F5 Key to turn on the positioning function , choice 【 Comments 】, Then right click and select Delete comment .

 If you can use it Excel Inside F5 key , Why work late at night


3、 Positioning formula


If you want to see the formula quickly , The content with formula can be located first , Then click on the formula —— Show formula .

 If you can use it Excel Inside F5 key , Why work late at night


4、 Quick delete empty lines

This is also a null value , Then right click to delete the blank line .

 If you can use it Excel Inside F5 key , Why work late at night


5、 Quick delete pictures


If there are a lot of pictures or graphics in the table , At this time can be Ctrl+A Select the entire table , Press F5 Locate the object , Then press Delete Key to delete .

 If you can use it Excel Inside F5 key , Why work late at night


6、 Copy visible cells


Sometimes you just want to copy the data in the visible cells , At this time, you can also locate 【 visible cell only 】, Then copy and paste it .

 If you can use it Excel Inside F5 key , Why work late at night


PS:
To copy a shortcut to a visible cell, press Alt+;.



7、 Positioning condition format

Want to see which part of the table uses conditional formatting ?

In this case, you can select the area , Press F5 Key to open the positioning condition , Then select the conditional format to confirm .


 If you can use it Excel Inside F5 key , Why work late at night

8、 Find row content differences

Selected area , Turn on the positioning condition function , Then select... In the open interface 【 Row content difference cell 】, Click ok .

PS: To find the difference in line content, press Ctrl+\, To find the column content difference, press Ctrl+Shift+\


 If you can use it Excel Inside F5 key , Why work late at night

版权声明
本文为[Xiao Li]所创,转载请带上原文链接,感谢
https://fheadline.com/2021/02/20210222185708741E.html
相似文章

2021-08-09