Forum Tips and Tricks Computer TricksSOME KEYBOARD SHORTCUTS:

SOME KEYBOARD SHORTCUTS:

Ctrl + A - Select all Ctrl + N - Gras Ctrl + C - Copier Ctrl + D - Fill Ctrl + B - Search Ctrl + G - Save Ctrl + L - replace Ctrl + K - Italian Ctrl + U - New Workbook Ctrl+End allows you to scroll to the end. Ctrl + P - Print Ctrl + R - Not good Ctrl + S - Underline Ctrl + V - Coller Ctrl W - Fermer Ctrl + X - Couper Ctrl + Y - repeat Ctrl + Z - Cancel F1 - Help F2 - Edition F3 - Paste the name F4 - repeat last action F4 - When understanding a formula, go between absolute/relative references F5 - Get At F6 - Next panel F7 - Spelling Checker F8 - Amplifying Fashion. F9 - Recalculate all the books F10 - activate menu bar F11 - New Graphics F12 - Save Under Ctrl +: - Insert current time Ctrl +; - Insert the current date. Ctrl + "- copy the value of the cell above Ctrl + ' - Copy the formula of the above cell Change - Compensation setting for additional functions in the Excel menu Maj + F1 - What's it? Maj + F2 - Modify Cell Commentary Maj + F3 - Glue the function in the formula Maj + F4 - Next quest Shift + F5 - Research Maj + F6 - Previous panel Maj + F8 - Add to select Maj + F9 - Calculate the active spreadsheet Maj + F10 - Display contextual menu Maj + F11 - New Spreadsheet May + F12 - Save Ctrl + F3 - Set the name Ctrl + F4 - Fermer Ctrl + F5 - XL, restoration window size Ctrl + F6 - Window to the next workbook Maj + Ctrl + F6 - Previous workbook window Ctrl + F7 - Move the window Ctrl + F8 - Resize Windows Ctrl + F9 - Minimize Workbook Ctrl + F10 - Maximize or restore the window Ctrl + F11 - Insert Macrosheet 4.0 Ctrl + F1 - open file Alt + F1 - Insert diagram Alt + F2 - Save Under Alt + F4 - Output Alt + F8 - macro dialogue box Alt + F11 - Basic Visual Editor Alt + 64 - @ CTRL + Esc. You can quickly return to the home screen. And nothing happened here. Ctrl + Maj + F3 - Create a name using line and column tag names Ctrl + Maj + F6 - Previous window Ctrl + Maj + F12 - Impression Alt + Maj + F1 - New Spreadsheet Alt + May + F2 - Record Alt + = - AutoSum Ctrl + `- Modify the formula value / display Ctrl + Maj + A - Insert argument names into the formula Alt + arrow down - aut Ohmatic watchlist Alt + ' - Style Dialogue Format Ctrl + Maj + ~ - General Format Ctrl + Maj +! - Format virgule Ctrl + Maj + @ - Time format Ctrl + Maj + # - Date Format Ctrl + Maj + $ - Format de devise Ctrl + Maj +% - Percentage Format Ctrl + Maj + ^ - Exponential Format Ctrl + Maj + & - Place the outline border around the selected cells Ctrl + Maj + _ - Remove contour border Ctrl + Maj + * - Select the current region Ctrl ++ - Insert Ctrl + - Delete Ctrl + 1 - Cell Dialog Box Format Ctrl + 2 - Gras Ctrl + 3 - Italian Ctrl + 4 - Highlight Ctrl + 5 - Barré Ctrl + 6 - Show/Hide s Ctrl + 7 - Show/Hide the standard toolbar Ctrl + 8 - Alternate plan symbols Ctrl + 9 - Hide the lines Ctrl + 0 - Hide the columns Ctrl + Maj + (- show lines Ctrl + Maj +) - show the columns Alt or F10 - activate menu Ctrl + Tab - In the toolbar: next Ohutils bar Maj + Ctrl + Tab - In the toolbar: Previous toolbar Ctrl + Tab - In a book: activate the next book Shift + Ctrl + Tab - In a safe: activate the previous folder Tab - Next Tool Shift + Tab - Previous Tool Walk in - Order up Maj + Ctrl + F - Font Dropdown List Maj + Ctrl + F + F - Cell Dialog Box Format Source Tab Maj + Ctrl + P - Dropdown list of dot size. For those who work on computers. THE 10 BASIC KEYBOARD SHORTCUTS ON WINDOWS These mythical shortcuts work on all versions of Windows. Due to their popularity, they are also available on many desktop software. Ctrl+C : copier Ctrl+X : couper Ctrl+V : coller Ctrl+Z : cancel Ctrl+Y: recover Ctrl+A: select all Ctrl+P : print F1: show the assist Ctrl+Alt+Suppr: to open the task manager or lock the computer Windows or Ctrl+Echap: open start/switch menu on desktop (Wind Oh ws) A/ THE WINDOW SHORTCUTS MOST USED BY PROFESSIONALS: To improve your productivity at work, you can use these keyboard shortcuts. Ctrl+Mouse Roulette: to zoom/unzoom. Windows+P: to change display mode (handy with a rearview mirror): disconnect the rearview mirror, duplicate, expand, or rearview only. Windows+F: to launch a quick search on a computer Windows+Maj+Click: to launch a new instance of a program. Example: Click the Microsoft Word icon on your task bar to open a new . Windows+L: a keyboard shortcut to locking your computer. Ctrl+Left/right arrow: to place the cursor at the beginning of the word or the next word. Shift+Left/right arrow: to select text. Ctrl+shift+left/right arrow: to select an entire word. Ctrl+Backspace: to delete an entire word. Ctrl+F4: to close a window. Or a computer, if no window is open. Windows+E: a keyboard shortcut to display the workstation. Maj to inserting a CD: this shortcut prevents automatic play. Ctrl+Windows+F: to search for a computer on a network. Escape during a process: to undo the ongoing process (transfer, copy... ). Ctrl+Maj+Click: to open a program as an administrator. B/ WINDOWS KEYBOARD SHORTCUTS FOR MANAGEMENT: Windows working on windows....... Hence his name. There are many keyboard shortcuts to switch from one window to another or hide them easily. Alt+Tab: Switching from window to window. Hold the Alt key down and tap the Tab key once or more to access the window of your choice. Alt + shift + tab: switch from window to window (in the reverse order). This time, you need to hold the Alt and Shift keys, and press the Tab button once or more. Windows+Tab: same principle as Alt+Tab, but in a more visual form. Works on Windows 7 when Aero is supported. Windows+D: hide all windows. Practical to briefly display the office. Just press n Ohuveau on the Windows+D keys to retrieve the windows. Windows+down arrow: if the window occupies the whole screen (enlarged window), it returns to a classic size. A second click on Windows+down arrow minimizes the window. Windows+Upward arrow: a keyboard shortcut to enlarge the active window. Windows+Left arrow: to place the window on the left half of the screen. Windows+Arrow to the right: to place the window on the right half of the screen. Windows+Shift+Right or left arrow: allows you to move a window from one screen to another. This keyboard shortcut only works if you are using multiple screens. C/ OTHER WINDOW SHORTCUTS TO KNOW: Ctrl+N: open a new window. F5 or Ctrl+R: update the active window. Ctrl+Maj+Echap: Displays the task manager, which allows you to close an app, view your PC's processes or performance in real time. Ctrl+click: to select several items (files or folders, for example). Shift+click: to select all items included between the first and second click. Works with text, files and folders, and can be combined with Ctrl+click. Maj (5 times): to deactivate (or activate) the remaining keys. Alt+Maj: to iron the keyboard in French, if by chance your keyboard has changed to English. This shortcut only works with the Alt left key, and if multiple languages are activated. Maj+Delete: to delete a file or folder permanently. N. B: As this list is not exhaustive, please complete the list or give your feedback if you have any suggestions.

Replies 0

No comments yet