MS Excel Editing Tips and Tricks

 

Most of us work on excel. Data entry using excel in cell at times becomes very tedious and therefore most of us prefer word when it come to editing text for the data entry. There are several quick tips and tricks available to make one’s life easy while working with MS Excel for data entry and manipulation…

Task / Objective	Shortcut / Key Sequence
New Workbook	[Ctrl] + [N]
Edit Current Cell	[F2]
Enter multiple lines of data with line breaks the way you can type in MS Word Tables. To insert carriage return use..	[Alt] + [Enter]
Wrapping Text enter in the cell	[Ctrl] + [1] + {Click Alignment Tab} + {Wrap Text}
Change Relative Cell Ref (e.g. A1) to Absolute ref. (e.g. $A$1, A$1,$A1). Relative references change when copying data from one cell to another. Absolute reference do not change.(Toggle Key)	[F4]
Toggle between Show Formula Mode/Normal Mode.	[Ctrl] + [`]
Close Current Workbook. Will prompt to save before closing in case of unsaved changes	[Ctrl] + [w] / [Ctrl] + [F4]
Create Table and Set filters on table headers	[Ctrl] + [L] Or [Ctrl] + [T]
Insert Hyperlink Dialog	[Ctrl] + [K]
Auto Sum	Alt + [-]
Current Date	[Ctrl] + [;]
Current Time	[Ctrl] + [:]
Complete Formula with parenthesis and parameters	[Ctrl] + [Shift] + [A]
Delete Selected Cell	[Ctrl] + [-]
Insert Blank Cell	[Ctrl] + [Shift] + [=] or [Ctrl] + [+]
Insert Cut Cells above current selection	[Ctrl] + [Shift] + [=] or [Ctrl] + [+]
Insert Copied Cells above current selection	[Ctrl] + [Shift] + [=] or [Ctrl] + [+] Select appropriate option and click ok
Copy data from Cell above current selection	[Ctrl] + [']
Copy data from Cell above current selection along with formatting	[Ctrl] + [d]
Copy Contents from Cell to the Left of current selection	[Ctrl] + [R]

Happy Editing… Cheers

I hope you found the information useful and Thank you for reading.