Windows

Windows

Excel Shortcuts Cheat Sheet

27/04/2026 by 0 Comments

F Keys

F1 Displays the Office Assistant or (Help >Microsoft Excel Help)
F2 Edits the active cell, putting the cursor at the end
F3 Displays the (Insert > Name > Paste) dialog box
F4 Repeats the last worksheet action (Edit > Repeat)
F5 Displays the (Edit > GoTo) dialog box
F6 Moves to the next pane in a workbook (if the window is split)
F7 Displays the (Tools > Spelling) dialog box
F8 Toggles whether to extend a selection with the arrow keys
F9 Calculates All the worksheets in All the open workbooks
F10 Toggles the activation of the Menu Bar
F11 Displays the (Insert > Chart) dialog box that creates a chart (on a chart sheet) using the highlighted range
F12 Displays the (File > Save As) dialog box
Shift + F2 Inserts or edits a cell comment (Insert > Comment)
Shift + F3 Displays the (Insert > Function) dialog box
Shift + F4 Repeats the last Find, the same as (Edit > Find Next)
Shift + F5 Displays the (Edit > Find) dialog box
Shift + F6 Moves to the previous pane in a workbook (if the window is split)
Shift + F8 Toggles between switching Add Mode on or off*
Shift + F9 Calculates just the active worksheet
Shift + F10 Displays the (Shortcut) menu for the selected item
Shift + F11 Inserts a new worksheet (before the active sheet) into the active workbook (Insert > Worksheet)
Shift + F12 Saves, Displays the (File > Save As) dialog box if a new workbook
Ctrl + F1 Closes and reopens the current task pane (ribbon in 2007)
Ctrl + F2 Print Preview
Ctrl + F3 Displays the (Insert > Name > Define) dialog box
Ctrl + F4 Closes the selected workbook window
Ctrl + F5 Restores the size of the active workbook or window
Ctrl + F6 Moves to the next open workbook or window
Ctrl + F7 Activates the Move window command
Ctrl + F8 Activates the Resize window command
Ctrl + F9 Minimises the size of the active workbook or window
Ctrl + F10 Maximises the size of the active workbook or window
Ctrl + F12 Displays the (File > Open) dialog box
Alt + F1 Creates a chart (on a chart sheet) using the highlighted range
Alt + F2 Displays the (File > Save As) dialog box
Alt + F4 Closes all the workbooks (saving first) and exits Excel (File > Exit)
Alt + F8 Displays the (Tools > Macro > Macros) dialog box
Alt + F11 Toggles between the Visual Basic Editor window and and the Excel window
Alt + Ctrl + F9 Calculates All cells on All worksheets in All workbooks
Alt + Shift + F1 Inserts a new worksheet (before the active sheet) into the active workbook (Insert > Worksheet)
Alt + Shift + F2 Displays the (File > Save As) dialog box
Alt + Shift + F4 Closes all the workbooks (saving first) and exits Excel (File > Exit)
Alt + Shift + F10 Displays the drop-down menu for the corresponding smart tag
Alt + Shift + F11 Activates the Microsoft Script Editor window
Ctrl + Shift + F3 Displays the (Insert > Name > Create) dialog box
Ctrl + Shift + F6 Moves to the previous open workbook or window
Ctrl + Shift + F10 Activates the Menu Bar or Shortcut Characters in 2007
Ctrl + Shift + F12 Displays the (File > Print) dialog box

Ctrl Keys

