WETHINKBLOGS

TECHNOLOG AND BLOGGING ARENA!

Breaking News

Breaking News: Hello did You know that emmy jiya is a Blogger, Thanks for being here.

Wednesday 13 February 2019

shortcuts of your computer


Ctrl+A - Select All 

Ctrl+B - Bold 

Ctrl+C - Copy 

Ctrl+D - Fill Down 

Ctrl+F - Find 

Ctrl+G - Goto 

Ctrl+H - Replace 

Ctrl+I - Italic 

Ctrl+K - Insert Hyperlink 

Ctrl+N - New Workbook 

Ctrl+O - Open 

Ctrl+P - Print 

Ctrl+R - Fill Right 

Ctrl+S - Save 

Ctrl+U - Underline 

Ctrl+V - Paste 

Ctrl W - Close 

Ctrl+X - Cut 

Ctrl+Y - Repeat 

Ctrl+Z - Undo 

F1 - Help 

F2 - Edit 

F3 - Paste Name 

F4 - Repeat last action 

F4 - While typing a formula, switch between absolute/relative refs 

F5 - Goto 

F6 - Next Pane 

F7 - Spell check 

F8 - Extend mode 

F9 - Recalculate all workbooks

F10 - Activate Menu bar 

F11 - New Chart 

F12 - Save As 

Ctrl+: - Insert Current Time 

Ctrl+; - Insert Current Date 

Ctrl+" - Copy Value from Cell Above 

Ctrl+’ - Copy Formula from Cell Above Shift - Hold down shift for additional functions in Excel’s menu 

Shift+F1 - What’s This? 

Shift+F2 - Edit cell comment 

Shift+F3 - Paste function into formula 

Shift+F4 - Find Next 

Shift+F5 - Find 

Shift+F6 - Previous Pane 

Shift+F8 - Add to selection 

Shift+F9 - Calculate active worksheet 

Shift+F10 - Display shortcut menu 

Shift+F11 - New worksheet 

Ctrl+F3 - Define name 

Ctrl+F4 - Close 

Ctrl+F5 - XL, Restore window size 

Ctrl+F6 - Next workbook window 

Shift+Ctrl+F6 - Previous workbook window 

Ctrl+F7 - Move window 

Ctrl+F8 - Resize window 

Ctrl+F9 - Minimize workbook 

Ctrl+F10 - Maximize or restore window 

Ctrl+F11 - Inset 4.0 Macro sheet 

Ctrl+F1 - File Open 

Alt+F1 - Insert Chart 

Alt+F2 - Save As 

Alt+F4 - Exit 

Alt+Down arrow - Display AutoComplete list 

Alt+’ - Format Style dialog box 

Ctrl+Shift+~ - General format 

Ctrl+Shift+! - Comma format 

Ctrl+Shift+@ - Time format 

Ctrl+Shift+# - Date format 

Ctrl+Shift+$ - Currency format 

Ctrl+Shift+% - Percent format 

Ctrl+Shift+^ - Exponential format 

Ctrl+Shift+& - Place outline border around selected cells 

Ctrl+Shift+_ - Remove outline border 

Ctrl+Shift+* - Select current region 

Ctrl++ - Insert 

Ctrl+- - Delete 

Ctrl+1 - Format cells dialog box 

Ctrl+2 - Bold 

Ctrl+3 - Italic 

Ctrl+4 - Underline 

Ctrl+5 - Strikethrough 

Ctrl+6 - Show/Hide objects 

Ctrl+7 - Show/Hide Standard toolbar 

Ctrl+8 - Toggle Outline symbols 

Ctrl+9 - Hide rows 

Ctrl+0 - Hide columns 

Ctrl+Shift+( - Unhide rows 

Ctrl+Shift+) - Unhide columns 

Alt or F10 - Activate the menu 

Ctrl+Tab - In toolbar: next toolbar 

Shift+Ctrl+Tab - In toolbar: previous toolbar 

Ctrl+Tab - In a workbook: activate next workbook 

Shift+Ctrl+Tab - In a workbook: activate previous workbook 

Tab - Next tool 

Shift+Tab - Previous tool 

Enter - Do the command 

Shift+Ctrl+F - Font Drop down List 

Shift+Ctrl+F+F - Font tab of Format Cell Dialog box 

Shift+Ctrl+P - Point size Drop down List 

Ctrl + E - Align center 

Ctrl + J - justify 

Ctrl + L - align 

Ctrl + R - align right 

Alt + Tab - switch applications 

Windows + P - Project screen 

Windows + E - open file explorer 

Windows + D - go to desktop 

Windows + M - minimize all windows 

Windows + S - search

No comments:

Post a Comment