.

.

Tuesday, May 10, 2016

Roshan Thpa

Excel: 3 Basic, Ribbon

Excel selects the ribbon's Home tab when you open it. Learn how to minimize and customize the ribbon.

Tabs

The tabs on the ribbon are: File, Home, Insert, Page layout, Formulas, Data, Review and View. The Home tab contains the most frequently used commands in Excel.
Home Tab
Note: the File tab in Excel 2010 replaces the Office Button in Excel 2007.

Minimize the Ribbon

You can minimize the ribbon to get extra space on the screen. Right click anywhere on the ribbon, and then click Minimize the Ribbon (or press CTRL + F1).
Minimize the Ribbon in Excel
Result.
Hidden Ribbon

Customize the Ribbon

Excel 2010 makes it possible to easily create your own tab and add commands to it. If you are new to Excel, you can skip this paragraph.
1. Right click anywhere on the ribbon, and then click Customize the Ribbon.
Customize the Ribbon
2. Click New Tab.
Click New Tab
3. Add the commands you like.
Add Commands
4. Rename the tab and group.
Rename Tab and Group
Note: you can also add new groups to existing tabs. To hide a tab, uncheck the corresponding check box. Click Reset, Reset all customizations, to delete all ribbon and Quick Access Toolbar customizations.
Result.
Custom Tab

Roshan Thpa

About Roshan Thpa -

Roshan Kumar Thapa is veteran keen tech-savvy person which has enabled him to qualify for the job. He has knowledge in wide range of IT fields. He is highly trained and skilled in Graphic design, Tally, A+ hardware and networking, AutoCAD, Web Design/Development, Application Development, Video editing, Q-Basic and had good knowledge of C, C++, C# and Java programming. He keeps a keen interest in information technology and loves to keep himself updated through news, magazines, books, and blogs. He likes to learn and share his knowledge. He also runs a blog where he posts updates about the latest advancements in technology and his own teachings as well.

Subscribe to this Blog via Email :