Merging cells is often used when a title is to be centered over a particular section of a spreadsheet. When a group of cells is merged, only the text in the upper-leftmost box is preserved.   Types of Merge cells […]

When you copy a cell’s contents, formula or format, that information goes into the clipboard. The clipboard will hold the information until you decide to paste it somewhere else on the spreadsheet, or until you copy something new. Usually, the […]

Function keys F1 F1 alone displays the Excel Help task pane. Ctrl+F1 displays or hides the ribbon. Alt+F1 creates an embedded chart of the data in the current range. Alt+Shift+F1 inserts a new worksheet. F2 F2 alone edit the active […]

Excel’s Flash Fill is a time-saving feature which fills in data for you when a pattern is evident. It can also can extract and insert as well as format and concatenate. This feature can even reverse text, numbers, dates and […]

To format any selected object, press ctrl+1 To insert current date, press ctrl+; To insert current time, press ctrl+shift+; To repeat last action, press F4 To edit a cell comment, press shift + F2 To autosum selected cells, press alt + = To see the suggest […]