-

 Useful keyboard shortcuts.


Basics Keyboard Shortcuts

  • Ctrl+Z: Undo.
  • Ctrl+W: Close.
  • Alt+Tab: Switch apps.
  • Alt+F4: Close apps.
  • Win+left arrow or Win+right arrow: Snap windows.
  • Win+Tab: Open the Task view.
  • Tab and Shift+Tab: Move backward and forward through options.
  • Ctrl+Esc: Open the Start menu.
  • ctrl+shift+esc: Open Task manager.
  • Ctrl + A : Select all.
  • Ctrl + X : Cut.
  • Ctrl + B : Bold.
  • Ctrl + I : Italic.
  • Ctrl + U : Underline the Text.
  • Ctrl + N : New.
  • Ctrl + P : Print.
  • Ctrl + O : Open file.
  • Ctrl + S : Save.
  • Ctrl + Shift + S : Save As.
  • Ctrl + Y : Redo.

  • Window Logo Key ShortCut 
Windows logo keyOpen or close the Start menu
Windows logo key + PauseDisplay the System Properties dialog box
Windows logo key + DDisplay the desktop
Windows logo key + MMinimize all windows
Windows logo key + Shift + MRestore minimized windows to the desktop
Windows logo key + EOpen Computer
Windows logo key + FStart a Feedback dialog
Ctrl+Windows logo key + FSearch for computers (if you're on a network)
Windows logo key + LLock your computer or switch users
Windows logo key + ROpen the Run dialog box
Windows logo key + TCycle through programs on the Taskbar
Windows logo key + numberStart the program pinned to the Taskbar in the position indicated by the number. If the program is already running, switch to that program.
Shift+Windows logo key + numberStart a new instance of the program pinned to the taskbar in the position indicated by the number
Ctrl+Windows logo key + numberSwitch to the last active window of the program pinned to the Taskbar in the position indicated by the number
Alt+Windows logo key+ numberOpen the Jump list for the program pinned to the Taskbar in the position indicated by the number
Windows logo key + TabCycle through programs on the Taskbar by using Aero Flip 3-D
Ctrl+Windows logo key + TabUse the arrow keys to cycle through programs on the Taskbar by using Aero Flip 3-D
Ctrl+Windows logo key + BSwitch to the program that displayed a message in the notification area.
Windows logo key + VOpen the Clipboard app
Windows logo key + Up ArrowMaximize the window
Windows logo key + Left ArrowMaximize the window to the left side of the screen
Windows logo key + Right ArrowMaximize the window to the right side of the screen
Windows logo key + Down ArrowMinimize the window
Windows logo key + HomeMinimize all but the active window
Windows logo key + Shift + Up ArrowStretch the window to the top and bottom of the screen
Windows logo key + Shift + Left Arrow or Right ArrowMove a window from one monitor to another
Windows logo key + PChoose a presentation display mode
Windows logo key + GOpen the Game bar
Windows logo key + UOpen Ease Of Access Center
Windows logo key + XOpen the context menu for the Start button
Windows logo key +. or +;Open the Emojis window
Windows logo key + Ctrl + MOpen the Magnifier app


Microsoft Excel useful ShortCuts.

Ctrl + NCreate a new workbook.
Ctrl + OOpen an existing workbook.
Ctrl + SSave the active workbook.
F12Save the active workbook under a new name, displays the Save as dialog box.
Ctrl + WClose the active workbook.
Ctrl + CCopy the contents of the selected cells to Clipboard.
Ctrl + XCut the contents of the selected cells to Clipboard.
Ctrl + VInsert the contents of the Clipboard into the selected cell(s).
Ctrl + ZUndo your last action. Panic button :)
Ctrl + POpen the "Print" dialog.

Formatting data

Ctrl + 1Open the "Format Cells" dialog.
Ctrl + T"Convert selected cells to a table. You can also select any cell in a range of related data, and pressing Ctrl + T will make it a table.
Find more about Excel tables and their features.

Working with formulas

