Skip to main content

Microsoft Excel Keyboard Keys

You could learn here about MS excel basis and some advance sort keys.

Formatting sort keys.
CTRL+1                    Format Box
ALT+E+S+T             Copy Format
ALT+H+0                 Increase Decimal
ALT+H+9                 Decrees Decimal
 CTRL+SHIFT+7     Boxing
ALT+O+C+A            Fit Column Width
ALT+H+O+R            Change Sheet Tab Name
ALT+W+F                (Un)Split Panes
ALT+W+S                 (Un)Freeze Panes
SHIFT+CTRL+#       Date format
SHIFT+CTRL+S      $ Dollar format
SHIT+CTRL+%       % Percentage format
ALT+"="                   Sum function

With CTRL Shortcuts.
CTRL+A       Select All
CTRL+B         Bold (only selected cell or range)
CTRL+C         Copy(only selected cell or range)
CTRL+D         Fill down(Select non blank cell or range)
CTRL+E          Flash Fill
CTRL+F          Find
CTRL+G         Go To Special
CTRL+H         Replace
CTRL+I           Italic
CTRL+K          Insert Hyperlink
CTRL+L          Create Table
CTRL+N          New Workbook
CTRL+O          Open existing workbook from your computer
CTRL+P           Print
CTRL+R           Fill Right 
CTRL+S           Save workbook 
CTRL+T          Create Table

CTRL+U          Under Line
CTRL+V          Paste
CTRL+W        Close workbook
CTRL+X         Cut
CTRL+Y         Redo
CTRL+Z         Undo

Function Key  Shortcuts.
F1      Go to excel help penal
F2      Edit cell
F3      Show all Name rage list(once you create name range)
F5      Go To Special
F6      Move on Excel status bar
F7      Check spellings
F8      Extend selection
F9       Calculation
F10     Ribbon Negation
F11      Insert chart sheet
F12     Save as workbook  

Columns & Row Shortcuts.
CTRL+9                       Hide row
SHIFT+CTRL+9        Unhide row 
CTRL+0                       Hide column
SHIFT+CTRL+0        Unhide column
SHIFT+Space-bar      Highlight row ( Select entire row)
SHIFT+Space-bar      Highlight column  ( Select entire column)
CTRL+"+"(Sign)         Show insert popup window when you select only one cell
CTRL+"+"(Sign)         Insert entire row or column when you select entire row or column
CTRL+Arrow keys      Fast select last non-blank cell
CTRL+SHIFT+Arrow keys  Fast select last non-blank cell with range selection
CTRL+PAGE UP         Switch  worksheet active sheet to backward
CTRL+PAGE DOWN  Switch worksheet active sheet to forward
CTRL+HOME               Select active sheet A1 cell
CTRL+END                   Select last cell of used range of active sheet
CTRL+INSET               Copy current selection
SHIFT+DELETE          Cut current selection
ALT+E+L                        Delete active worksheet
ENTER                            Move down
SHIFT+ENTER             Move up
CTRL+ENTER              Fill the same in current selection range ( Note:- Once select a range and than press F2 and type something and than use ctrl+enter)


Comments

Post a Comment

Popular posts from this blog

Know about Excel Tables

23 things to know about Excel Tables by Dave Bruns | May 17, 2018 Excel Tables have a boring (and confusingly generic) name, but they are packed with useful features. This article is a summary of the things you should know about Excel Tables. 1. Creating a table is fast You can create an Excel Table in less than 10 seconds. First, remove blank rows and make sure all columns have a unique name, then put the cursor anywhere in the data and use the keyboard shortcut Control + T. When you click OK, Excel will create the table. 2. Navigate directly to tables Like named ranges, tables will appear in the namebox dropdown menu. Just click the menu, and select the table. Excel will navigate to the table, even if it's on a different tab in a workbook. 3. Tables provide special shortcuts When you convert regular data to an Excel Table, almost every shortcut you know works better. For example, you can select rows with shift + space, and columns with control ...
Post a Comment
Read more

How to use Pivot Table in MS Excel

Pivot Tables in Excel: How to Use the PivotTable Function The PivotTable function is one of the most widely used features of Microsoft Excel. It allows you to analyse and visualise data in various ways that can provide deep insights. If you have never used pivot tables in Excel or would like to build on your basic knowledge, you’re in the ExcelzerotoHero (Note: PivotTable is the trademarked term for Microsoft Excel’s pivot table function) By the time you finish this article, you should have a firm grip on how to create a pivot table in Excel. We will also cover the basics of how to view the same data in different ways using the PivotTable feature. We’ve also provided the worksheet shown in the examples so you can follow each step as you read. First, imagine a simple dataset like the following. This is a simple data set, but large enough to work with. Notice that...
Post a Comment
Read more

Getting Started

E xcel is a massive application with 1000s of features and 100s of ribbon (menu) commands. It is very easy to get lost once you open Excel. So one of the basic survival skills is to understand how to navigate Excel and access the features you are looking for. When you open Excel, this is how it looks. There are 5 important areas in the screen. 1. Quick Access Toolbar : This is a place where all the important tools can be placed. When you start Excel for the very first time, it has only 3 icons (Save, Undo, Redo). But you can add any feature of Excel to to Quick Access Toolbar so that you can easily access it from anywhere (hence the name). 2. Ribbon : Ribbon is like an expanded menu. It depicts all the features of Excel in easy to understand form. Since Excel has 1000s of features, they are grouped in to several ribbons. The most important ribbons are – Home, Insert, Formulas, Page Layout & Data. 3. Formula Bar : This is where any calculations or form...
Post a Comment
Read more