StudySolution
  • Assignment Solution
    • AIOU Assignment Solutions
    • VU Assignment Solutions
  • Books and Notes
  • Results
  • Date Sheets
  • Past Papers
  • Jobs
    • Latest Govt Jobs
    • Latest Private Jobs
  • Blogs
    • Local Blog
    • International Blog
  • Test Preparation
  • PSL 2021LIVE
No Result
View All Result
  • Assignment Solution
    • AIOU Assignment Solutions
    • VU Assignment Solutions
  • Books and Notes
  • Results
  • Date Sheets
  • Past Papers
  • Jobs
    • Latest Govt Jobs
    • Latest Private Jobs
  • Blogs
    • Local Blog
    • International Blog
  • Test Preparation
  • PSL 2021LIVE
No Result
View All Result
StudySolution
No Result
View All Result
Home Uncategorized

MS Excel Shortcut Keys

admin by admin
January 12, 2021
in Uncategorized
2
0
SHARES
36
VIEWS
Share on FacebookShare on Twitter
Contents hide
1 Important MS Excel Shortcut Keys In Microsoft Excel
1.1 Related articles
1.2 MS PowerPoint Shortcut Keys
1.3 MS Word Shortcut Keys
1.4 General Program Shortcuts
1.5 Selecting Cells
1.6 Moving Around in a Worksheet or Cell
1.7 Formatting Cells
1.8 Editing Cells

Important MS Excel Shortcut Keys In Microsoft Excel

Even in case, you should be familiarized with Microsoft Excel. Then you may be taken aback from the quantity and wide range of keyboard short cuts you may utilize to boost work and make matters far more suitable. Now, does one expect you to incorporate these computer keyboard combos? Certainly not! Everyone’s requirements are very different. Therefore, a few will undoubtedly be useful for you than many others. When you grab a couple of fresh suggestions, it’s well worth every penny. We have tried to maintain the record straightforward and uncomplicated, therefore going right up on time and publishing it helps!

MS Excel Shortcut Keys

Related articles

MS PowerPoint Shortcut Keys

MS PowerPoint Shortcut Keys

January 12, 2021
MS Word Shortcut

MS Word Shortcut Keys

January 12, 2021

Additionally, through our listing of shortcuts is quite lengthy, it’s by no usually means a whole collection of each and each computer keyboard combo readily available in Excel. We have attempted to store it into the generally useful shortcuts. Also, you’re going to be pleased to understand that just about everyone these programs have existed for quite a while, therefore they ought to be helpful irrespective of what variation of Excel you are utilizing.

Ms-excel shortcuts Keys, if beginning with Microsoft Excel, figuring out a couple of ms-excel keys will decrease work period plus make it less difficult to utilize Excel. Utilizing the mouse to accomplish all of the duty lessens your productivity. Here will be the absolute most applied Excel shortcuts to use while dealing with Microsoft Excel. All these ms-excel Keyboard short cuts for newcomer works together versions of MS Excel 2003, ms-excel 2007, ms-excel 2010, ms-excel 2013, ms-excel 2016, ms-excel 2019 & business office 365. Inside this web site, you may discover how to use basic shine short cuts.


