Microsoft Excel – Mixed Cell Reference

Course - Fun With Excel

Mixed cell reference –

Mixed cell reference is a mixture of both relative and absolute cell reference. Here is mixed cell reference, either row is fixed and column is free or column is fixed and row is free.
Like in case of,
= $A5 + B$1

Here in this formula, column A is fixed while row 5 will be changed when we copied formula. Similarly, row 1 is fixed while column B is free and can be changed by copying a formula from one place to another.

Do you know?

What’s a right method of learning?

Making your own notes makes things easier to understand and memorize. Well, in next lesson you will going to learn inserting Charts in worksheet.

Charts –

Charts are a graphical method to represent the report or data to make it easier to understand. Charts can be used be –

1. Presentation
2. Reports
3. Articles

You can insert charts in your worksheet of your choice. Follow these steps to insert charts –

1. Go to the Insert tab.
2. Under insert tab menu you will see a Chart section.
3. Now choose any chart of your choice.
4. Selected chart will be appear in your workbook.