Excellopedia

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.

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.

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.

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.

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.

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.