A) F4: We can use F4 key in two different ways,below are the steps to use F4 key for reference: In Excel we have entered formula and the references we want to make it absolute; Edit in the formula cell; Select the formula references which we want to freeze; And then press the key F4. Note: It repeats the last performed action also. If your Excel sheet is full of color you might want to master this section of keyboard shortcuts. Ctrl + B – Bold. Ctrl + I – Italics. Alt + H + B + P – Top Border *for adding lines. Alt + E + S + F – Paste Formula (after Ctrl + C ) * F4 repeats the same action to other cells after pasting once.
The F4 key in Excel for Windows is normally a shortcut key to Repeat the last command. In Excel for Mac the F4 key is assigned to the Pastecommand, which is driving me crazy so I decided to do something about it. Default Excel F4 Keyboard Assignment in Excel for Mac There are four keyboard shortcuts assigned to the Paste command in Excel for Mac — Shift+Del, Control+V, F4, and Command+V. Overkill, don’t you think? So I’m thinking the F4 button can be reassigned with no problems, unless, of course, you’re in the habit of using the F4 key for the Paste command.
Reassign the F4 button in Excel for Mac. Select the Tools menu, and click Customize Keyboard. In the Categories: box select Edit. In the Edit box, select Redo. Select the Press new shortcut key: box.
![]() ![]()
Press the keyboard combination fn+F4 key (or just F4 key if you’ve ). Click Add. Click OK to reassign the Paste command to the Redo command.
Comments are closed.
|
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |