Trending February 2024 # 20 Excel Keyboard Shortcuts That Will Impress Your Boss # Suggested March 2024 # Top 7 Popular

You are reading the article 20 Excel Keyboard Shortcuts That Will Impress Your Boss updated in February 2024 on the website 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 March 2024 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.


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


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:


To select the entire column:


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:


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:


To insert the current time, use the keyboard shortcut:


#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:


To go to the next worksheet:


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):


#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:


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:


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:


#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:


#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:


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:


These are my top 20 Excel keyboard shortcuts. I am sure you have some of your own too.

Useful Excel Resources:

You're reading 20 Excel Keyboard Shortcuts That Will Impress Your Boss

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.


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


Ps4 Accessories That Will Make You Love Your Console More!

PS4 Accessories that will make you love your console more!

So, what are we waiting for let’s read further to know more about PS4 accessories that you should consider buying.

PlayStation 4 Accessories you must purchase:

Sony provides various gaming PS4 accessories, that you can consider buying. For you, here we list best of them. Use them to enhance your gaming experience:


If you are into virtual reality then you should buy PSVR. It allows you to play games in virtual reality. It comes with 5.7 OLED screen which gives clear and immersive 3D experience. Moreover, it comes with 360 degree vision and can deliver 120 frames per second.

PSVR is compatible with PS4 pro, PS4 slim, and PS4.  PSVR includes PS4 camera that can be used for Live broadcasting, Facial recognition, Voice commands, and Tracking.

2. Extra Dualshock 4

PS4 console comes with a single Dualshock 4 controller only. However, if you want to play with your friends, an extra Dualshock 4 controller is required. Therefore, we suggest buying PS4 bundle that comes with an extra controller. It is cost effective, using it you can play current running games without charging the controller. What you need to do is simply charge extra PS4 controller accessories and play with it.

3. PS4 vertical stand


Are you falling short of space to place your PS4? If yes, try using PS4 stand. This will make your PS4 stand vertically. You can purchase it separately from any online store. Vertical stand helps saving space and gives PS4 a different upright look. You can find different types of vertical stands for your PS4. One that can charge your controllers are the best, as they let you play without worrying about charging your controller.


5. Dualshock 4 Controller charging dock


If you have multiple Dualshock 4 controllers, charging dock is a must have accessory. Charging dock charges multiple Dualshock 4 controllers at once. So, that you do not have to worry about charging your controller in between the game. Simply swap your current Dualshock 4 controller with the charged one and resume playing.

6. PS4 camera:


8. Official license products for PS4 by SONY:

There are several products available in market that are officially licensed by Sony. Some of the accessories are T80 Racing Wheel, Playseat® Gran Turismo, and Playseat® Evolution, if you are a fan of racing games then these official licensed product will increase your gaming experience.

Also Read: Top Free Games You Can Play on Your PS4

These are some of the PlayStation 4 accessories that you can purchase and enhance your gaming experience. PS4 alone cannot provide the gaming experience you are looking for. To enjoy your PS4 to the fullest try using these accessories.

Quick Reaction:

About the author

Kunal Sharma

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.

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 20 Excel Keyboard Shortcuts That Will Impress Your Boss on the 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!