excellopedia

[excellopedia]

#microsoftexcel, #exceltips, #exceltutorials

[excellopedia]

Add A-Z Alphabet Sequence in Excel using the formula

[excellopedia]

Paste Options in Excel:

By default, when you copy and paste the data in Excel, everything in the source cell will be pasted into the destination cell when you use CTRL + V. It’s not the only way. Excel has so many paste options depending on our needs.

The paste options feature lets you choose how to paste the copied content into the destination cell. When you copy the data, Excel saves the data to the clipboard. When you paste the data, you can access the paste options menu to control how the data is pasted using the available paste options.

click here to read the full post to know more about paste options.

https://excellopedia.com/paste-options-in-excel.html

[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.

[excellopedia]

Fix – Cursor not moving between the cells when using arrow keys in Excel:

sometimes when you are using the arrow keys to move the cursor to the above or below cell but the excel sheet is scrolling up and down.

Do you know why this happens??

In this tutorial, I’ll explain how to fix Cursor to move between the cells when using arrow keys in Excel.

[excellopedia]

Excel Keyboard Shortcuts:

If you want to excel in the Excel application, you need to learn and start using the keyboard shortcuts. Learning and using keyboard shortcuts will save a lot of time. Every time going to ribbon and finding the required option is time-consuming so every Excel user should learn minimum basic keyboard shortcuts.

[excellopedia]

Excel Introduction & Basics

Now a day, everybody should have minimum basic knowledge before applying for any job. From small companies to big-scale industries, all departments are using excel to complete their daily tasks.

In order to survive in the present competitive world, everybody should have basic knowledge of Microsoft Excel. This post is for beginners who are fascinated to learn Microsoft Excel to achieve their goals.