100 Most Important Excel Keyboard Shortcuts you Must be Know

100 Most Important Excel Keyboard Shortcuts you Must be Know

I am new to Computer Operating ,So i do not know ,how to manage Excel Sheets and Keyboard Shortcuts to operate computer fast ,here covered  Important Excel Keyboard Shortcuts which you must be know.

If you are an expert in the most complex Microsoft software, Excel, you should read this article and save it for future use. In this article you will find 200 Excel shortcuts that will help you speed up the program and increase your perfection skills.
100 Most Important Excel Keyboard Shortcuts you Must be Know

In the 21st century we can say that you have learned to use Microsoft Excel, which is essential for a variety of tasks and functions, because it is possible to perform automated math operations, convert data to charts, analysis and forecasts, schedules or inventories. . management, among many other applications.

To learn how to use Excel as an expert, you have many resources, such as Web site articles, YouTube videos, and more.

By using material forums, interactive or video tutorials, you can benefit from this software, but beyond theory, you have to work hard to automate the key functions of Excel.

So what are you waiting for? Now, let's go to the shortcuts.

CTRL + direction key: Scroll to the end of the current data region
HOME:  Go to the beginning of a row
CTRL + HOME: Go to the beginning of a spreadsheet
CTRL + END: Go to the last cell of the spreadsheet.
AV PAGE: Scroll down one screen
RE PAGE: Scroll up one screen
ALT + AV PAGE: Move a screen to the right
ALT + RE PAGE: Move a screen to the left
CTRL + AV PAGE: Go to next book sheet
CTRL + RE PAGE:  Go to the previous sheet of the book
CTRL + F6 or CTRL + TAB: Go to next book or next window
CTRL + SHIFT + F6 or CTRL + SHIFT + TAB: Go to the previous book or window
F6: Move to the next panel of a book that has been split
SHIFT + F6: Move to the previous panel of a book that has been split
CTRL + BACKSPACE: Scroll to view the active cell
F5:  Display the Go To dialog box
SHIFT + F5: Display the Find dialog box
SHIFT + F4: Repeat the last Find action (same as Find Next)
TAB: Move Between Unlocked Cells on a Protected Worksheet
END: Enable or disable End mode
END + direction key: Move a block of data within a row or column
END + START: Go to the last cell of the spreadsheet.
END + ENTER: Go to the last cell to the right of the current row that is not blank.
CTRL + P or CTRL + SHIFT + F12: Display the Print dialog box
SHIFT + F11 or ALT + SHIFT + F1: Insert a new spreadsheet
F11 or ALT + F1: Create a chart that uses the current range
ALT + F8: Displaying the Macro Dialog Box


ALT + F11:  Show / Hide the Visual Basic Editor
CTRL + F11: Insert a Microsoft Excel 4.0 Macro Sheet
CTRL + AV PAGE: Go to next book sheet
CTRL + RE PAGE: Go to the previous sheet of the book
SHIFT + CTRL + PAGE UP: Select the current sheet and the next sheet of the book
SHIFT + CTRL + RE PAGE: Select the current sheet and the previous sheet of the book
ENTER: Complete a cell entry and scroll down in the selection
ALT + ENTER: Start a new line in the same cell
CTRL + ENTER: Fill in the selected cell range with the current entry
SHIFT + ENTER: Complete a cell entry and scroll down in the selection
TAB Complete a cell entry and go to the right in the selection
SHIFT + TAB: Complete a cell entry and go to the left in the selection
ESC: Cancel a cell entry
DELETE: Delete the character to the right of the insertion point or remove the selection
CTRL + DELETE: Delete text to the end of the line
F4 or CTRL + Y; Repeat the last action
SHIFT + F2: Modify a cell comment
CTRL + SHIFT + F3: Create names from row and column labels
CTRL + J: Fill Down