Ctrl + 0 Hides the columns in the current selection
Ctrl + 1 Displays the formatting dialog box
Ctrl + 2 Toggles bold on the current selection
Ctrl + 3 Toggles italics on the current selection
Ctrl + 4 Toggles underlining on the current selection
Ctrl + 5 Toggles the strikethrough of text on the current selection
Ctrl + 6 Toggles between hiding, displaying
Ctrl + 8 Toggles the display of Outline symbols on the active worksheet
Ctrl + 9 Hides the rows in the current selection (Format > Row > Hide)
Ctrl + Shift + 0 Unhides the columns in the current selection
Ctrl + Shift + 2 Enters the value from the cell directly above into the active cell
Ctrl + Shift + 8 Selects the current region (surrounded by blank rows and columns)
Ctrl + Shift + 9 Unhides the rows in the current selection
Ctrl + A Displays formula palette given a function name or selects the whole worksheet or current date
Ctrl + B Toggles bold on the current selection
Ctrl + C Copies the current selection to the clipboard
Ctrl + D Copies the first cell in the selection downwards
Ctrl + E Flash Fill
Ctrl + F Displays the Find dialog box
Ctrl + G Displays the GoTo dialog box
Ctrl + H Displays the Replace dialog box
Ctrl + I Toggles italics on the current selection
Ctrl + K Displays the Insert Hyperlink dialog box
Ctrl + L Displays the Create Table dialog box
Ctrl + N Creates a new workbook
Ctrl + O Displays the Open dialog box
Ctrl + P Displays the Print dialog box
Ctrl + R Copies the leftmost cell in the selection to the right
Ctrl + S Saves, Displays the Save As dialog box if a new workbook
Ctrl + T Create table
Ctrl + U Toggles underlining on the current selection
Ctrl + V Pastes the entry from the clipboard
Ctrl + W Closes the active workbook or window
Ctrl + X Cuts the current selection to the clipboard
Ctrl + Y Repeats the last workbook action
Ctrl + Z Undo the last workbook action
Ctrl + Shift + F Activates the Font Tab of the format cells
Ctrl + Shift + O Selects all the cells with comments
Ctrl + Shift + P Activates the Font Size tab of the format cells

Enter Tab Alt Keys

Enter Enters the contents of the active cell and moves to the cell below (by default)
Shift + Enter Enters the contents of the active cell and moves to the cell above (by default)
Tab Enters the contents of the active cell and moves one cell to the right
Shift + Tab Enters the contents of the active cell and moves one cell to the left
Alt + = Enters the SUM() function (AutoSum) to sum the adjacent block of cells
Alt + 0128 Enters the euro symbol (€) (using Number keypad)
Alt + 0162 Enters the cent symbol (¢) (using Number keypad)
Alt + 0163 Enters the pound sign symbol (£) (using Number keypad)
Alt + Enter Enters a new line (or carriage return) into a cell
Ctrl + ‘ Enters the contents from the cell directly above into the active cell
Ctrl + Shift + 2 Enters the value from the cell directly above into the active cell
Ctrl + ; Enters the current date into the active cell
Ctrl + Shift + ; Enters the current time into the active cell
Ctrl + Shift + Enter Enters the formula as an Array Formula
Shift + Insert Enters the data from the clipboard
Alt + Down Arrow Displays the Pick From List drop-down list Esc Cancels the cell entry and restores the original contents
Alt

Delete Backspace Keys

Delete Deletes the selection or one character to the right
Backspace Deletes the selection or one character to the left
Shift + Delete Cuts the selection to the clipboard
Ctrl + Delete Deletes text to the end of the line
Ctrl + – Displays the Delete dialog box
Ctrl + Shift + = Displays the Cells dialog box

Selection Keys

