MICROSOFT EXCEL AND ITS ALL SHORTCUT KEYS

Iqra

MICROSOFT EXCEL AND ITS ALL SHORTCUT KEYS

Microsoft excel is a spreadsheet. MS-excel is a program which is used for calculations, making charts and recording data about all sorts of business processes. It is widely used all over the world. MS-excel is the most integral part of the most business organization across the world. It is used to establish many businesses. MS-excel has become a very simple interface that allows users to easily pick and easily understand this software and also used to perform basic activities without facing any type of problem. By using the excel user can create charts, organize data and perform the calculation at the very huge amount of numbers.

MS-excel is basically used for financially-related activities. The main reason for its fame is that the user can apply custom formulas for calculating the numeric values, half and annual reports of the organization. This software also helps the individuals and professionals members to effectively keep a track of sales, project reports, and invoice reports.ms-excel has been rightly called the word processing of the numbers. Because it works at numbers by applying some basic formulas like sum, sub, mul, div, if, if else and so on…

Founder:

Dan Bricklin is the founder of MS-excel. Developing the electronic spreadsheet, credit goes to Daniel Bricklin.

Here is the brief view of the excel history!

MS released the first version of MS-excel for the Macintosh on September 30, 1985

Value of MS-excel

There are many computer programs which are using in the computer for different purposes and for different use… But MS-excel is one of the most valuable because it plays a very major role in many sectors to keep their record safe and secure. It is mostly used for spreadsheets program in many business works, admin work and even personal data organization. The major advantage of MS-excel is that every calculation you can perform in the fraction of seconds. It facilitates us to keeping the data safer, keep the record of numbers of items which belong to any format and any business. The major factor of MS-excel is that you can apply one formula at long mathematics series. Basically, it’s contain on rows and columns. The horizontal rows are identified by numbers (1, 2, and 3) and vertical columns by letter of alphabet (a, b, c).

Types of data

Here are some types of data that a cell can hold is:

Numbers;

Text;

Dates and times;

Boolean values;

Formulas;

 

 

Current version

MS-excel 2016 is the latest version of excel.

Previous versions of MS-excel also include

Excel 2013,

Excel 2010,

Excel 2007,

Excel 2003.

Excel 2016 is more compatible with windows 8, windows 8.1 and windows 7.

Main uses of excel

Main uses of excel includes

Data entry

Data management

Accounting

Financial analysis

Charting and graphics

Task management

Almost everything that needs to be organized.

Complete list of ms-excel short-cut key

CTRL+A – SELECT ALL

CTRL+B – BOLD

CTRL+C – COPY

CTRL+D – FILL DOWN

CTRL+F – FIND

CTRL+G – GOTO

CTRL+H – REPLACE

CTRL+I – ITALIC

CTRL+K – INSERT HYPERLINK

CTRL+N – NEW WORKBOOK

CTRL+O – OPEN

CTRL+P – PRINT

CTRL+R – FILL RIGHT

CTRL+S – SAVE

CTRL+U – UNDERLINE

CTRL+V – PASTE

CTRL W – CLOSE

CTRL+X – CUT

CTRL+Y – REPEAT

CTRL+Z – UNDO

F1 – HELP

F2 – EDIT

F3 – PASTE NAME

F4 – REPEAT LAST ACTION

F4 – WHILE TYPING A FORMULA, SWITCH BETWEEN ABSOLUTE/RELATIVE REFS

F5 – GOTO

F6 – NEXT PANE

F7 – SPELL CHECK

F8 – EXTEND MODE

F9 – RECALCULATE ALL WORKBOOKS

F10 – ACTIVATE MENUBAR

F11 – NEW CHART

F12 – SAVE AS

CTRL+: – INSERT CURRENT TIME

CTRL+; – INSERT CURRENT DATE

CTRL+” – COPY VALUE FROM CELL ABOVE

CTRL+’ – COPY FORMULA FROM CELL ABOVE

SHIFT – HOLD DOWN SHIFT FOR ADDITIONAL FUNCTIONS IN EXCEL’S MENU

SHIFT+F1 – WHAT’S THIS?

SHIFT+F2 – EDIT CELL COMMENT

SHIFT+F3 – PASTE FUNCTION INTO FORMULA

SHIFT+F4 – FIND NEXT

SHIFT+F5 – FIND

SHIFT+F6 – PREVIOUS PANE

SHIFT+F8 – ADD TO SELECTION

SHIFT+F9 – CALCULATE ACTIVE WORKSHEET

SHIFT+F10 – DISPLAY SHORTCUT MENU

SHIFT+F11 – NEW WORKSHEET

SHIFT+F12 – SAVE

CTRL+F3 – DEFINE NAME

CTRL+F4 – CLOSE

CTRL+F5 – XL, RESTORE WINDOW SIZE

CTRL+F6 – NEXT WORKBOOK WINDOW

SHIFT+CTRL+F6 – PREVIOUS WORKBOOK WINDOW

CTRL+F7 – MOVE WINDOW

CTRL+F8 – RESIZE WINDOW

CTRL+F9 – MINIMIZE WORKBOOK

CTRL+F10 – MAXIMIZE OR RESTORE WINDOW

CTRL+F11 – INSET 4.0 MACRO SHEET

CTRL+F1 – FILE OPEN

ALT+F1 – INSERT CHART

ALT+F2 – SAVE AS

ALT+F4 – EXIT

ALT+F8 – MACRO DIALOG BOX

ALT+F11 – VISUAL BASIC EDITOR

CTRL+SHIFT+F3 – CREATE NAME BY USING NAMES OF ROW AND COLUMN LABELS

CTRL+SHIFT+F6 – PREVIOUS WINDOW

CTRL+SHIFT+F12 – PRINT

ALT+SHIFT+F1 – NEW WORKSHEET

ALT+SHIFT+F2 – SAVE

ALT+= – AUTOSUM

CTRL+` – TOGGLE VALUE/FORMULA DISPLAY

CTRL+SHIFT+A – INSERT ARGUMENT NAMES INTO FORMULA

ALT+DOWN ARROW – DISPLAY AUTOCOMPLETE LIST

ALT+’ – FORMAT STYLE DIALOG BOX

CTRL+SHIFT+~ – GENERAL FORMAT

CTRL+SHIFT+! – COMMA FORMAT

CTRL+SHIFT+@ – TIME FORMAT

Leave a Reply

Your email address will not be published. Required fields are marked *

%d bloggers like this: