Pressing CTRL+A a second time selects the entire worksheet. If the worksheet contains data, CTRL+A selects the current region. I have compiled a list of essential keyboard shortcuts for Microsoft Excel 2010.ĬTRL+ : Enters the current date in the cell you are in.ĬTRL+Minus (-) : Displays the Delete dialog box to delete the selected cells.ĬTRL+` : Jump between displaying cell values and displaying formulas in the current worksheet.ĬTRL+’ : Just copies a formula from the cell above the active cell into the cell or the Formula Bar.ĬTRL+1 : The Format Cells dialog box will be displayed.ĬTRL+2 : Enable or removes the bold formats for the selected items.ĬTRL+3 : Enables or removes the italic formats for the selected items.ĬTRL+4 : Enables or removes underline for the selected items.ĬTRL+5 : Enables or removes strikethrough over the selected items.ĬTRL+6 : Jumps between hiding and displaying objects.ĬTRL+8 : Shows or hides the outline symbols.ĬTRL+9 : Selected rows are hidden from the view.ĬTRL+0 : Selected columns are hidden from the view.ĬTRL+A : Selects the entire worksheet.
It has become integral part of day to day office work.
Its hard to do calculation, estimation and charting without Microsoft Excel.
0 kommentar(er)
