• Good Excel Shortcut Key Tips from Xlteq the Excel Experts

  • Good excel tips

     

    Excel Shortcut Keys Tips for the Excel Experts

    Excel, like any great software, has many excellent keyboard shortcuts. Here are some of the best.


    Ctrl+; —Inserts today's date.
    Ctrl+Shift+:—Inserts the current time (the colon is what is in a clock reading, like 12:00).
    Ctrl+Shift+#—Changes the format of a date.
    Ctrl+5—Applies a strikethrough to the text in a cell.
    Ctrl+0— Hides the current column.
    Ctrl+9—Hides the current row.
    Ctrl+F6—Switches between open workbooks (that is, open Excel files in different windows).
    Ctrl+`—That's the accent mark, up by the 1 key. This combo toggles the view in the sheet to show all the formulas.
    Ctrl+PageUp or PageDown—Quick shift between the sheets in the currently open workbook.
    F2—Start editing the current selected cell (much faster than double-clicking).
    Shift+F10—Opens the right-click menu for the cell you're in.