Use Line Breaks In Complex Formulas To Make Them Easier To Read in MS Excel with Example

How to break complex/Long Formulas into multiple lines to make them easier to Read in Microsoft Excel with Example.

Everyone know that in Excel, he/she can get very creative with formulas and do things most users would never have thought possible. There is one drawbacks with long, complex formulas that they are often difficult to understand - especially when a person go back and look at them long after they were originally created.

Break Split Formulas into multiple lines

Many people don't know this but you can make complex, long formulas easier to read by breaking them into smaller parts on separate lines. You can insert line breaks in your Formulas & Functions- just like you can insert line breaks in text in a cell.

Breaks Excel Formulas into Lines

To break the next part of the formula to a new line just simply press ALT + ENTER as you are

editing your formula. (If you're using a Mac, hold down the Option and Command keys while pressing Return).

Remember that the Formula Bar doesn't automatically adjust it's height to display formulas on two or more lines. To view your formula you can resize the Formula Bar. Just position your mouse pointer over the bottom edge of the Formula Bar and drag it down to see all of your formula. You'll also need to drag it back when you are finished.

Not only does this make the process of creating multi-step formulas easier, but also when you or someone else are viewing the formulas later, this will make them much easier to read and edit.

Read More

About Lotus Temple / Bahai Temple New Delhi

Lotus Temple / Bahai Temple New Delhi (Must Visit / See places in Delhi, India)

In the attraction places of New Delhi India, Lotus temple is one them. Lotus temple has an awesome architecture and great historical importance. Everyone wants to know the history behind it. So, what is the historical importance of lotus temple and awesome architecture of it.

Lotus Temple Night View

BRIEF HISTORY OF LOTUS TEMPLE / ABOUT LOTUS TEMPLE NEW DELHI (INDIA):-

    The Bahai Temple also known as Lotus Temple for its distinct half-open lotus design which is situated in New Delhi, one of the most visited buildings in the world, attracting over 50 million people since it opened in 1986.

Why Bahai Temple is named Lotus Temple?

Many of people are saying that this temple looks like a lotus in shape and because of it is known as lotus temple. But this is not the complete truth. Lotus is a symbol of love and purity. It always gives the message of immortality. This is the main cause of this Bahai temple is designed like a lotus flower and it is known as Lotus Temple.

Lotus Temple Front View

         Lotus Temple is famous in world for its architecture. Persian architect Fariborz Sahba built this beautiful awesome architecture who came from Canada. So this is the brief history of Lotus Temple / Bahai Temple.

ARCHITECTURE OF LOTUS TEMPLE:-

           To construction the lotus temple Marble, cement, dolomite, and sand were used in. If a person look this temple from the top side view it looks like half opened Lotus Flower. Construction of this architecture takes 10 years to complete. There were 800 peoples who have worked to construction Lotus Temple. In which engineers, technicians, and workers are included. Around the blooming petals there are nine pools of water, which light up, in natural light. It looks spectacular at dusk when it is flood lit.. White marble is used in the construction of Bahai temple and by which the beauty of Lotus temple is increased. Lotus Temple is 40 meters in Height.

Lotus Temple View From Top

Important Details about place, Opening Timing (Hours), Opening Days:-

Lotus Temple Location: Near Kalkaji Temple, East of Nehru Place New Delhi

Nearest Metro Station: Kalkaji Mandir Metro Station

Open: Tue-Sun; Mondays closed

Timings: 9am to 5:30pm

Entry: Free

Photography: Permission required

How to Reach Lotus Temple New Delhi, India:-

To Know the directions to reach to the Lotus Temple Click Here.

Direction to Reach Lotus Temple

Read More

Show or Display Dashes instead of Zeros in MS Excel Spreadsheet.

Display Dashes (-) Instead Of Zeros (0) in MS Excel Worksheet with Example.


Sometimes we may want our report to display dashes instead of zeros, especially those Excel spreadsheets that contain a lot of zeros.

Display zeros as dashes in Excel 2007

We can do this with a simple change to our current number format.

To do this simple change follow the given below steps:-

1) Select the cells where We want to apply the format;

2) On the Home tab in the Number group, click the dropdown and select More Number Formats... This will display the Format Cells dialog;

3) On the Number tab select Custom in the Category list. If all of the cells We have selected have the same number format, that format will be displayed in the Type field (e.g. #,##0;-#,##0)

Excel number formats can contain up to 4 sections of code separated by semicolons. The first section applies to positive numbers, the second to negative numbers, the third to zeros, and the fourth to text. So to display dashes instead of zeros, we have to edit the third section (zeros).

By default, most number formats consist of only two parts: a format code for positive numbers and a format code for negative numbers. When there is no code defined for zeros, the positive number format is applied for zero value cells.

4) To specify a format for zeros other than the default format, we must add (or change) the third section of the number format code. If there is no format for zeros we need to add a semi-colon for the third section and then type a dash. This tells Excel to display a dash in any cell with a value of zero. If We leave the third section (i.e. to the right of the 2nd semi-colon),  instead of displaying zeros, the zero-value cells will be blank.

Display zeros as dashes in Microsoft Excel 2007, 2010, 2013

Optionally, We can type one or more blank spaces following the dash to force Excel to offset the dash from the right edge of the cell by the width of the space(s);

Microsoft Excel 2007, 2010, 2013 Add space to right of dash

Read More