If you have relative cell reference in a cell, select the reference in the formula bar and press to convert it to absolute reference (i.e. SHIFT + CTRL + F3: Opens the 'Create Names' dialog box.į4: It repeats the last action. SHIFT + F3: Enables you to insert functions as required.ĬTRL + F3: Opens the 'Name Manager' dialog box in Excel 2007 and the 'Deﬁne Name' dialog box in Excel 2003. SHIFT + F2: Enables a user to add comments to a cell.ĪLT + F2: Displays the 'Save As…' dialog box which is used to save a ﬁle for the ﬁrst time.ĬTRL + F2: It displays the 'Print Preview' window in Excel 2007.

In 2003, it shows or hides the current task pane.ĪLT + F1: It creates a chart on the basis of the data selected in either versions of Excel.ĪLT + SHIFT + F1: Inserts a new sheet in the workbook. The operations in Office 20 are explained.į1: If used by itself the key opens the Excel help ﬁle irrespective of the application version.ĬTRL + F1: Either displays or hides the ribbon in Excel 2007. The shortcuts are divided in sections for your reference. Function keys are not often used, even by people who use keyboard shortcuts. Here is a list of Function key keyboard Shortcuts which can be used in MS-Excel. These simple yet essential keyboard shortcuts can come to your rescue at such times. There might be situations where you are in a hurry to complete your work, and are delayed especially when you heavily rely on the mouse to perform mundane yet essential tasks. Keyboard shortcuts are always best way to do your tasks quickly.

Microsoft excel shortcut keys 2003