Start a New Line within the Same Cell

Do you get stuck when it comes to writing multiple lines of data in a single cell?

You can use Alt + Enter to start a fresh new line within the same cell.

Easily Excel at writing multiple lines in the same cell! 

Selecting and Formatting Blank Cells

How do you select all the blank cells in the selected range?

1) Select the range of cells and press F5.

2) Click on 'Special', click 'Blanks' and click OK.

This could be used to format all the blank cells in a particular theme.

Easily Excel by selecting all the blank cells in a few seconds and formatting them!

Another way to format the blank cells in the sheet is by using conditional formatting:

Use of Text Boxes

Download the Practice file here.

Excel is considered to be very rigid when it comes to formatting options. The gridlines restrict your formatting options as well as creativity.

At this moment, it makes sense to use a Text Box which floats on the sheet rather than being a part of it.

A Text Box is a rectangular object (you can create them in any shape that you want from Insert Menu -> Choose the ‘Shapes’ option from ‘Illustrations’ panel).

Following are the advantages of using a Text Box:

Quick Formatting and Beautification

Download the practice file here.

Delete the sheets which do not have any data in it. By default, Excel includes three sheets for each workbook. The remove the ones that do not have any data.

In the view menu, in the ‘Show’ panel, uncheck the option of gridlines. This makes the sheet look neater and adds elegance to the sheet.

Color the background of the cells across the sheet according to the theme that you are using (for your company or organisation). You can do this by selecting the cells that need to be colored and changing the color by going on the ‘Home’ menu and selecting the paint bucket in the ‘Font’panel.

Change the color of the text too in order to bring it in alignment with the theme. To do this, select the font color option on the ‘Font’ panel form the ‘Home’ menu.

Use the F4 key while formatting to repeat the last action. For example, if you colored a particular cell as orange and next you want to color another cell orange, you can select the next cell and hit F4. It can be used not only for formatting but for any action.

Learn how to use Text Boxes to make your Excel sheet look elegant and neat here

Please share your feedback here.