#Excellopedia

[excellopedia]

Add A-Z Alphabet Sequence in Excel using the formula

[excellopedia]

#microsoftexcel, #exceltips, #exceltutorials

[excellopedia]

The Address bar or Name box will show the address of the active cell or selected cell in the Excel worksheet.

Other than showing the address of the cell, the name box has some other helpful features that so many don’t know about. The name box can also be used as a navigation tool in Excel.

If you’re working on a large excel sheet, scrolling and moving around is a little tricky and sometimes we are not able to find the exact cell easily that we are looking for. Using the name box we can easily move around in a workbook and find any cell in a jiffy. Here in this tutorial, you can see how to use the Excel Name Box effectively.

[excellopedia]

Ribbon in Excel:

What is a Ribbon in Excel?

Excel has so many options and features and these all are grouped into tabs. The ribbon is like a strip consisting of these tabs placed above the worksheet area and below the title bar. The ribbon is designed to help you find the command easily from the set of tabs which helps to complete the task.

Excel Ribbon provides instant access to the Excel help system, which allows us to search for information easily. Additionally, the ribbon provides the descriptive text of each command that is available on tabs. This means, whenever you hover the mouse over the command, it will display the use of that command.

[excellopedia]

Add Watermark in Excel

Sometimes you may need to add a watermark with “Confidential” on your excel reports or invoice with “Draft” or “Company Logo” before sharing them with others.

If you’re wondering how they add Watermark in Excel, then no need to think anymore.

In this tutorial, I’ll be sharing how to add, edit and remove watermarks in Excel easily.