Juggle your spreadsheets on the iPad with our guide to the Excel app.
How to use shortcut to quickly insert/delete comment in active cell?
While you inserting or deleting a comment in a cell, most of you may use the right-click menu to solve the job, but do you know there are some shortcuts that can quickly handle the task in fact? In this article, I will tell you how to use a shortcut to insert, edit or delete the comment in the active cell.
Add or delete comment in Windows systemAmazing! Using Efficient Tabs in Excel Like Chrome, Firefox and Safari!Save 50% of your time, and reduce thousands of mouse clicks for you every day!
Add or Edit comment by shortcut
Select the cell which you want to add or edit its comment, press
Shift + F2
Delete comment by shortcut
Select the cell which you want to remove its comment, press
Shift + F10 then press
M
Add or delete comment in Mac system
If you use Mac system, you can do as below
Add or edit comment
Select a cell you want to add or edit its comment, and press
Fn + + F2
Delete comment
Select the cell you use, press
Fn + Shift
Open the context menu, and use arrows keys to select Delete Comment.
Relative Articles:The Best Office Productivity ToolsKutools for Excel Solves Most of Your Problems, and Increases Your Productivity by 80%
Office Tab Brings Tabbed interface to Office, and Make Your Work Much Easier
or post as a guest, but your post won't be published automatically.
Loading comment... The comment will be refreshed after 00:00.
How to disable F1 help key in Excel?
When you edit an Excel file, you may always use F2 key to edit the contents of a cell. But, you usually press F1 key instead, it will pop out the Helper dialog box. This may be very boring when you need to use the F2 key time and time again. In this article, I will introduce some quick methods to solve this problem.
Office Tab Enable Tabbed Editing and Browsing in Office, and Make Your Work Much Easier...
Kutools for Excel Solves Most of Your Problems, and Increases Your Productivity by 80%
Disable F1 help key temporarily with VBA codeAmazing! Using Efficient Tabs in Excel Like Chrome, Firefox and Safari!Save 50% of your time, and reduce thousands of mouse clicks for you every day!
With the following short code, you can quickly disable F1 key for the opened workbooks, but this code will be invalid after reopening the Excel file.
1. Hold down the ALT + F11 keys to open the Microsoft Visual Basic for Applications window.
2. In the opened window, please press Ctrl + G keys together to open the Immediate window, then copy and paste this code Application.OnKey '{F1}', ' into the Immediate box, and press Enter key on the keyboard. See screenshot:
Then close the code window, and now, when you press F1 key, the helper dialog box will not displayed any more.
Notes:
1. If you want to enable the F1 key, again, you can restart the Excel file, or you can also use this code: Application.OnKey '{F1}'as above procedure.
2. This code is applied successfully in Excel 2007/2010, but is not available in Excel 2013.
Disable F1 help key with VBA code
Except the above short code, you can apply the following code as well.
1. Hold down the ALT + F11 keys, and it opens the Microsoft Visual Basic for Applications window.
2. Click Insert > Module, and paste the following code in the Module Window.
VBA code: Disable F1 help key
3. Then press F5 key to run this code, and now, the F1 key has been disabled when you press F1 key.
Notes:
1. To enable the F1 key again, please use following code as the same steps as above.
VBAcode: Enable F1 help key
2. This code is applied successfully in Excel 2007/2010, but is not available in Excel 2013.
The Best Office Productivity ToolsKutools for Excel Solves Most of Your Problems, and Increases Your Productivity by 80%
Office Tab Brings Tabbed interface to Office, and Make Your Work Much Easier
or post as a guest, but your post won't be published automatically.
Loading comment... The comment will be refreshed after 00:00.
Comments are closed.
|
AuthorWrite something about yourself. No need to be fancy, just an overview. Archives
December 2022
Categories |