TabAutocomplete the function name. Example: Enter = and start typing vl, press Tab and you will get =vlookup(
F4Cycle through various combinations of formula reference types. Place the cursor within a cell and hit F4 to get the needed reference type: absolute, relative or mixed (relative column and absolute row, absolute column and relative row).
Ctrl + `Toggle between displaying cell values and formulas.
Ctrl + 'Insert the formula of the above cell into the currently selected cell or the Formula Bar.

Navigating and viewing data

Ctrl + F1Show / hide the Excel Ribbon. Hide the ribbon to view more than 4 rows of data.
Ctrl + TabSwitch to the next open Excel workbook.
Ctrl + PgDownSwitch to the next worksheet. Press Ctrl + PgUp to switch to the previous sheet.
Ctrl + GOpen the "Go to" dialog. Pressing F5 displays the same dialog.
Ctrl + FDisplay the "Find" dialog box.
HomeReturn to the 1st cell of the current row in a worksheet.
Ctrl + HomeMove to the beginning of a worksheet (A1 cell).
Ctrl + EndMove to the last used cell of the current worksheet, i.e. the lowest row of the rightmost column.

Entering data

F2Edit the current cell.
Alt + EnterIn cell editing mode, enter a new line (carriage return) into a cell.
Ctrl + ;Enter the current date. Press Ctrl + Shift + ; to enter the current time.
Ctrl + EnterFill the selected cells with the contents of the current cell.
Example: select several cells. Press and hold down Ctrl, click on any cell within selection and press F2 to edit it. Then hit Ctrl + Enter and the contents of the edited cell will be copied into all selected cells.
Ctrl + DCopy the contents and format of the first cell in the selected range into the cells below. If more than one column is selected, the contents of the topmost cell in each column will be copied downwards.
Ctrl + Shift + VOpen the "Paste Special" dialog when clipboard is not empty.
Ctrl + YRepeat (Redo) the last action, if possible.

Selecting data

Ctrl + ASelect the entire worksheet. If the cursor is currently placed within a table, press once to select the table, press one more time to select the whole worksheet.
Ctrl + Home then Ctrl + Shift + EndSelect the entire range of your actual used data on the current worksheet.
Ctrl + SpaceSelect the entire column.
Shift + SpaceSelect the entire row.

Comments

Post a Comment

Popular posts from this blog

PROJECT 3

-
  WHATSAPP MESSAGES BOT  import pywhatkit pywhatkit.sendwhatmsg("+91","MOBILE NO.","Hello", 16,40) SPEEDTEST BY PYTHON #pip i speedtest-cli from speedtest import Speedtest """ Ping (ms): ping of the test connection, in miliseconds d (Mb/s): d speed recorded, in megabits per second Upload (Mb/s): upload speed recorded, in megabits per second """ print("Checking...") st = Speedtest() #For Checking Upload and d dn = st.d() up = st.upload() print("Your d Speed====>",dn,"Kb/s") print("Your Upload Speed=======>",up,"Kb/s") #Now Convert Data into Megabits -- print("Your d Speed in Megabits====>",round(dn/10**6,2),"Mb/s") print("Your Upload Speed in Megabits=======>",round(up/10**6,2),"Mb/s") #Speed ====> 7Mb/s == 1MB/s #Now Convert  Data into MegaBytes--- print("Your d Speed in MegaBytes====>",(dn/10**6)/7,"...
Read more

Cascading Style Sheets(CSS)

-
        Cascading Style Sheets         programming language   Cascading Style Sheets is a style sheet language used for describing the presentation of a document written in a markup language like HTML. CSS is a cornerstone technology of the World Wide Web, alongside HTML and JavaScript.   CSS is designed to enable the separation of presentation and content, including layout, colors, and  fonts . This separation can improve content accessibility, provide more flexibility and control in the specification of presentation characteristics, enable multiple web pages to share formatting by specifying the relevant CSS in a separate .css file, and reduce complexity and repetition in the structural content. Separation of formatting and content also makes it feasible to present the same markup page in different styles for different rendering methods, such as on-screen, in print, by voice (via speech-based browser ...
Read more

SPEEDTEST PYTHON PROJECT

-
 #pip install speedtest-cli from speedtest import Speedtest """ Ping (ms): ping of the test connection, in miliseconds Download (Mb/s): download speed recorded, in megabits per second Upload (Mb/s): upload speed recorded, in megabits per second """ print("Checking...") st = Speedtest() #For Checking Upload and Download dn = st.download() up = st.upload() print("Your Download Speed====>",dn,"Kb/s") print("Your Upload Speed=======>",up,"Kb/s") #Now Convert Data into Megabits -- print("Your Download Speed in Megabits====>",round(dn/10**6,2),"Mb/s") print("Your Upload Speed in Megabits=======>",round(up/10**6,2),"Mb/s") #Speed ====> 7Mb/s == 1MB/s #Now Convert  Data into MegaBytes--- print("Your Download Speed in MegaBytes====>",(dn/10**6)/7,"MB/s") print("Your Upload Speed in MegaBytes=======>",(up/10**6)/7,"MB/s...
Read more