
Customize the Quick Access Toolbar in Office Excel
The small buttons at the top-left side of the Excel screen are known collectively as the Quick Access Toolbar. By default, the Quick Access Toolbar contains three commands: Save, Undo, and Redo. If you click the drop-down selection arrow next…

Understanding Contextual Tabs in Office Excel
Contextual tabs are special types of tabs that appear only when a particular object is selected, such as a chart or a shape. These contextual tabs contain commands specific to whatever object you are currently working on.
For example, after…

Familiarizing with the Ribbon Menu and Tabs in Office Excel
Like any other application, Excel has a basic workspace called the user interface. A user interface is the combination of screens, menus, and icons you use to interact with an application. In Excel, the user interface is primarily composed…

Understanding Workbooks and Worksheets in Excel
An Excel file, often referred to as a workbook, contains one or more spreadsheets, or worksheets. Each box in the worksheet area is referred to as a cell. Each cell has a cell address, which is composed of a column reference and a row…

How to protect your computer from Ransomware
Ransomware is malicious software that cybercriminals use to hold your computer or computer files for ransom, demanding payment from you to get them back. Sadly, ransomware is becoming an increasingly popular way for malware authors to extort…

What is INSERT Tab and it's uses in Office Excel
We use Insert tab to insert the picture, charts, filter, hyperlink etc. We use this option to insert the objects in Excel. To open the insert tab, press shortcut keys Alt+N.
Insert tab contains 10 (ten) groups:
Tables
Apps
…

What is HOME Tab and it's uses in Office Excel
Home tab contains the most frequently used options such as cut-copy-paste, font formatting, alignment, Number, Conditional formatting, etc. All the options are used to format the data.
Home tab contains 7 (Seven) groups:
Clipboard
…

What is REVIEW Tab in Office Excel
Review tab contains the editing feature, comments, track changes and workbook protection options. These features make it easy to share the data with the proper information whilst ensuring the security of data.
Review tab contains 4 (four)…

Use Page Layout view to fine-tune pages before printing in Office Excel
Before you print a Microsoft Office Excel worksheet that contains a large amount of data or multiple charts, you can quickly fine-tune it in the Page Layout view to achieve professional-looking results. As in Normal view, you can change the…

How To: Unhide Multiple Work Sheets at once in Microsoft Office Excel
Learn a few different ways to unhide (show) multiple sheets at the same time with a VBA macro or add-in.
As you probably know, you cannot unhide multiple sheets at the same time in Excel. The Unhide menu only allows you to select one sheet…