You are reading the article Use These Keyboard Shortcuts To Quickly Move Around In Bash updated in December 2023 on the website Bellydancehcm.com. We hope that the information we have shared is helpful to you. If you find the content interesting and meaningful, please share it with your friends and continue to follow and support us for the latest updates. Suggested January 2024 Use These Keyboard Shortcuts To Quickly Move Around In Bash
When you misspell a command or path in Bash, you probably use the cursor keys (“arrow keys”) on your keyboard to move your cursor around and fix your typo. You’re pressing Delete or Backspace repeatedly to remove whole words, only to then type them again properly.
Did you know that there are keyboard shortcuts in Bash that allow you to jump around your terminal to edit or tweak your commands quickly and avoid having to retype everything? Let’s take a look at the ones you should try.Move in Active Line
There are many ways to move to different points of the active line. Press Home or Ctrl + A on your keyboard to move to the beginning. End or Ctrl + E has the opposite effect and moves the cursor to the end of the active line.
Use Alt + B to go back one single word and repeat to jump from word to word backward, toward the beginning of the active line. If you overdo it, press Alt + F for the opposite: to jump forward from word to word.Edit Active Line
Instead of deleting text one character at a time, Alt + D can delete the whole word that follows the cursor. You don’t have to move to the beginning of a word to delete it, though: use Alt + Delete to delete backward, removing the word at the left of your cursor.
Although you’ll probably keep using Delete and Backspace to remove characters under or before the cursor, it’s worth noting that the Ctrl + D and Ctrl + H combinations have the same result. If you want something more radical, Ctrl + W deletes everything in the active line preceding the cursor, leaving intact everything from afterthe cursor. Ctrl + K does the opposite, deleting everything after the cursor.Fix typos
Let’s say you typed two words in reverse order. Instead of deleting and retyping them, target the second word with your cursor and press Alt + T on your keyboard. The targeted word will change places with the one before it.
If it is only two characters you typed in reverse, target the second one, press Ctrl + T, and it will swap places with the one before it.
If you’re working with absolute paths or other commands that demand proper capitalization of characters, by pressing Alt + U while targeting a word, every character after the cursor until the end of the word will be capitalized. Pressing Alt + L does the opposite, turning them to lowercase.Useful Extras
Bash is smart enough to autocomplete your half-typed commands and paths if you press Tab. If you’ve typed something like “/home/username/Pic” instead of instead of bringing up “/home/username/Pictures,” but pressing Tab does nothing, you might have a similar folder in your path, like “/home/username/Picachu.” Bash can’t choose for you, so you’ll have to type one or two more letters to give it a hint about which of the two paths you want.
If you don’t remember what’s in the path, you can press Tab again for it to display the files and directories that match your defined path.
Bash also keeps a history of your commands – you can go backward and forward by using the up and down arrow keys on your keyboard. You can also use Ctrl + P to re-select the previous command and repeat it to “keep moving backward” in Bash”s history. Press Ctrl + N to do the opposite. For your information, here is a better way to search your command line history.
Finally, if your whole terminal has become a mess of characters and commands, you can type clear and press Enter to have it look like a clean slate. The shortcut Ctrl + L will produce the same result, too.
If instead of fixing typos on the commands you already know and you want to expand your command vocabulary, we have some methods that will help you remember new commands easily.
OK’s real life started at around 10, when he got his first computer – a Commodore 128. Since then, he’s been melting keycaps by typing 24/7, trying to spread The Word Of Tech to anyone interested enough to listen. Or, rather, read.
Subscribe to our newsletter!
Our latest tutorials delivered straight to your inbox
Sign up for all newsletters.
You're reading Use These Keyboard Shortcuts To Quickly Move Around In Bash
Keyboard Shortcuts to Use in Brave Browser
Remembering all the shortkeys of a browser is impossible, but regular functions like opening a new tab, minimizing the current window, and opening the download page are worth memorizing. Here, we have listed 50+ keyboard shortcuts for the Brave browser that you can memorize to improve productivity and save time while using the browser.Keyboard Shortcuts to Navigate Tabs and Windows in Brave 1. Open a New Window
You can use Command + N for macOS or Ctrl + N for Windows / Linux to open a new window on the Brave browser and start browsing.2. Open a New Private Window 3. Open a New Tab and Jump to it
You can open up a new tab in your current window and jump to it using the Command + T key on macOS or Ctrl + T key on Windows / Linux.4. Reopen the Last Closed Tab, and Jump to It 5. Jump to the Next Open Tab
You can jump to the next open tab by pressing Command + Option + Right arrow for macOS or Ctrl + Tab / PgDn on Windows / Linux.6. Jump to the Previous Open Tab
You can jump to the previous open tab on the Brave browser by pressing Command + Option + Left key on macOS or Ctrl + Shift + Tab key (or Ctrl + PgUp key) on the Windows / Linux computer.7. Jump to a Specific Tab
You can jump to a specific tab by pressing Command + 1 through Command + 8 key on macOS or Ctrl + 1 through Ctrl + 8 key on Windows / Linux computers. If you want to jump to the 5th tab, you need to press Command + 5 on macOS or Ctrl + 5 on Windows / Linux.8.Jump to the Last Tab
If you want to jump to the last opened tab, you can easily do it by pressing Command + 9 on macOS or Ctrl + 9 on Windows / Linux computers.9. Close the Current Tab
You can close the current tab by pressing the Command + W key on your macOS system or Ctrl + W / F4 key on Windows / Linux computers.10. Close the Current Window
To close the current window on the Brave browser, you need to press Command + Shift + W on macOS or Ctrl + Shift + W on Windows / Linux computers.11. Minimize the Window
You can minimize the current window by pressing Command + M on macOS or Alt + Space + N on Windows / Linux.12. Quit or Exit Brave 13. Maximize the Current Window
You can maximize the current window by pressing the Alt + Space + X key on the keyboard for Windows / Linux computers.Keyboard Shortcuts to Navigate Brave Features 1. Show or Hide the Bookmarks Bar 2. Open the Bookmark Manager 3. Open the History Page in a New Tab
By pressing Command + Y key on macOS or Ctrl + H key on Windows / Linux, you can open the history page in a new tab on the Brave browser.5. Open Developer Tools
By pressing the Command + Option + I key on macOS or Ctrl + Shift + J key on Windows / Linux, you can access the developer tools.6. Open the Clear Browsing Data options
To see clear browsing data options, you need to press the Command + Shift + Delete key on your system running on macOS or Ctrl + Shift + Delete key on Windows / Linux.7. Open the Profile menu
To open the profile menu on the Brave browser, you need to press Command + Shift + M on macOS or Ctrl + Shift + M on Windows / Linux.8. Open the Brave Task Manager
To open the Brave task manager, you need to press the Shift + Esc key on Windows / Linux computer. Once you do, you will be able to see all the opened tabs and also end the processes.9. Open the Find Bar to search the current page 10. Jump to the Next Match in Your Find Bar Search
By pressing the Ctrl + G key on your Windows / Linux computer, you can easily jump to the next match to your find bar search.11. Jump to the Previous Match in Your Find Bar Search
By pressing the Ctrl + Shift + G key on your Windows / Linux PC system, you can easily jump to the previous match to your find bar search.Keyboard Shortcuts to Navigate Address bar in Brave
After typing a site name on the address bar then press Control + Enter for macOS or Ctrl + Enter on Windows / Linux.2. Jump to the Address Bar Keyboard Shortcuts to Navigate Web Pages in Brave 1. Print the Current Page
If you want to print the current page, you need to press the Command + P key on macOS or Ctrl + P key on Windows / Linux computers. Once you do, it will the option to print the page.2. Save the Current Page
You can easily save the current page by pressing Command + S key on macOS or Ctrl + S key on Windows / Linux computers. Once you press the keys, you will see the options page to save it.3. Hard Reload the Current Page
If you want to clear the cache of a webpage, then you need to hard reload your current page. To do so, you need to press Command + Shift + R on macOS or Ctrl + Shift + R (or Shift + F5) on Windows / Linux.4. Stop the Page Loading
Just like other browsers, the short key to stopping a website from loading in the Brave browser is by pressing the Esc button on your keyboard.7. Open a File From Your Computer in Brave 8. Display Non-editable HTML Source Code
To view the HTML page source of the page, you need to press the Command + Option + U key on macOS or Ctrl + U key on Windows / Linux computer.9. Bookmark the Current Webpage 10. Bookmark All the Opened Tabs in a New Folder 11. Turn On or off Full-Screen Mode
If you want to turn the full-screen mode on or off, press the Command + Ctrl + F key on macOS or the F11 key on Windows / Linux computer.12. Zoom In on the Webpage 13. Zoom Out the Webpage
To make everything on the page smaller, you must press Command and – key on macOS or Ctrl and – key on Windows / Linux computers.14. Make the Webpage to Its Default Size
If you want to return everything on the page to the default size, you need to press Command + 0 on macOS or Ctrl + 0 on Windows / Linux computers.15. Scroll Down a Webpage
You can easily scroll down a webpage, a screen at a time, by pressing the Space key on your macOS / Windows / Linux system.16. Scroll up a Web Page
If you want to scroll up a webpage, a screen at a time, you can do it by pressing the Shift + Space key on your system running on macOS / Windows / Linux17. Open the Home Page in the Current Tab
In order to open the home page in the current tab on Brave browser, you need to press Command + Shift + H key on macOS or Alt + Home key on Windows / Linux computers.18. Go to the Top of the Page
To go to the top of the page on the Brave browser, you need to press the Home button on your keyboard for Windows / Linux computers.19. Go to the Bottom of the Page 20. Reload the Current Page
Like other browsers, you can easily reload the current page on the Brave browser by pressing the Ctrl + R key (or F5) on Windows / Linux.Keyboard Shortcuts to Navigate Mouse in Brave 1. Open a Link in a Current Tab
If you want to open a link from a web page in the current tab, you need to drag the link from the mouse to the address bar.2. Open a Link in a New Tab 3. Open a Link in a New Tab, and Jump to It 4. Open a Link in a New Window 5. Switch Between Maximized and Windowed Modes Wrapping Up
Microsoft Excel Keyboard Shortcuts
The keyboard shortcuts are tested and works in most versions of the Microsoft Excel in Windows based computers. The shortcuts are categorized as below and use the search box to filter the results in the below table.
AltActivate access keys (then press further keys to go to the required menu item)Menu
Alt + =Apply automatic summation when used down the cells with numbers. Apply sum function when used on empty cell.Function
Alt + AGo to Data menuMenu
Alt + A, MOpen Remove Duplicate dialog boxDialog box
Alt + EnterCreate a new line within a cellData processing
Alt + FOpen File menuMenu
Alt + F1Insert chart on the active sheetData processing
Alt + F2Save as workbookMenu
Alt + F4Close workbookMenu
Alt + F8Open Macro popup boxDialog box
Alt + F10Show or hide selection paneGeneral
Alt + F11Open Microsoft Visual Basic editor for ExcelData processing
Alt + HHighlight menu and go to Home menuMenu
Alt + H, 0Increase one decimal place of the numberMenu
Alt + H, 3, DDouble underline the selected contentMenu
Alt + H, 5Reduce indentMenu
Alt + H, 6Increase indentMenu
Alt + H, 9Reduce one decimal place of the numberMenu
Alt + H, A, BAlign content in bottom of the cellMenu
Alt + H, A, CAlign centerMenu
Alt + H, A, LLeft alignmentMenu
Alt + H, A, MAlign content in middle of the cellMenu
Alt + H, A, NApply accounting format from the listMenu
Alt + H, A, RRight alignmentMenu
Alt + H, A, TAlign content in top of the cellMenu
Alt + H, BOpen border dropdownMenu
Alt + H, CAlign centerFormatting
Alt + H, C, POpen Copy Picture dialog boxDialog box
Alt + H, D, CDelete the column of the active cellData processing
Alt + H, E, AClear the selected cell dataData processing
Alt + H, E, RRemove hyperlinks from the selected cellsData processing
Alt + H, F, I, JJustify the selected cell contentFormatting
Alt + H, F, I, LCopy the content on the right cell to the current active cellData processing
Alt + H, F, I, RCopy the content on the left cell to the current active cellData processing
Alt + H, F, I, UCopy the content on the below cell to the current active cellData processing
Alt + H, F, OOpen clipboard paneData processing
Alt + H, HChoose the color to fillMenu
Alt + H, O, IAutofit the width of the selected columnGeneral
Alt + H, U, AAverage number functionFunction
Alt + H, U, CCount numbersFunction
Alt + H, U, IMinimum number functionFunction
Alt + H, U, MMaximum number functionFunction
Alt + H, V, EPaste content with source values and formatting (you should have copied the content before)Data processing
Alt + H, V, IPaste the copied content as a linked picture or imageData processing
Alt + H, V, UPaste the copied content as a picture or imageData processing
Alt + MGo to Formulas menuMenu
Alt + NHighlight menu and go to insert menuMenu
Alt + N, BGo to insert bar chart menuMenu
Alt + N, CGo to insert column chart menuMenu
Alt + N, NGo to insert line chart menuMenu
Alt + N, QGo to insert pie chart menuMenu
Alt + N, ROpen Insert Chart dialog and go to Recommended Chart sectionDialog box
Alt + N, S, DGo to insert custom combo chart menuMenu
Alt + PPage Layout menuMenu
Alt + Page DownMove one screen rightWorkbook
Alt + Page UpMove one screen leftWorkbook
Alt + ROpen Review tabMenu
Alt + Shift + F2Save as workbookWorkbook
Alt + Shift + F4Close workbookWorkbook
Alt + SpacebarOpen control menuMenu
Alt + T, OOpen Excel Options dialogDialog box
Alt + WGo to View menuMenu
Alt + W, F, FFree panes, you should have selected columns or rows beforeMenu
Alt + W, IView the sheet in a page break preview modeMenu
Alt + W, LView the sheet in a normal modeMenu
Alt + W, QOpen zoom dialog boxDialog box
Alt + W, V, GToggle gridlines on or offMenu
Context KeyOpen context menuMenu
Ctrl + 0Hide columnsData processing
Ctrl + 1Open format cells popup boxDialog box
Ctrl + 2Apply boldFormatting
Ctrl + 3Apply italicFormatting
Ctrl + 4Apply underlineFormatting
Ctrl + 5Apply strikethroughFormatting
Ctrl + 6Toggle object displayMenu
Ctrl + 7Show / hide toolbarMenu
Ctrl + 8Show / hide outline symbolsGeneral
Ctrl + 9Hide rowsData processing
Ctrl + -Delete cells or rowsData processing
Ctrl + :Insert current timeData processing
Ctrl + ;Insert system dateData processing
Ctrl + ‘Copy the formula from upper cell to lower cellData processing
Ctrl + “Copy the content from the upper cell to lower cellData processing
Ctrl + ASelect all cells in a sheetWorkbook
Ctrl + Alt + VOpen paste special dialog box when you have copied the content in clipboardDialog box
Ctrl + BBold selected contentFormatting
Ctrl + CCopy selected contentData processing
Ctrl + DCopy the content from the upper cell to lower cellData processing
Ctrl + Down ArrowMove to lower end of the selected rangeNavigation
Ctrl + EUse flash fillData processing
Ctrl + EndGo to the lowest used cell in right corner of a workbookGeneral
Ctrl + FFind content on the sheetData processing
Ctrl + F1Show or hide ribbonMenu
Ctrl + F2Open print preview optionsMenu
Ctrl + F3Open name managerDialog box
Ctrl + F4Close sheetMenu
Ctrl + F5Restore window sizeWorkbook
Ctrl + F6Go to next workbookWorkbook
Ctrl + F7Move the windowWorkbook
Ctrl + F8Resize windowWorkbook
Ctrl + F9Minimize windowWorkbook
Ctrl + F10Maximize windowWorkbook
Ctrl + F11Insert a new macro sheetWorkbook
Ctrl + F12Open fileMenu
Ctrl + GGo to the named cellDialog box
Ctrl + HFind text and replace with another textDialog box
Ctrl + HomeGo to start of the sheetWorkbook
Ctrl + IMake the selected text italicFormatting
Ctrl + KInsert hyperlink on the selected cellData processing
Ctrl + LOpen create table boxDialog box
Ctrl + Left ArrowMove to left end of the selected rangeNavigation
Ctrl + NOpen new Excel workbookWorkbook
Ctrl + OGo to open menuMenu
Ctrl + PPrint optionsMenu
Ctrl + Page DownGo to next sheet in a workbookWorkbook
Ctrl + Page UpGo to previous sheet in a workbookWorkbook
Ctrl + QOpen Quick Analysis toolDialog box
Ctrl + RCopy the content from left cell to the right side cellData processing
Ctrl + Right ArrowMove to right end of the selected rangeNavigation
Ctrl + SSave the workbookMenu
Ctrl + Shift + !Format cell in number formatFormatting
Ctrl + Shift + “Copy the content from the upper cell to lower cellData processing
Ctrl + Shift + #Format cell in date formatFormatting
Ctrl + Shift + $Format cell in $ currency formatFormatting
Ctrl + Shift + %Format cell in % formatFormatting
Ctrl + Shift + &Apply border around the cellFormatting
Ctrl + Shift + (Unhide rowsData processing
Ctrl + Shift + )Unhide columnsData processing
Ctrl + Shift + *Select the region nearer to active cellData processing
Ctrl + Shift + +Insert cells or rowsData processing
Ctrl + Shift + :Insert current timeData processing
Ctrl + Shift + @Format cell in time formatFormatting
Ctrl + Shift + ^Format cell in exponential formatFormatting
Ctrl + Shift + _Remove border around the cellFormatting
Ctrl + Shift + ArrowsSelect till the nonblank cell in the arrow directionNavigation
Ctrl + Shift + EndSelect the range from the current cell to the lowest used right corner cell of a workbookNavigation
Ctrl + Shift + FOpen format cell dialog box with font tab openFormatting
Ctrl + Shift + F1Maximize window by hiding menus and ribbonWorkbook
Ctrl + Shift + F3Open create name for selection popup boxDialog box
Ctrl + Shift + F6Go to previous workbook windowWorkbook
Ctrl + Shift + F6Go to previous workbookWorkbook
Ctrl + Shift + F12Open print optionsMenu
Ctrl + Shift + LToggle autofilterGeneral
Ctrl + Shift + Page DownSelect current and next sheets (you should have next available sheet for selection)Workbook
Ctrl + Shift + Page UpSelect current and previous sheets (you should have previous available sheet for selection)Workbook
Ctrl + Shift + SpacebarSelect the workbook contentData processing
Ctrl + Shift + TabGo to previous workbookWorkbook
Ctrl + Shift + UExpand / collapse formula barMenu
Ctrl + Shift + ~Format cell as generalFormatting
Ctrl + TOpen create table boxDialog box
Ctrl + TabGo to next workbookWorkbook
Ctrl + UUnderline the textFormatting
Ctrl + Up ArrowMove to upper end of the selected rangeNavigation
Ctrl + VPaste contentData processing
Ctrl + WClose active sheetGeneral
Ctrl + XCut the selected contentData processing
Ctrl + YRedo previous actionData processing
Ctrl + ZUndo previous actionData processing
Down ArrowMove one cell downNavigation
EscCancel the selected or current operationData processing
F1Open Excel helpGeneral
F2Edit active cellData processing
F3Show paste name popup when the names are defined in the workbookDialog box
F4Repeat the last action (like pasting)Data processing
F5Open Go To popup boxDialog box
F6Toggle between menu, ribbon and task pane.Menu
F7Do spell checkData processing
F9Calculate in all sheets in all opened workbooksWorkbook
F10Activate access keysMenu
F11Insert new chart sheetWorkbook
F12Save as the workbookWorkbook
HomeGo to first cell in a rowNavigation
Left ArrowMove one cell leftNavigation
Page DownMove one screen downNavigation
Page UpMove one screen upNavigation
Right ArrowMove one cell rightNavigation
Scroll Lock + HomeGo to upper left corner cell (first cell)Navigation
Shift + F3Insert functionData processing
Shift + F4Find next when finding the textDialog box
Shift + F5Find and replaceDialog box
Shift + F6Activate menuMenu
Shift + F7Open thesaurus to find synonymsGeneral
Shift + F8Add to selectionGeneral
Shift + F11Create new sheetWorkbook
Shift + F12Save as the workbookMenu
Shift + SpacebarSelect the rowGeneral
Shift + TabMove to previous cell or ribbon item or cellNavigation
TabMove to next cell or ribbon item or cellNavigation
Up ArrowMove one cell upNavigation
Windows KeyOpen context menuMenu
Want to know how to create keyboard shortcuts to do anything on Windows 10? This guide will help. Surprisingly, it’s quite easy to create a quick keybind that can open programs, perform repeatable tasks, and speed up your workflow.
I’ll suggest a number of different options you can use to make keyboard shortcuts and provide some examples of how you can use them to their max potential.
Table of ContentsOpen Programs Quickly
I can see this shortcut option being useful for a large number of Windows 10 users. It’s quick and easy to set it up so that a quick shortcut can open any executable file. Here’s how to do it.
Alternatively, you can just copy and paste the location. WinHotKey will automatically grab the application icon so that you are given visual context about it. You can now open your program with the
You must make sure that your keyboard shortcut doesn’t conflict with any existing shortcuts, either Windows defaults or from within the WinHotKey interface. For example, Alt+F4 couldn’t be used. It’s best to stick to Windows + ’X’ combinations to avoid conflicts.Automatically Type Text
Now, type or paste the text into the box at the bottom of the new hotkey window. Finally, make sure to choose a new keyboard shortcut you haven’t used before.
There isn’t a limit on how many characters you use with this shortcut, but if there is a line break in anything you paste, it will end there. So, it’s best for copying single paragraphs, things like hashtags for Instagram or social links for YouTube descriptions.Open Folders and Documents in Windows 10
WinHotKey can also be used to quickly open specific folders and documents within Windows 10. You can simply select the Open a Document or Open a Folder options under the I want WinHotKey to: dropdown box and then follow the same steps as above.
This time though, you’ll need to browse to a specific file or application. If you choose the open document option, most documents will work, so long as you have a supporting application defaulted to open those kinds of files. From my testing, I could get Photoshop, office apps like Excel, PDF files, and text files.
If a file didn’t work, Windows 10 will ask you to choose a default application for that file type, and then future hotkeys with that file type would then also work.Use Autohotkey for Emojis
AutoHotkey is another application for Windows 10 that can help you to create more complex keyboard shortcuts. This software can be used to automate a large number of different tasks. You can download Autohotkey from their website for free.
Once you’ve downloaded it, extract the file to Next, browse and navigate to AutoHotkeyU64. This will allow you to run AutoHotkey scripts by double
It’s very easy to use emojis on a smartphone, but there isn’t any easy way to do this on a computer by default. With Autohotkey, you can set up a number of emoji shortcuts. Here’s how to do it.
Creating a hotkey extension can be quite complex, but thankfully there are dozens of great autohotkey scripts on the internet. For creating emojis, we’d suggest this one.
PC. After, you can type emoji codes like :smiley: to automatically use emojis. At any time, you can refer back to the Github link above to see which codes are used for each emoji.More Advanced Autohotkey Scripts
Magnify the screen with keybinds
Use mouse gestures
Drag windows easily
Quickly access your favorite folders
View upload/download speed via a small on-screen overlaySummary
Watch Video – 25 AWESOME Excel Keyboard Shortcuts (You Should Know)!
If you work with Excel day in and day out, Excel Keyboard Shortcuts can help you shorten your workday and save a lot of time.
Additionally, it also has the power to enchant your co-workers and boss into thinking you’re an Excel Wizard.
When I started my career as an analyst, I was completely in awe with one of my colleagues who was super-fast while working with Excel. He always seemed to have a keyboard shortcut for everything.
One day he told me his secret…
“You don’t need to know every shortcut. Just master the ones you need regularly and you’ll do awesome”.Excel Keyboard Shortcuts
In this tutorial, I am sharing my top 20 Excel Keyboard shortcuts that can help you speed up your work and save a lot of time.
How to use interpret keyboard shortcuts: CONTROL + T would mean press the Control key and then press the T key. CONTROL T would mean hold the Control key and press the T key.#1 Auto Sum
If you have numbers in a column/row, you can quickly get the sum by using this Excel keyboard shortcut.ALT = #2 Paste as Values
When you copy and paste a cell or a range of cells, it also copies the value, the formula in it, and the formatting. If you only want to copy the values, use the following keyboard shortcut.ALT + E + S + V + ENTER
Read More:#3 Fill Down
This one would help you while entering data in Excel.
Use it to copy the cell right above the active cell. Note that this would copy the contents, formulas, and formatting as well.CONTROL D Also read: How to use Fill Handle in Excel #4 Select Entire Row/Column
You use the following shortcuts to select an entire row or column that contains the active cell.
To select the entire row:SHIFT SPACEBAR
To select the entire column:CONTROL SPACEBAR
For example, if cell B2 is selected, then Shift + Spacebar would select the second row and Control + Spacebar would select the second column.#5 Delete Cells/Row/Column
To delete selected cells, rows, or columns, use the keyboard shortcut:CONTROL -
This opens the Delete dialog box, where you can select from the following options:
Shift cells left.
Shift cells up.
Delete Entire Row.
Delete Entire Column.#6 Applying Border
To quickly apply borders to the selected cells, use the keyboard shortcut:ALT + H + B + A
Note that this applies the “All Border” format, which means that all the cells get the border format. If you want to apply the Outline border only use ALT + H + B + S.#7 Inserting a Comment SHIFT F2 #8 Insert Current Date and Time
This keyboard shortcut can be used to quickly insert timestamps in cells.
To insert the current date, use the keyboard shortcut:CONTROL ;
To insert the current time, use the keyboard shortcut:CONTROL SHIFT ; #9 Navigate Through Worksheets
If you have a lot of worksheets in the workbook, it can drive you crazy to navigate through it.
Here is the keyboard shortcut that solves this problem.
To go to the previous worksheet:CONTROL PAGEUP
To go to the next worksheet:CONTROL PAGEDOWN
Note that if you continue to hold the keys, it will keep on moving on to the previous/next worksheet.#10 Apply Filter
Here is a keyboard shortcut that would instantly apply data filter (or remove filters if it’s already applied):CONTROL SHIFT L #11 Select Visible Cells Only
Let me first tell you why this is important.
Suppose you have a list in Excel and you hide a few rows. Now if you copy the entire list and paste it somewhere else, it will copy all the cells (including the ones that are hidden, as shown below):
Note that a few rows in the original data set are hidden, but when you copy-paste it, even the hidden rows get copied.
If you don’t want this to happen, you first need to select only those cells that are visible. To do this, select the entire list and use the keyboard shortcut:ALT ;
Now when you copy it and paste it anywhere, you can be sure only the visible cells are getting copied.#12 Freeze Top Row
If you work with a data set that is huge and spans across hundreds or thousands of rows and many columns, you’ll face the issue of the header disappearing when you scroll down. This often wastes a lot of time as you have to scroll back to see what a data point means.
Freezing rows and columns is the way to go in such cases.
Here are the shortcuts for freezing rows/columns:
To freeze the top row: ALT + W + F + R
Note that the top row gets fixed.
To freeze the first column: ALT + W + F + C
Note that the left-most column gets fixed.
If you want to freeze both rows and columns, select a cell above which you want to freeze rows (you can freeze more than one row), and to the left of which you want to freeze columns (could be one or more than one). For example, if you want to freeze the top two rows and one column to the left, select cell B3.
Now use the shortcut:ALT + W + F + F #13 Opening Format Cells Dialogue Box
This one is my favorite. If you want to change the formatting of a cell or range of cells, select the cells and use the keyboard shortcut:CONTROL 1
It’s a gateway to all the formatting you can do this Excel. It opens a dialog box where you have different tabs for different types of formatting.#14 Start New Line in the Same Cell
Sometimes, you may want to show the text/data in two or more than two rows in the same cell in Excel. For example, you may want to enter the address in a cell, but want the house numbers, street, city, state in different lines in the same cell.
To do this, place the cursor where you want to insert the line and use the keyboard shortcut:ALT ENTER #15 Switch to Next Workbook
If you’re working with multiple workbooks, you may need to switch between these workbooks. A popular shortcut to do this is ALT + TAB
But this would cycle through all the open applications. For example, if you have multiple applications open at the same time, such as a browser, PowerPoint, word, excel, skype, VLC, and so on, ALT + TAB would cycle through all these applications.
Instead, activate a workbook and then use the following shortcut to switch between open workbooks only.CONTROL TAB #16 Insert Hyperlink
To insert a hyperlink in a cell, you need to open the Insert Hyperlink dialog box. The keyboard shortcut for this is:CONTROL K #17 Insert Bullet
If you want to insert bullets in Excel (in case you are creating a list), you can do that quickly by using a keyboard shortcut.
If you have a numeric keypad in your keyboard:
Select the cell in which you want to insert the bullet.
Hold the ALT key, Press 7 or 9, leave the ALT key.
As soon as you leave the ALT key, a bullet would appear.
If you do not have a numeric Keyboard (like my laptop), activate the NumLock first and then repeat the above steps (or try with ALT + FUNCTION + 7/9)#18 Converting Tabular Data into Excel Table
Excel Table is a must-use feature if you work with tabular data.
To quickly convert tabular data into an Excel Table, select the data (or select any cell in the data set) and use the keyboard shortcut:CONTROL T
This will open the Create Table dialog box. While it automatically picks the range that needs to be converted, and in most cases it is correct, it’s a good practice to cross-check this.#19 Spell Check
While most of the people work with data in Excel, if your work involves a bit of text as well, it’s a good practice to run spell-check before marking the work as final and sending across to your boss or client.
Unlike MS Word or PowerPoint, Excel would not show red lines below the words that are misspelled. However, if you run spell check, it will catch those errors.
To run spell check, simply hit the F7 key.F7 #20 Open the VB Editor Window
Working with VBA requires one to switch between the worksheet and the VB Editor.
To make a switch from Excel workbook to VB Editor, use the keyboard shortcut:ALT F11
These are my top 20 Excel keyboard shortcuts. I am sure you have some of your own too.
Useful Excel Resources:
The Black Heart Symbol Alt code is 3.
This alt code works anywhere on the Windows PC including MS Word, Excel, PowerPoint, or even somewhere in your browser like Google Docs.
The below table contains different types of the heart symbol along with their respective alt code shortcuts for Microsoft Word.
NOTE: The alt code shortcuts in this table works only in MS Word for Windows.
DescriptionSymbol TextAlt CodeReversed Rotated Floral Heart Bullet☙Alt + 9753White Heart Suit♡Alt + 9825Black Heart Suit♥Alt + 9829Heavy Heart Exclamation Mark Ornament❣Alt + 10083Heavy Black Heart❤Alt + 10084Rotated Heavy Black Heart Bullet❥Alt + 10085Rotated Floral Heart Bullet❧Alt + 10087
To get the Heart symbol using these alt code shortcuts:
Launch your MS Word document.
Place your insertion pointer where you need to insert the Heart sign (♥).
Press down the Alt key.
While holding the Alt key, type the Heart Alt code (3) using the numeric keypad.
Then release the Alt key to insert the symbol (♥).
Related Post: How to Type Heart symbol in Word/Excel
Alt codes are used to type symbols and characters that do not have a dedicated key on the keyboard in personal computers running the Microsoft Operating systems. You can do this by pressing and holding the Alt key while typing the alt code with the numeric keypad.
To type♥ using the Heart Alt code of 3: first, ensure that your NumLock is turned on, then press and hold the alt key while you type the code on the numeric keypad. Then release the Alt key.
Other operating systems like the Mac OS have a similar or extended form of this Alt code feature which I’ll explain soon.
You must press and hold the Alt key before typing the Alt code.
You must use the numeric keypad on the right of the keyboard to type the alt code.
Since you are using the numeric keypad, the NumLock must be turned on. Turning off the NumLock will disable the number pad, and hence no numbers can be typed using the num pad.
If you are using a laptop without the numeric keypad, you should first turn on the hidden numeric keypad. On most laptops, you can turn this on by pressing Fn+NmLk keys simultaneously. Not all laptops have the hidden numeric keypad. If it seems missing in yours, then you cannot use the alt code method to type the Heart (♥) symbol with your laptop unless you connect an external keyboard that has a numeric keypad.
You should also understand that not all symbols can be typed with the alt code depending on the document you are working on. Some of the alt codes work only in Microsoft Word. However, the black Heart (♥) alt code works anywhere on Windows such as text editors, on the web, forms, and so on.
The Heart alt code shortcut for Mac is Option + 2661.
Obey the following steps to type ♥ on Mac:
First of all, place your insertion pointer where you need the Heart symbol.
Then press Option + 2661 simultaneously on your Mac keyboard.
These keystrokes will give the ♥ symbol.
The alt code method of typing symbols is very popular on the Windows operating system.
However, the way you use alt codes on Windows is very different from that of Mac. Most people even think that it’s impossible to use alt code shortcuts in Mac.
As you may already know, the standard apple keyboard also has two alt keys. They are named as Options or ⌥ with a small “alt” label. Though, some of the newest Apple keyboards such as the Magic Keyboard no longer include the “alt” label. But the Option key is also the Alt key on the Mac keyboard, which means that it can be used as an Alt key with non-Mac software.
Does it mean that you can press down the Option key while you type the Heart alt code on your Mac keyboard?
No please. It doesn’t work this way with Mac.
Apple has its way of doing things. So instead of using the Alt or Option key with difficult-to-remember number codes like Microsoft Word, they combined the alt key with some other keys that will make shortcuts easy to remember.
So, if you want the Heart Alt code for Mac, it is the shortcut you may already know, which is Option + 2661.
Update the detailed information about Use These Keyboard Shortcuts To Quickly Move Around In Bash on the Bellydancehcm.com website. We hope the article's content will meet your needs, and we will regularly update the information to provide you with the fastest and most accurate information. Have a great day!