Ctrl + \ Selects the cells in a selected row that do not match the value in the active cell
Ctrl + Shift + \ Selects the cells in a selected column that do not match the value in the active cell
Ctrl + / Selects the array containing the active cell ??
Alt + ; Selects the visible cells in the current selection
Ctrl + Shift + (8 or *) Selects the current region (surrounded by blank rows and columns)
Ctrl + * Selects the current region (using the * on the number keyboard)
Ctrl + [ Selects all the cells that are directly referred to by the formula in the active cell (precedents)
Ctrl + Shift + [ Selects all the cells that are directly (or indirectly) referred to by the formula in the active cell
Ctrl + ] Selects all the cells that directly refer to the active cell (dependents)
Ctrl + Shift + ] Selects all the cells that directly (or indirectly) refer to the active cell
Ctrl + Shift + Page Down Selects the active worksheet and the one after it
Ctrl + Shift + Page Up Selects the active worksheet and the one before it
Ctrl + Shift + Spacebar Selects all the objects on the worksheet when an object is selected or selects the whole worksheet
Ctrl + Spacebar Selects the current column
Shift + Arrow keys Selects the active cell and the cell in the given direction
Shift + Backspace Selects the active cell when multiple cells are selected
Shift + Spacebar Selects the current row
Ctrl + Shift + Arrow Key Extends the selection to the next cell adjacent to a blank cell in that direction
Ctrl + Shift + End Extends the selection to the last used cell on the worksheet
Ctrl + Shift + Home Extends the selection to the beginning of the worksheet
Shift + Arrow Keys Extends the selection by one cell in that direction
Shift + Home Extends the selection to the first column
Shift + Page Down Extends the selection down one screen
Shift + Page Up Extends the selection up one screen
End + Shift + Arrow Keys Extends the selection to the next non-blank cell in that direction
End + Shift + End Extends the selection to the last cell in the current row*
End + Shift + Home Extends the selection to last used cell on the worksheet
Alt + ‘ Displays the Style dialog box
Ctrl + Shift + ( ‘ or ) Applies the Time format “hh:mm” to the selection
Ctrl + Shift + (1 or !) Applies the Comma separated format “#,##0.00” to the selection
Ctrl + Shift + (4 or $) Applies the Currency format “£#,##0.00” to the selection
Ctrl + Shift + (5 or %) Applies the Percentage format “0%” to the selection
Ctrl + Shift + (6 or ^) Applies the Exponential format “#,##E+02” to the selection
Ctrl + Shift + (# or ~) Applies the General format to the selection
Ctrl + (# or ~) Applies the Custom Date format “dd-mmm-yy” to the selection
Ctrl + Shift + (7 or &) Applies the outline border to the selection
Ctrl + Shift + (- or _ ) Removes all the borders from the selection

Movement Keys

Arrow Keys Moves to the next cell in that direction
Ctrl + Tab Moves to the next open workbook or window
Alt + Tab Moves to the next application open on your computer
Alt + Shift + Tab Moves to the previous application open on your computer
Enter Moves to the cell directly below
Tab Moves to the next cell on the right (or unprotected cell)
Home Moves to the first column in the current row
End + Arrow Keys Moves to the next non empty cell in that direction
End + Enter Moves to the last cell in the current row that is not blank
End + Home Moves to the last used cell on the active worksheet*
End + Home Moves to the last used cell on the active worksheet*
Page Down Moves to the next screen of rows down
Page Up Moves to the previous screen of rows up
Shift + Enter Moves to the cell directly above (opposite direction to Enter)
Shift + Tab Moves to the cell directly to the left (opposite direction to Tab)
Alt + Page Down Moves you one screen of columns to the right
Alt + Page Up Moves you one screen of columns to the left
Ctrl + Home Moves to cell “A1” on the active sheet
Ctrl + End Moves to the last used cell on the active worksheet*
Ctrl + Up Arrow Moves to the first row in the current region
Ctrl + Down Arrow Moves to the last row in the current region
Ctrl + Left Arrow Moves to the first column in the current region
Ctrl + Right Arrow Moves to the last column in the current region
Ctrl + Page Up Moves to the previous worksheet in the workbook
Ctrl + Page Down Moves to the next worksheet in the workbook
Ctrl + Shift + Tab Moves to the previous open workbook or window
Scroll Lock + Arrow Keys Moves the workbook or window one cell the corresponding direction
Scroll Lock + End Moves to the last cell in the current window
Scroll Lock + Home Moves to the first cell in the current window
Scroll Lock + Page Down Moves you down one screen (current selection unchanged
Scroll Lock + Page Up Moves you up one screen (current selection unchanged)
Enter Moves from top to bottom within a selection
Tab Moves from left to right within a selection
Ctrl + . Moves clockwise to the next corner within a selection
Shift + Tab Moves from right to left within a selection (opposite direction to Tab)
Alt + Ctrl + Left Arrow Moves to the left between non adjacent cells in a selection
Alt + Ctrl + Right Arrow Moves to the right between non adjacent cells in a selection
= Starts a Formula
Ctrl + ` Toggles between the value layer and the formula layer
Ctrl + Insert Copies the current selection to the clipboard
Ctrl + Shift + ( Unhides any hidden rows within the selection
Ctrl + Shift + ) Unhides any hidden columns within the selection
Ctrl + Shift + \ Select unequal cells

Windows

Windows Tips

26/04/2026 by 0 Comments

Web to install software

Install and Update All Your Programs at Once
No toolbars. No clicking next. Just pick your apps and go.
Ninite.com

New folder for settings

New folder in desktop with all settings, creating a shorcut in desktop
GodMode.{ED7BA470-8E54-465E-825C-99712043E01C}

Memory diagnosis

mdsched.exe

Show Wifi Profiles and Passwords

netstat wlan show profile
netstat wlan show profile name="nombre" key=clear

Clear DNS client cache

Clear-DnsClientCache

Check App errors , system updates

Reliability Monitor

Check performance

Performance Monitor

Passwordless start

HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\WindowsNT\CurrentVersion\PasswordLess\Device
2 to 0
netplwiz Deselect users must enter a …

Disallow Telemetry

HKEY_LOCAL_MACHINE\SOFTWARE\Policies\Microsoft\Windows\DataCollection
0 DWord32 AllowTelemetry
Task Scheduler
Task Scheduler Library/Microsoft/Windows/Application Experience Disable
Task Scheduler Library/Microsoft/Windows/Customer Experience Improvement Program Disable
service dmwappushservice Disable

Windows

Some Windows Keyboard Shortcuts

26/04/2026 by 0 Comments
Shift+Ctrl+Win+b Reset graphic driver
Win Search Apps
Win+z Select layout with number
Win+r Open
Ctrl + A Select all items in a window
Ctrl + Z Undo
Ctrl + Y Redo
Ctrl + N When File Explorer is your current window, open a new File Explorer window with the same folder path as the current window
Alt + F4 Close app or windows
Shift+Shutdownr Total Shutdown
Win+Alt+R Record screen
Win+G Access recordings
Win+ Shift+S Partial screen photo Snipping tool
Win+X u u Shutdown
Win+V Access clipboard history
Win+D Hide apps and go to desktop
Win+, Quick view of desktop
Win+I Open settings
Win+H Dictation tool
Win+C Copilot
Windows

Add context menu script for Windows

05/02/2025 by

For adding a script named MyScript.bat to the context menu for all files, create a .REG file to modify registry:

Windows Registry Editor Version 5.00

[HKEY_CLASSES_ROOT\*\shell\MyScript]
@="Run MyScript"
"Icon"="C:\\path\\to\\your\\icon.ico"
[HKEY_CLASSES_ROOT\*\shell\MyScript\command]
@="C:\\path\\to\\your\\MyScript.bat \"%1\""

Double-click the .reg and confirm to modify the registry
The %1 is the file to be passed as an argument to the script
For specific file types: HKEY_CLASSES_ROOT\.txt\shell instead of HKEY_CLASSES_ROOT\*\shell\MyScript

Programming - Windows

Mount a deviceless webdav connection in Windows 10

12/02/2020 by

Mount deviceless webdav
This type of connection cannot be persistent
net use http://domain/directory/ paasword /USER:user
Access
It is necessary to use MS \\server\resource notation
dir \\domain\directory
Mount with first unallocated unit letter
net use * http://domain/directory/ paasword /USER:user
Mount with specific drive
net use x: http://domain/directory/ paasword /USER:user
Unmount

net use http://domain/directory/ /delete
net use x: /delete

Caution:
net use * /delete
deletes all connections

Net Use Command Options
Option Explanation
net use Execute the net use command alone to show detailed information about currently mapped drives and devices.
devicename Use this option to specify the drive letter or printer port you want to map the network resource to. For a shared folder on the network, specify a drive letter from D: through Z:, and for a shared printer, LPT1: through LPT3:. Use * instead of specifying devicename to automatically assign the next available drive letter, starting with Z: and moving backward, for a mapped drive.
\\computername\sharename This specifies the name of the computer, computername, and the shared resource, sharename, like a shared folder or a shared printer connected to computername. If there are spaces anywhere here, be sure to put the entire path, slashes included, in quotes.
volume Use this option to specify the volume when connecting to a NetWare server.
password This is the password needed to access the shared resource on computername. You can choose to enter the password during the execution of the net use command by typing * instead of the actual password.
/user Use this net command option to specify a username to connect to the resource with. If you don’t use /user, net use will attempt to connect to the network share or printer with your current username.
domainname Specify a different domain than the one you’re on, assuming you’re on one, with this option. Skip domainname if you’re not on a domain or you want net use to use the one you’re already on.
username Use this option with /user to specify the username to use to connect to the shared resource.
dotteddomainname This option specifies the fully qualified domain name where username exists.
/home This net use command option maps the current user’s home directory to either the devicename drive letter or the next available drive letter with *.
/persistent:{yes | no} Use this option to control the persistence of connections created with the net use command. Choose yes to automatically restore created connections at the next login or choose no to limit the life of this connection to this session. You can shorten this switch to /p if you like.
/smartcard This switch tells the net use command to use the credentials present on the available smart card.
/savecred This option stores the password and user information for use next time you connect in this session or in all future sessions when used with /persistent:yes.
/delete This net use command is used to cancel a network connection. Use /delete with devicename to remove a specified connection or with * to remove all mapped drives and devices. This option can be shortened to /d.
/help Use this option, or the shortened /h, to display detailed help information for the net use command. Using this switch is the same as using the net help command with net use: net help use.
/? The standard help switch also works with the net use command but only displays the command syntax, not any detailed information about the command’s options.
Programming - Windows

Run Powershell script Windows 10

12/02/2020 by
Read More

Create Script

Search for Windows PowerShell ISE and run the integrated editor.
Click on File menu.
Select the New option to create a new empty .ps1 file

Verify execution Policy

Run powershell as administrator.
Set-ExecutionPolicy RemoteSigned
On Windows 10, PowerShell includes four execution policies, including:

  • Restricted — Stops any script from running.
  • RemoteSigned — Runs scripts created on the device. However, scripts created on another computer won’t run unless they include a signature of a trusted publisher.
  • AllSigned — All the scripts will run as long as they’ve been signed by a trusted publisher.
  • Unrestricted — Runs any script without any restrictions.

Execute script

Execute command
& "C:\PATH\TO\SCRIPT\name_of_script.ps1"

Programming - Windows

Add Command Prompt As Administrator Context Menu in Windows 10

07/01/2020 by
Read More

Create .reg file and execute with content:

Windows Registry Editor Version 5.00
[HKEY_CLASSES_ROOT\Directory\shell\OpenElevatedCmd] @="Open command prompt here as administrator"
"Icon"="cmd.exe"
[HKEY_CLASSES_ROOT\Directory\shell\OpenElevatedCmd\command] @="PowerShell -windowstyle hidden -Command \"Start-Process cmd.exe -ArgumentList '/s,/k,pushd,%V' -Verb RunAs\""
[HKEY_CLASSES_ROOT\Directory\Background\shell\OpenElevatedCmd] @="Open command prompt here as administrator"
"Icon"="cmd.exe"
[HKEY_CLASSES_ROOT\Directory\Background\shell\OpenElevatedCmd\command] @="PowerShell -windowstyle hidden -Command \"Start-Process cmd.exe -ArgumentList '/s,/k,pushd,%V' -Verb RunAs\""
[HKEY_CLASSES_ROOT\Drive\shell\OpenElevatedCmd] @="Open command prompt here as administrator"
"Icon"="cmd.exe"
[HKEY_CLASSES_ROOT\Drive\shell\OpenElevatedCmd\command] @="PowerShell -windowstyle hidden -Command \"Start-Process cmd.exe -ArgumentList '/s,/k,pushd,%V' -Verb RunAs\""
[HKEY_CLASSES_ROOT\LibraryFolder\background\shell\OpenElevatedCmd] @="Open command prompt here as administrator"
"Icon"="cmd.exe"
[HKEY_CLASSES_ROOT\LibraryFolder\background\shell\OpenElevatedCmd\command] @=

Programming - Windows

Windows 10 Add better sendto functionality

28/11/2018 by
Read More

Adds multiple file send to functionality
Create SendToMailRecipient.vbs somewhere executable with the code below
Create a shortcut link to it
Put the link in the directory opened with shell:sendto

Option Explicit
Dim objArgs, OutApp, oNameSpace, oInbox, oEmailItem, olMailItem
Dim a, oAttachments, subjectStr, olFormatHTML
olMailItem = 0
olFormatHTML = 2
Set objArgs = WScript.Arguments 'gets paths of selected files
Set OutApp = CreateObject("Outlook.Application") 'opens Outlook
Set oEmailItem = OutApp.CreateItem(olMailItem) 'opens new email
For a = 0 to objArgs.Count - 1
Set oAttachments = oEmailItem.Attachments.Add(objArgs(a))
subjectStr = subjectStr & Right(objArgs(a),Len(objArgs(a))-(InStrRev(objArgs(a),"\"))) & ", " 'recreates the default Subject e.g. Emailing: file1.doc, file2.xls
Next
If subjectStr = "" then subjectStr = "No Subject "
oEmailItem.Subject = "Emailing: " & Left(subjectStr, (Len(subjectStr)-2))
oEmailItem.BodyFormat = olFormatHTML
oEmailItem.Display

Windows

Inverse selection in File Explorer

25/01/2018 by
Read More

Use Invert Selection for Easier File Selection in Windows Explorer

The next time you need to select most of the files in an open Explorer window don’t waste your time holding down Ctrl and clicking each file manually. It’s much easier to select the ones you DON’T need, and then let Windows reverse your selection.

Inside an open window, hold down Ctrl as you select the file(s) you DON’T want to select (sounds backward, but wait…).

Select Edit, then Invert Selection, and Windows will turn your selection inside out leaving you with the files you wanted to select.

You can then delete or copy them as needed.