Lets start with very basics of MS Excel. I am pretty sure that if you use MS Excel, you might know all of these functions. I thought that too but still some of them were new for me when I saw them for first time. There’s no harm brushing up our memory. While there are more than one way to perform these tasks, I have given the most popular and easiest way below.
| Entering Data | Click on a cell and start typing |
| Deleting Cells | Select the cells you want to delete and press Del key on keyboard |
| Editing Cells | Select the cell and press F2 or double click on the cell |
| Move Cells | Select the cells you want to move, Right Click, Choose Cut. Select the cell where you want to move and right click and choose Paste |
| Copy Cells | Select the cells you want to move, Right Click, Choose Copy. Select the cell where you want to move and right click and choose Paste |
| Undo Changes | To cancel the last change you made, click on the Undo Button on Quick Access Bar |
| Redo Changes | To cancel the changes made by undo, Click on the Redo Button on the Quick Access Bar |
| Go To | Press F5 key |
| Find Text | Press Ctrl + F, Type the text you want to search for and click on Find Next |
| Find and Replace Text | Press Ctrl + F, then Alt + P. Type in the text you want to replace and the text you want it to replace with in the desired boxes and Click Replace |
| Saving Workbook | Ctrl + S or Click on Save on Quick Access Bar |
| Opening Workbook | Double Click the file in the folder |
| Closing Workbook | Alt + F4, or Goto File and select Close |
| Creating a New Blank Workbook | Ctrl + N |
| Inserting a new Sheet | Right Click on the status bar and Select Insert Worksheet |
| Deleting a Sheet | Right Click on Sheet you want to delete and select Delete |
| Moving Sheet | On the sheets tab, Drag and drop to new location |
| Copying Sheet | Right click on the sheet you want to copy and select copy |
| Renaming a Sheet | Double Click on Sheet Name and Edit it |
| Inserting a Row or Column | Right Click on the row or column aside which you want to insert new one. Select Insert. (Press F4 for repeating the function) |
| Deleting a Row or Column | Right Click on the Row or Column you want to delete, Select Delete |
| Hiding a Row or Column | Right Click on the Row or Column you want to Hide, Select Hide |
| Un-hiding a Row or Column | Right Click on the Row or Column you want to Unhide, Select Unhide |
| Change Row or Column width | Take your pointer between the row labels, where it shall turn into a double headed arrow, Click and drag, or double click to auto-fit |
Hope this helps.
Simply Rimmy 
Leave a comment