Excel Tip 1: How to format cells, columns and rows in 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 firstname.lastname@example.org
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,
Want to fix Excel problems in the shortest amount of time? Don't have time to devote to Excel? Click here
for the solution