Microsoft Excel is one of the most popular used spreadsheets applications designed for complex data processing, accounting, and analytics. Properly done formatting improves the beauty of an Excel sheet, along with making more organized and comprehensible. It also supports data classification, sectioning, and error minimization.

This guide will instruct you on simple means of formatting your Excel worksheet.

1. Changing Colors of Tabs of an Excel Sheet

Changing sheet tab colors allows you to distinguish between each sheet more accurately.

Steps on changing tab colors

1. Right click on the tab (example: Sheet1)
2. Click on “Tab Color” option from the dropdown
3. Select appropriate color.

By using colors on coded tabs, users can switch between different sheets within the same workbook easily.

2. How to Hide, Delete, or Insert Columns in an Excel Sheet

Column management in excel is a critical part of data structuring.

Steps to insert a column

1. Right click on the desired column header (A, B, C, etc.)
2. Click on “Insert” to shift the column to the left.

Steps to remove a column

1. Right click on the required column header.
2. Click on “Delete” to delete the column.

Steps to Exclude a Column

1. Go to the header of the column and right-click.
2. Select “Hide” in order to remove the column from view.

To reveal a hidden column, right-click on a specific adjacent column and click on “Unhide.”

3. How to Change Row Height and Column Width

Changing column width and row height help in ensuring maximum readability.

Steps to Change the Width of the Column

1. Select the column header (A, B, C….).
2. Stretch the borderline to the right for optimum width.

Steps to Adjust Your Row Height

1. Select the row number (1, 2, 3, 4…).
2. Stretch the border line (borderline) down to ideal height.

This tool works to modify the visibility of the data while preventing text from overlapping.

4. In Excel, How to Append Header And Footer

A header element shows up on the top and a footer on the bottom of every page.

Steps Involved in Adding a Header and Footer

1. Click on “Insert” button.
2. Choose “Header & Footer” in the Text group.
3. Click on Add Header. button located in the upper part of the spreadsheet.
4. You can select page number, date, or even write down custom text.

The user can make any header and footer customizable in order to appear on every page.

5. How to Insert a Watermark in Excel

Adding a logo or background image helps to personalize and brand your Excel Workbook which in turn makes an effective watermark.

Steps to insert a watermark:

1. Navigate to the Page Layout tab.
2. Click on Background.
3. Choose From a file in the Insert Pictures section.
4. Use an image, for example company logo, as a watermark.

A watermark helps to illustrate more professional reports and business templates.

Master these formatting techniques to increase how you use Excel and the way in which your data is presented.

Categories: Learning Excel