![]() This shortcut will enter the range of cells in the selected cell. To enter a range of cells: Use the F5 keyboard shortcut. For example, if you select cell A1 and use the F2 keyboard shortcut, the cell reference A1 will be entered in the cell.Ĩ. This shortcut will enter the cell reference in the selected cell. To enter a cell reference: Use the F2 keyboard shortcut. You can also use the Ctrl + V keyboard shortcut to enter the value in the cell to the right of the selected cell.ħ. This shortcut will enter the value in the cell to the left of the selected cell. To enter a value in a cell: Use the Ctrl + Shift + V keyboard shortcut. This shortcut will enter the = sign in the selected cell, which you can then use to start entering a formula.Ħ. To enter a formula: Use the Ctrl + ' keyboard shortcut. You can also use the Ctrl + Shift + : keyboard shortcut to enter the current time in the selected cell.ĥ. This shortcut will enter the current time in the selected cell. To enter the current time: Use the Ctrl + Shift + 4 keyboard shortcut. You can also use the Ctrl + keyboard shortcut to enter the current date in the selected cell.Ĥ. This shortcut will enter the current date in the selected cell. To enter a date: Use the Ctrl + Shift + 3 keyboard shortcut. This can be useful when you're entering data that includes tabular data, such as a list of items with prices.ģ. To enter a tab character in a cell: Use the Ctrl + Shift + 8 keyboard shortcut. This is especially useful when you're entering data that includes line breaks, such as addresses.Ģ. To enter a new line in a cell: Use the Alt + Enter keyboard shortcut. With these shortcuts, you'll be able to speed up your data entry and make sure that your data is entered correctly every time.ġ. That's why we've put together this list of 15 keyboard shortcuts for entering data in Excel. Also, the "Ctrl + N" keyboard shortcut will open a new instance of File Explorer (when the app is already open).If you work with data in Microsoft Excel, you know how important it is to be able to enter it quickly and accurately. In addition to the "Windows key + E" shortcut to open File Explorer and the "Ctrl + Shift + N" to create new folders, you can also use the "Ctrl + T" shortcut to create a new tab and "Ctrl + W" to close a tab. There are also a few extra useful shortcuts. Windows key + Number (1-9): Opens the app that the number represents in the Taskbar.Windows key + Z: Opens Snap Layouts to organize apps with different layouts on the screen.Windows key + Shift + S: Opens Snipping Tool controls for screenshots.Windows key + PrtScn: Captures a full screenshot in the "Screenshots" folder.Windows key + Period (.) or Semicolon ( ): Opens emoji panel with access to gifs and special characters.Windows key + V: Opens the Clipboard history.Windows key + L: Locks the account profile.Windows key + D: Displays and hides the desktop.Windows key + N: Opens Notifications and Calendar.Windows key + A: Opens Quick Settings to control volume, wireless, and other features.Hold the "Alt" key and press the "Tab" key to cycle through the applications. Alt + Tab: Switches between open apps.Shift + Delete: Deletes the selected item permanently, skipping Recycle Bin.Ctrl + D (Del): Delete the selected item to the Recycle Bin. ![]() (If no active window is present, a shutdown box appears.)
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |