HomeHome SearchSearch MenuMenu Our productsOur products

Excel Tip 1: How to format cells, columns and rows in Excel

by , 10 January 2014
Every office relies on Excel for some business function. So we've decided to send you a series of Excel tips to help you streamline this. These range from easy tips that just make your life easier, to more advanced and complex tips.

Today's Excel tip forms part of the more basic Excel tips. But keep a look out for more advanced tips in the coming weeks.

Excel Tip 1: How to format cells, columns and rows in Excel

All Excel reports should be easy to read. So if you want to change the layout of the entire spreadsheet, you can use cell, row and column formatting options.

Cell formatting changes the appearance of characters within the cell (colour, font, size etc.), and the appearance of the cells (frame, colour etc).

Formatting rows and columns is when you choose the height and width, and what (and how) to insert and delete.

Example: Spreadsheet with partially visible content due to poor formatting.

But how do you view the text that isn't visible?
There are five ways. Keep reading to find out one of these five…

The Employment Tax Incentive Act is now in effect! Are you ready?

Get to grips with the Employment Tax Incentive Act workshop on 28 January in Johannesburg and FSP Business will help you get to grips with the new regulations and what they mean for your business!

For more information email natalie@fsp.co.za
One of five ways to view all the text

To get an automatic best fit simply double click the column break line between the two cells you want to format.
You can also do this for the entire row:
•    Double click on the line between the two columns at the top of the sheet.
•    If you click on the number 'A', you'll select the whole column. This will show as a highlighted column.
•    Then double-click on the line next the letter to autoformat the column width to the automatic best fit. This will match the printing properties you've selected.

For the other four methods to view all the text, turn to chapter E11 in the Practical Guide to Excel. Don't have your copy? Click here.
Until next time,

Philip Rosenberg

PS. Want to fix Excel problems in the shortest amount of time? Don't have time to devote to Excel? Click here for the solution

Vote article

Excel Tip 1: How to format cells, columns and rows in Excel
Note: 5 of 1 vote

Related articles

Related articles

Related Products