Excel Tip (Multiplication)

Quantity surveyors, Accountants and others who are always/often using the MS Excel, sometime they used to feel uncomfortable when accessing Excel. Because of time. There are expert using many formulas in excel, it will save the time & to be accurate.

Here one small tips added, when multiplying the 2 or more cells if we use the normal formula like =ROUND(C6*E6,3)[See the Figure No.1], we wants to paste on every cells, only where required. Unless if we tracked that formula, then it will show 0.000 value, where multiple factors’ cells are blank.

Table No.1

To avoid this, the following formula will useful.=IF(C6="","",C6*E6) [See the Figure No.2],

Table No.2

Try it on your work.

Freeze Pans

What is the use of Freeze Panes?

Keep a portion of the sheet visible while the rest of the sheet scrolls.

How to apply the Freeze Panes?

Follow the given instruction

Highlighted (3 rows) rows keep while the rest of the sheet scrolls


Without any action, if we scroll, it will work normal. See this figure

Now we select the cell (Blue colour highlighted) (Whenever we select the next rows first cell of which are the Rows keep rest)

Now; Click “View” then Select “Freeze Panes”

Now Scroll, Your required rows keep in top rest of part will scroll.