Trending December 2023 # Use These Keyboard Shortcuts To Quickly Move Around In Bash # Suggested January 2024 # Top 19 Popular

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.

Odysseas Kourafalos

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.

By signing up, you agree to our Privacy Policy and European users agree to the data transfer policy. We will not share your data and you can unsubscribe at any time.

You're reading Use These Keyboard Shortcuts To Quickly Move Around In Bash

Top 50+ Keyboard Shortcuts To Use In Brave Browser (Mac, Windows)

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 / Linux

17. 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

Related:

Microsoft Excel Keyboard Shortcuts – Webnots

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.

ShortcutDescriptionCategory

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

Create Custom Keyboard Shortcuts For Anything In Windows 10

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 Contents

Open 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 overlay

Summary

20 Excel Keyboard Shortcuts That Will Impress Your Boss

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:

Heart Alt Code Shortcuts On The Windows And Mac Keyboard

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!