If more than one cell is in the selection, the active cell will be highlighted in white, while the rest of the selection is highlighted in gray.

A selection is the active cell, or a group of cells currently selected.

An active cell is the cell currently selected by Excel.

A cell is any of the many boxes within the Excel spreadsheet.

In no time it will repair your file and then you can easily apply all the shortcuts.Before diving into the Excel shortcuts, it would be prudent to first discuss basic terminology around the elements of Excel. You have to download the software and upload the excel file. Try to repair it using an Excel Repair Tool. If you are facing any kind of error while applying shortcut then your Excel file is corrupted. Preparing the excel sheet then you will get used to it. It will be quite difficult to memorize the shortcut keys but once you start IĬan guarantee that these shortcuts will save a lot of time and energy. Well, I have told you the various shortcut keys in MS ExcelĢ013 and it is totally up to you to apply them according to the requirement.

Create Pivot Table Chart on the same Worksheet- Alt + F1.

Open Pivot Table Filed Checkbox- Space.

Apply Array Formula- Ctrl + Shift + Enter.Toggle Formula On or Off- Ctrl + ` “Grave mark”.Open Insert Function Dialogue Box- Shift + F3.Open Absolute and Relative References- F4.Move Active Cell to the left- Shift + Tab Key.Movement of Active Cell to the Right- Tab Key.Movement of Active Cell Upwards- Shift + Enter.Move Active Cell Downward in Selection- Enter.Move Active Cell Clockwise in Selection- Ctrl + Full Stop key.Show the active cell on the worksheet- Ctrl + Backspace.Leftwards Between Non-Adjacent Cells- Ctrl Rightwards Between Non-Adjacent Cells- Ctrl To the Last Cell of the Sheet- Ctrl + End Key. You May Also Read- Repair Excel File Manually Navigation Shortcuts Now, let’s move on to some more shortcut keys in MS Excel 2013. I am going to segment the shortcut keys according to theirįind and Replace and Replace Selected- Ctrl Many shortcuts which can help you to do your task easily.

So in this article, I’ll tell you various shortcut keys in MS Excel 2013 soĪnd mouse combination when you can do everything with the keys? So there are You if you know all the MS Excel shortcuts. MS Excel is mainly used for preparing tables and doing

Ms excel shortcut keys formulas