General Program Shortcuts

  • Ctrl+N: Create a new workbook
  • Ctrl+O: Open an existing workbook
  • Ctrl+S: Save a workbook
  • F12: Open the Save As dialog box
  • Ctrl+W: Close a workbook
  • Ctrl+F4: Close Excel
  • F4: Repeat the last command or action. For example, if the last thing you typed in a cell is “hello,” or if you change the font color, clicking another cell and pressing F4 repeats that action in the new cell.
  • Shift+F11: Insert a new worksheet
  • Ctrl+Z: Undo an action
  • Ctrl+Y: Redo an action
  • Ctrl+F2: Switch to Print Preview
  • F1: Open the Help pane
  • Alt+Q: Go to the “Tell me what you want to do” box
  • F7: Check spelling
  • F9: Calculate all worksheets in all open workbooks
  • Shift+F9: Calculate active worksheets
  • Alt or F10: Turn key tips on or off
  • Ctrl+F1: Show or hide the ribbon
  • Ctrl+Shift+U: Expand or collapse the formula bar
  • Ctrl+F9: Minimize the workbook window
  • F11: Create a bar chart based on selected data (on a separate sheet)
  • Alt+F1: Create an embedded bar chart based on select data (same sheet)
  • Ctrl+F: Search in a spreadsheet, or use Find and Replace
  • Alt+F: Open the File tab menu
  • Alt+H: Go to the Home tab
  • Alt+N: Open the Insert tab
  • Alt+P: Go to the Page Layout tab
  • Alt+M: Go to the Formulas tab
  • Alt+A: Go to the Data tab
  • Alt+R: Go to the Review tab
  • Alt+W: Go to the View tab
  • Alt+X: Go to the Add-ins tab
  • Alt+Y: Go to the Help tab
  • Ctrl+Tab: Switch between open workbooks
  • Shift+F3: Insert a function
  • Alt+F8: Create, run, edit, or delete a macro
  • Alt+F11: Open the Microsoft Visual Basic For Applications Editor

Selecting Cells

  • Shift+Left/Right Arrow: Extend the cell selection to the left or right
  • Shift+Space: Select the entire row
  • Ctrl+Space: Select the entire column
  • Ctrl+Shift+Space: Select the entire worksheet

Moving Around in a Worksheet or Cell

  • Left/Right Arrow: Move one cell to the left or right
  • Ctrl+Left/Right Arrow: Move to the farthest cell left or right in the row
  • Up/Down Arrow: Move one cell up or down
  • Ctrl+Up/Down Arrow: Move to the top or bottom cell in the column
  • Tab: Go to the next cell
  • Shift+Tab: Go to the previous cell
  • Ctrl+End: Go to the most bottom right used cell
  • F5: Go to any cell by pressing F5 and typing the cell coordinate or cell name.
  • Home: Go to the leftmost cell in the current row (or go to the beginning of the cell if editing a cell)
  • Ctrl+Home: Move to the beginning of a worksheet
  • Page Up/Down: Move one screen up or down in a worksheet
  • Alt+Page Up/Down: Move one screen to the right or left in a worksheet
  • Ctrl+Page Up/Down: Move to the previous or next worksheet

Formatting Cells

  • Ctrl+B: Add or remove bold to the contents of a cell, selected data, or selected cell range
  • Ctrl+I: Add or remove italics to the contents of a cell, selected data, or selected cell range
  • Ctrl+U: Add or remove underline to the contents of a cell, selected data, or selected cell range
  • Alt+H+H: Select a fill color
  • Alt+H+B: Add a border
  • Ctrl+Shift+&: Apply outline border
  • Ctrl+Shift+_ (Underline): Remove outline border
  • Ctrl+9: Hide the selected rows
  • Ctrl+0: Hide the selected columns
  • Ctrl+1: Open the Format Cells dialog box
  • Ctrl+5: Apply or remove strikethrough
  • Ctrl+Shift+$: Apply currency format
  • Ctrl+Shift+%: Apply percent format

Editing Cells

  • F2: Edit a cell
  • Shift+F2: Add or edit a cell comment
  • Ctrl+X: Cut contents of a cell, selected data, or selected cell range
  • Ctrl+C or Ctrl+Insert: Copy contents of a cell, selected data, or selected cell range
  • Ctrl+V or Shift+Insert: Paste contents of a cell, selected data, or selected cell range
  • Ctrl+Alt+V: Open the Paste Special dialog box
  • Delete: Remove the contents of a cell, selected data, or selected cell range
  • Alt+Enter: Insert a hard return within a cell (while editing a cell)
  • F3: Paste a cell name (if cells are named in the worksheet)
  • Alt+H+D+C: Delete column
  • Esc: Cancel an entry in a cell or the formula bar
  • Enter: Complete an entry in a cell or the formula bar

