Ads (728x90)

Latest Post

Kesehatan

Tips





F2 Edit the selected cell.

F5 Go to a specific cell. For example, C6.

F7 Spell check selected text or document.

F11 Create chart.

Ctrl + Shift + ; Enter the current time.

Ctrl + ; Enter the current date.

Alt + Shift + F1 Insert New Worksheet.

Shift + F3 Open the Excel formula window.

Shift + F5 Bring up search box.

Ctrl + A Select all contents of the worksheet.

Ctrl + B Bold highlighted selection.

Ctrl + I Italic highlighted selection.

Ctrl + K Insert link.

Ctrl + U Underline highlighted selection.

Ctrl + 5 Strikethrough highlighted selection.

Ctrl + P Bring up the print dialog box to begin printing.

Ctrl + Z Undo last action.

Ctrl + F9 Minimize current window.

Ctrl + F10 Maximize currently selected window.

Ctrl + F6 Switch between open workbooks / windows.

Ctrl + Page up Move between Excel work sheets in the same Excel document.

Ctrl + Page down Move between Excel work sheets in the same Excel document.

Ctrl + Tab Move between Two or more open Excel files.

Alt + = Create a formula to sum all of the above cells

Ctrl + ' Insert the value of the above cell into cell currently selected.

Ctrl + Shift + ! Format number in comma format.

Ctrl + Shift + $ Format number in currency format.

Ctrl + Shift + # Format number in date format.

Ctrl + Shift + % Format number in percentage format.

Ctrl + Shift + ^ Format number in scientific format.

Ctrl + Shift + @ Format number in time format.

Ctrl + Arrow key Move to next section of text.

Ctrl + Space Select entire column.

Shift + Space Select entire row.

Post a Comment