Whatever you use, be it catia, solidworks, UG, NASTRAN,ANSYS ,PATRAN, HYPERMESH or any other CAE software, excel is one of the software tool that always be the one that will be come to you. Maybe for preparing some graphs or presenting the data from the analysis. For my work excel is tool that i use everyday ion my office. so today i would like to share some of 4 function key shortcuts of excel that has made my life easy.
F2 the second most used key for me. If you want to edit a cell value. This is the key to use. Instead of double clicking F2 comes handy to edit those long formulae's.
F7 spell checker. My spellings are bad, even in spread sheet I manage to get many spelling mistakes, so one click on F7 I the best that I can get.
F4 is the most versatile function key of excel. I use it the most. It repeats your last action. So this can be used for many task. Since there no fix action. so its programmable to use any action. If I have to delete a row. repeatedly. I select the row and then right click on it and choose delete. after than any row I want to delete I just choose that row and press F4. similarly if I have to clear lot of stuff from one sheet. I use the F4 key instead of right click and choosing clear contents multiple times.
F11. Most of the time my work in excel involves making graphs of the data and f11 comes to the rescue. just select the data and press F11. You will have the default graph plotted. Since I want a particular type of graph so I always make a default graph and use it every time I need a graph.
Do you have any shortcut keys then please do share it with me.
