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.

Excel shortcut keys capital letters