Microsoft Excel Shortcut Keys
Hello friends! I am Smruti Ranjan, Welcome to all of you to my website. Have a nice day. If you are searching for "Microsoft Excel Shortcut Keys" then you are in right place. Read this article and learn about Microsoft Excel Shortcut Keys. Please follow us and subscribe our site to get more knowledgeable topics about computer. Don't forget to share with your friends and like our posts. Do good comments to encourage us.
Explore Window in Excel 2010
The following basic window appears when you start the Excel application. Let's now understand the various important parts of this window.
File Tab :-
The file tab replaces the office button from Excel. You can click on it to check the backstage view, where you come when you need to open or save files, create new sheets,
print a sheet and do other file related operations.
Quick Access Toolbar :-
You will find this toolbar just above the file tab and it's purpose is to provide a convenient resting place for the excel's most frequently used commands. You can customize this toolbar based on your comfort.
Ribbon :-
Ribbon contains commands organized in three (3) components :-
(i) Tabs :- They appear across the top of the ribbon and contain groups of related commands. Home, Insert, Page layout are the examples of ribbon tabs.
(ii) Groups :- They organize related commands; each group name appears below
the group on the Ribbon. For example, group of commands related to fonts or group of commands related to alignment etc.
(iii) Commands :- Commands appear within each group as mentioned above.
Title bar :-
This lines in the middle and at the top of the window. Title bar shows the program and the sheet titles.
Help :-
The help icon can be used to get excel related help anytime you need. It provides nice tutorial on various subjects related to excel.
Zoom Control :-
Zoom control let's you zoom in for a closer look at your text. The zoom control consists of a slider that you can slide left or right to zoom in or out. The + buttons can be clicked to increase or decrease the zoom factor.
View Buttons :-
The group of three buttons located to the left of the zoom control, near the bottom of the screen, let's you switch among excel's various sheet views.
(i) Normal Layout View :- It displays the page in normal view.
(ii) Page Layout View :- It displays pages exactly as they will appear when printed. It gives a full screen look of the document.
(iii) Page Break view :- It shows a preview of where pages will break when printed.
Sheet Area :-
Sheet area is the area where you enter data. The flashing vertical bar is called the insertion point and it represents the location
where text will appear when you type.
Row bar :-
Rows are numbers from 1 onwards and keeps on increasing as you keep entering data. Maximum limit is 1,048,576 rows.
Column bar :-
Columns are numbered from A onwards and keeps on increasing as you keep entering data. After Z, it will start the series AA, AB, AC and so on. Maximum limit is 16,384 columns.
Status Bar :-
It displays the sheet information as well as the insertion point location. From left to right, this bar can contain the total number of pages and words in the document, language etc.
You can configure the status bar by right clicking anywhere on it and by selecting or deselecting options from the provided list.
Dialog Box Launcher :-
It appears as a very small arrow in the lower - right corner of many groups on the Ribbon. Clicking this button opens a dialog box or task pane that provides more options about the group.
Backstage View in Excel 2010
The backstage view has been introduced in Excel 2010 and acts as the central place for managing your sheets. The backstage view helps in creating new sheets, saving and opening sheets, printing and sharing sheets and so on.
Getting to the backstage view is easy. Just click the file tab located in the upper - left corner of the Excel Ribbon. If you already don't have any opened sheet then you will see a window listing down all the recently opened sheets as follows -
If you already have an opened sheet then it will display a window showing the details about the opened sheet as shown below. Backstage view shows three (3) columns when you select most of the available options in the first (1st) column.
First column of backstage view will have the
following options -
01. Save :- If an existing sheet is opened, it would be saved as is, otherwise it will display a dialogue box asking for the sheet name.
02. Save as :- A dialogue box will be displayed asking for sheet name and sheet type. By default, it will save in sheet 2010 format with extension .xlsx.
03. Open :- This option is used to open an existing sheet.
04. Close :- This option is used to close an opened sheet.
05. Info :- This option displays the information about the opened sheet.
06. Recent :- This option lists down all the recently opened sheets.
07. New :- This option is used to open or create a new sheet.
08. Print :- This option is used to print an working sheet.
09. Save & Send :- This option saves an opened sheet and displays options to send the sheet using email etc
10. Help :- You can use this option to get the required help about excel 2010.
11. Options :- You can use this option to set various option related to excel 2010.
12. Exit :- You can use this option to close the sheet and exit.
Microsoft Excel Shotrtcut Keys
01. Start formula :- =
02. Insert function :- Shift + F3
03. Sum :- Alt + =
04. Copy :- Ctrl + C
05. Paste :- Ctrl + V
06. Cut :- Ctrl + X
07. Select all :- Ctrl +A
08. Italic :- Ctrl + I
09. Bold :- Ctrl + B
10. Underline :- Ctrl + U
11. Increase font size :- Ctrl + ]
12. Decrease font size :- Ctrl + [
13. Save :- Ctrl + S
14. Find :- Ctrl + F
15. Replace :- Ctrl + H
16. Undo :- Ctrl + Z
17. Redo :- Ctrl + Y
18. Open :- Ctrl + O
19. Print :- Ctrl + P
20. Align left :- Ctrl + L
21. Algin right :- Ctrl + R
22. Algin center :- Ctrl + E
23. New document :- Ctrl + N
24. Zoom in/out :- Ctrl + Scroll
If you want to download the PDF of Microsoft windows shortcut keys, click on the bellow link.
Due to epidemic CORONA please stay in home and stay safe. Give respect to guidelines of our Govt and struggle/fight with COVID - 19.
Thanks to all of you. Keep visiting our website to get more knowledgeable posts on computer. Thank you, Smruti Ranjan Panda.
Nice post
ReplyDelete