ExcelHub - Learn Excel Easily

Excel Tip #028 Use of Function keys in Excel Most of us know few function keys that are used as shortcuts in Excel, but hardly make use of it. Either because of the keyboard settings or due to the scarcity of the knowledge. Below, the use of function keys are tabulated along with their combinations which will make your life much more easier. Function Key = F1 to F8 Function Key = F9 to F12 Try to use these Function key shortcuts in your day to day tasks and be benefited.

Excel Tip #009 Inserting and deleting cells, rows and columns There are ways inserting and deleting cells, rows and columns. Below are 3 methods (which I can recollect) in inserting (or) deleting rows and columns. Option 1 (Standard Procedure) : Selecting a row (or) column by clicking it, then right click for options. You can see options "Insert" and "Delete" . This will add a new row in the left (or) a new column in the top. Inserting/Deleting row (or) column - Option 1 (Standard Process) Option 2 (Unusual mouse method) : You can quickly insert a range of empty cells or rows by holding down the SHIFT key while dragging the fill handle.   To insert a range of cells, select a single cell above where you want the cells inserted and drag the fill handle down the number of cells you want to insert.  Inserting/Deleting row (or) column - Option 2 (Unusual mouse method) Inserting columns works basically the same way by dragging the Fill Ha...