Read Next: Important MS PowerPoint Shortcut Keys In Microsoft Power Point

 

Tags: copy shortcut keyexcel shortcut keys pdfexcel shortcuts pdfhow to remove formula in excelpaste shortcutpaste special shortcutsave as shortcutselect all shortcutshortcut keys in computershortcut keys of computer a to zundo shortcut key
ShareTweetShare
Previous Post

MS Word Shortcut Keys

Next Post

MS PowerPoint Shortcut Keys

Related Posts

MS PowerPoint Shortcut Keys

MS PowerPoint Shortcut Keys

by admin
January 12, 2021
2

Important MS PowerPoint Shortcut Keys In Microsoft Power Point Even if you should be familiar with Microsoft PowerPoint, you may...

MS Word Shortcut

MS Word Shortcut Keys

by admin
January 12, 2021
1

Important MS Word Shortcut Keys In Microsoft Word Even in case, you should be familiarized with Microsoft Word. You may...

Join PAF Latest Jobs 2021 PAF Online Registration 2021

Join PAF Latest Jobs 2021 PAF Online Registration 2021

by admin
January 4, 2021
0

Join PAF Latest Jobs 2021 PAF Online Registration 2021 Here in this post, we are sharing the Latest Jobs Join...

Computer MCQs

Computer MCQs

by admin
January 14, 2021
0

Computer Science MCQs Computer MCQs, Personal Computer System MCQs, MS Office, MS Excel, MSWord, MCQ on the Internet, MCQ Quiz,...

Month Wise Current Affairs Important MCQs

Month Of December Current Affairs MCQs

by admin
January 13, 2021
0

Month Wise Current Affairs Important MCQs Globe Current Affairs on line many choice questions (MCQs) Evaluation with replies 2020-21. These...

Load More
Next Post
MS PowerPoint Shortcut Keys

MS PowerPoint Shortcut Keys

0 0 vote
Article Rating
Subscribe
Login
Notify of
guest
guest
2 Comments
Oldest
Newest Most Voted
Inline Feedbacks
View all comments
trackback
NTS Computer MCQs Online With Answers For All Test PPSC ,FPSC,PTS, OTS
15 days ago

[…] MS Excel Shortcut Keys […]

0
Reply
trackback
Important MS Word Shortcut Keys In Microsoft Word
15 days ago

[…] MS Excel Shortcut Keys […]

0
Reply

Search Here

Advertisement

Recent Posts

  • ECO 401 Assignment No 2 Solution Fall 2020
  • CS 614 Assignment No 3 Solution Fall 2020
  • ENG 101 Assignment No 1 Solution Fall 2020
  • STA 301 Assignment No 2 Solution Fall 2020
  • PHY 301 Assignment No 2 Solution Fall 2020

Advertisement

Test Preparation MCQs

General Knowledge MCQs

Computer Science MCQs

Islamic Studies MCQs

Current Affairs MCQs

Pak Study MCQs

English MCQs

Math MCQs

Sponsored

This Website is Protected by DMCA

DMCA.com Protection Status
  • About
  • Contact Us
  • Privacy Policy
  • Terms Of Use

©2019-2021 StudySolution. All Right Reserved

No Result
View All Result
  • Assignment Solution
    • AIOU Assignment Solutions
    • VU Assignment Solutions
  • Books and Notes
  • Results
  • Date Sheets
  • Past Papers
  • Jobs
    • Latest Govt Jobs
    • Latest Private Jobs
  • Blogs
    • Local Blog
    • International Blog
  • Test Preparation
  • PSL 2021

©2019-2021 StudySolution. All Right Reserved

wpDiscuz
2
0
Would love your thoughts, please comment.x
()
x
| Reply