What is f4 on mac for excel
Though same can be achieved by using CTRL + Y keys “F4” key has two different functionalities: - 1st is References (absolute, relative & mixed reference) & 2nd is It repeats the last performed action. Create Names from Selection window will open.Select the range for which you want to create the name.If you want to insert function then press the key Shift+F3.Note: - F3 will not work if there is no such defined named range We can paste name of the list that are already created.The creation of named range depends on user.Ī) F3: In Excel worksheet press the key F3 from Top row, Left column, Bottom row or Right column. You can create names for the selected cells from 4 options i.e. This will open the Create Names from Selection window & are used to create names from row or column labels. “Shift + F3” keys will open Insert function window which you can insert any function of your choice. Pressing “Ctrl + F3” keys together will open “Name Manager” dialog box refer below screenshot. F3 will not work if there is no such defined named range. “F3” key will help you to paste name of the list that are already created. In the worksheet press the keys Alt + Ctrl + Shift + F2.This key is also used for the print option.If you have not saved workbook yet, by pressing this key “Save As” dialog box will open.Select the cell where you wish to insert the comment.Where you can set the all criteria according to the requirement.If you want print a document, then press Ctrl+F2.Then you can save the file wherever required.If you want to save as your document, press the key Alt+F2.Note: - F2 key can be used in Formula bar also to edit the content, if editing is stop directly. In the Advanced Option, if you want to stop user from editing directly in excel cell then you can uncheck from the checkmark (Allow editing directly in cells) & if you want to allow editing the cell directly then make sure the checkmark is checked.These keys will open the print option same as “Ctrl + F2” keys.Ī) F2: In cell A1, we can directly make changes to the text by pressing F2 key.Īlso if you want to restrict the editing directly in cells follow below steps:. “Alt + Shift + F2” will save the active workbook, if not saved yet then it will open Save as dialog box. You can also edit the existing comment by pressing Shift + F2 keys for selected cell. Using Shift + F2 keys together will insert comment in the active cell. Pressing CTRL + F2 keys will open Print options If you press “Alt + F2” keys together the “Save As” dialog box will get open for saving the excel file. Tabs and Commands both will get hide from ribbon.Commands will get hide from the ribbon and only Main tabs will be visibleĮ) Ctrl + Shift + F1:- Below are the steps to use Ctrl+Shift+F1.Column chart will get created on the same sheet.Select the data for which we want to insert the chart.Excel help dialog box will appear, where we can take help regarding any Excel Query.This will maximize excel window if it is restore mode. Pressing Alt + Shift + F1 keys together will insert a new worksheet into the active workbook in which you are currently working. After minimizing the ribbon only tab names will get displayed on the ribbon. To minimize or maximize the ribbon of excel we can use “Ctrl & F1” keys together. Excel will open the default chart, this can be customize as per user requirement to open column chart, bar chart or any other chart by default. If you use “Alt and F1” Keys together then it will insert a new chart in excel workbook. Here, you can ask the question / query in the search box & inbuilt excel help will help you with the related articles. As you click on F1 key the excel help will get displayed. Let’s take a short tour on the significance of each Function Key and its usage. Later, two more were added and now we have 12 function keys. These are easy shortcuts, which make our usage of MS-Excel effortless.īefore 1984, only 10 function keys were used (F1 to F10). Function keys in combination with modifier (Ctrl, Alt, Shift) keysįunction keys act as predefined formulas in MS-Excel.Significance of Function keys in MS-Excel.