Microsoft Excel Formatting Tips

If you have ever used Microsoft Excel then you will know how powerful it is for our business Excel Formattingas well as personal use. Sometimes you just need your spreadsheet to also look good and presentable. Whether you enter data yourself or are in a habit of importing it from another source, the information doesn’t always look good. Cells would not expand automatically to fit their contents, headings won’t appear bold and columns might need split or combined, the list just goes on. All of these are very easily rectified a bit of basic Excel wizardry. Read on to find about easy formatting tips.

For adjusting columns width and row height: Depending on the size of the text or the numbers you really enter into Excel, the cells do not automatically expand. The fastest way to get the column widths and height is to use the ‘double click’ method. You can either adjust all of the columns and rows or even just a few. In order to adjust all of your columns and rows, why not select all of your worksheet.

  • Hit CTRL+A twice in order to select all cells on your work book. (Hitting CTRL+A once will select any cells that contain data)
  • Hover your cursor on any of the columns line, or on any row then you can just double click.

If you are interesting in adjusting the row or column height of a particular cell, hover your cursor above the header border which is between the column you want to change and the neighbouring column to its right, and then double click.

To view your page breaks. Before you even attempt to print your worksheet, one really good time saving formatting trick to use is to view the page breaks. This option is actually the default setting in Excel 2007, but if you really need to display them for any reason:-

  • You have Office button
  • Excel Options
  • Advanced
  • And show Page Breaks

Not only will this save a few trees with less waste paper, but time as well by getting the printout correct in the very first time. If you have been using earlier version of Excel then hit

  • The Tools
  • The Options
  • The View
  • And then tick Page Breaks under Windows options

If you want to enhance your knowledge of advanced versions of Microsoft Excel, learn conditional formatting in Excel at AudioSolutionz

error: Content is protected !!