CTRL + D: Fill to the right
CTRL + F3: Define a name
CTRL + SHIFT + A: Insert the argument names and parentheses of a function, after typing a function name in a formula
CTRL + ALT + K: Insert a hyperlink
ENTER (in a hyperlinked cell): Enable a hyperlink
F2: Modify the active cell and place the insertion point at the end of the line
F3: Pasting a Name Defined in a Formula
SHIFT + F3: Pasting a Function in a Formula
F9: Calculate all sheets of all open workbooks
CTRL + ALT + F9: Calculate All Sheets in the Active Book
SHIFT + F9: Calculate the active sheet
= (equal sign): Start a formula
ALT + = (equal sign): Inserting a AutoSum formula
CTRL +; (semicolon) : Enter the date
CTRL + SHIFT + : (colon) Enter the time
CTRL + SHIFT + “(quotation marks): Copy the value of the cell above the active cell in the cell or in the formula bar
CTRL + `(single left quotation mark) : Toggle between displaying values or formulas in cells
CTRL + ‘(apostrophe): Copy a formula from the cell above the active cell in the cell or in the formula bar


ALT + DOWN ARROW : Display AutoComplete list
ALT + ‘(apostrophe): Display the Style dialog box
CTRL + 1:  Display the Format Cells dialog box
CTRL + E: Apply General Number Format
CTRL + SHIFT + $:  Apply the Currency format to two decimal places. Negative numbers appear in red.

CTRL + SHIFT +%: Apply Percentage Format Without Decimals
CTRL + SHIFT + ^: Apply the Exponential numerical format with two decimal places
CTRL + SHIFT + #: Apply the format Date with day, month and year
CTRL + SHIFT + @: Apply the format Hora with the hour and minutes and indicate am or pm
CTRL + SHIFT + !: Apply the format Number with two decimals, separator of thousands and minus sign (-) for negative values
CTRL + SHIFT + &: Apply a border
CTRL + SHIFT + _: Remove Contours
CTRL + N:  Apply or Remove Bold Format
CTRL + K: Apply or remove italic formatting
CTRL + S: Apply or Remove Underline Formatting
CTRL + 5: Apply or Remove Strikethrough Format
CTRL + 9: Hide Rows
CTRL + SHIFT + ((opening parenthesis):  Show rows
CTRL + 0 : Hide columns
CTRL + SHIFT +) : Show columns
CTRL + SHIFT + *:  Select the current region around the active cell
SHIFT + direction key : Enlarge selection one row or column
CTRL + SHIFT + direction key: Enlarge the selection to the last non-blank cell in the same column as the active cell
SHIFT + HOME: Zoom into the beginning of the row
CTRL + SHIFT + HOME: Enlarge the selection to the beginning of the spreadsheet
CTRL + SHIFT + END: Enlarge the selection to the last cell used in the datasheet
CTRL + SPACEBAR:  Select entire column
SHIFT + SPACEBAR: Select the entire row
CTRL + SHIFT + SPACEBAR: Select the entire spreadsheet
SHIFT + BACKSPACE:  Select only the active cell when multiple cells are selected
SHIFT + PAGE UP: Enlarge the selection one screen down
SHIFT + PAGE UP: Enlarge the selection one screen up
CTRL + SHIFT + SPACEBAR: With a selected object, select all the cells on a sheet
CTRL + 6: Toggle between hiding objects, displaying them, or displaying object markers
CTRL + 7: Show or hide the Standard toolbar
F8: Activate the enlargement of a selection using the arrow keys
SHIFT + F8: Add another range of cells to the selection; or use the arrow keys to move to the beginning of the range you want to add, and then press F8 and the arrow keys to select the next range
DESP LOCK, SHIFT + HOME: Zoom into the cell in the upper left corner of the window
DESP LOCK, SHIFT + END: Enlarge the selection to the top right cell of the window


I hope this article will help you highlight your knowledge in Excel spreadsheets. If you have problems with the shortcut keys, please let us know in the box below. We will return as soon as possible to resolve all your questions.



Comments

Post a Comment

Most Useful Articles

How to Make Blogger BlogSpot Layout As Responsive Template

Image
How to Make Blogger BlogSpot Layout As Responsive Template Are you working on Blogger BlogSpot?As we all know, BlogSpot Layout is not Responsive but still using Blogger, Here is a solution to make a Blog mobile Friendly Template and responsive layout. There are two ways to make your Blogspot Responsive, so simply follow these steps to customize Your Blogger Blogspot Template. As well, you can use  recently Blogspot Introduced New Responsive themes or mobile-friendly templates to make your blog responsive. 1.First Way to make BlogSpot as Mobile Friendly Template Go to the Blogger Dashboard and Select the Custom View Button, then  Choose Mobile Theme . Now, go to the Theme and search for the  widget which you want to display in Mobile View . Copy and paste this code into your blog HTML template- <b:widget id='PopularPosts1' locked='false' mobile='yes' title='Popular Posts' type='PopularPosts'>   Now Save your Theme a
Read more

How to Show Blogger Widgets in Mobile View with Simple Steps

Image
How to Show Blogger Widgets in Mobile View with Simple Steps Since I don't have any guide to create a blogger when I saw my blog in mobile view, I shocked, some important widgets are missing, I asked my self why widgets are not showing in the mobile template. Then I bit confused. As we all know, today's most content search visitors are from Mobile devices than common laptops and desktops. So showing widgets on mobile templates must. I felt very bad for now seeing my blogger widgets in mobile view. To increase the blog traffic from mobile view, we have to show them at least popular posts widget, about us widget and Facebook like the page. These are the most important things for every blogger to satisfy the blog visitors and to increase visitor interest. Finally, I got a solution that is useful. After knowing it, laughing myself because it is very simple to show blogger widgets in the mobile template with simple steps. As I have learned this trick, to help new blogg
Read more

How to Create Internal Links within The Post in Blogger

Image
How to Create Internal Links within the post in Blogger To reduce the difficulty when users reading very lengthy posts, it is better to create internal links within the post  to jump to the matter which is interested in him. So thus we can decrease user efforts by creating bookmarks and when we are clicking on it, directly goes to its header. Thus anchor links are useful for viewers to read long post interestingly. Automatic internal links in blogger For achieving an  On-Page SEO strategy, we have to create automatic internal links in blogger. Here, you have to understand what is internal linking?. Using the  link strategy , you can increase on- SEO optimization. Visitors can get more deep information from visited to navigate through other related content. It increases your site and posts SEO performance. You can provide in-depth content for blog readers.  Two types are: Internal Internal linking is we are linking our own blog referred posts with anchored texts within the p
Read more

How to Get Back A Hacked Facebook Account and Secure within 10 Steps

Image
How to Get Back A Hacked Facebook Account and Secure within 10 Steps One Day, My friend Asked Me that His account is hacked and its password email id setting also has been changed. On that question, I have started writing this Post to get back Hacked Facebook Account and Secure with the following Steps. How to Increase Organic Reach on Facebook How to Get More Likes On Facebook Fan Page How Many Ways Can I Earn Money from Facebook How to Set Up Facebook Business Manager : FBM Tutorial How to Share Your WhatsApp Status Updates to Facebook Stories and Other Apps  Some of my friends asked me, can we recover my  FB Account without email or can we get back my id  through friends' Facebook Id or Gmail, is it possible to use an old password? Another one posted to me that His email also had been changed, he asked? what can I do? , and  Password to be changed. My neighbor asked, his Facebook account Locked and How to delete it? For all these questions, I found this solut
Read more

How to Display Blogger Posts in Grid View with Thumbnails

Image
How to Display Blogger Posts in Grid View with Thumbnails In a Blogger, as a default, all posts are showing top to bottom in the lengthy bar But here I am sharing Grid view with thumbnails for the blogger posts on the home page and related posts in the short view which reduces users difficulty to show all posts in the grid view which user can select his required post immediately and he will put more interest on the additional posts if he needs. Grid view attracts more visitors and increases the views of our blogger posts. Thumb nails also play a very important role in what is the post in the one view. So you might have known list view templates in the grid style. In my opinion, you have to reduce the complex long scrolling problems for page visitors to choose an interesting article. In the below image, you can see the grid view with thumbnail posts. Start Adding Grid view to Blogger Posts Now, Go to the Blogger Dashboard ->Click on Theme Button->choose the EDIT H
Read more

Blogger Login Google Account: How to Create a New Google Account(Gmail)

Image
Blogger Login Google Account Creating a free Blogger Blogspot, we need Login Google Account for that we have to create Gmail Account initially, next create Blogger. Keeping the beginner bloggers requirement in my mind, I am sharing this article. Blogger Blogspot whether you are a skilled person or unskilled, you can create a unique and beautiful blog. It’s easy and free. Choose the Blog design theme according to your requirement. Now free responsive and static templates are available from blogger Blogspot. You can get a free domain and if you have good traffic for your Blogspot they will pay you through Google Adsense for your hard work. Google AdSense can automatically display relevant targeted ads on your blog.  You can find the most searched keywords to reach more audiences. You can know more about your blog traffic, where they are coming from, what they are searching for about your posts through Google Analytics . You can use a blogger for posting your fa
Read more