Free Excel 2010 Tips

Excel 2010 Tutorial

We know that Excel 2010 is a spreadsheet software in the new Microsoft 2010 Office Suite. Excel allows us to store, manipulate and analyze data in organized workbooks for home and business tasks. New innovations in Excel 2010 include the enhanced data viewing features of Sparklines and Slicers. 

Modifying Columns

When we open a new, blank workbook, the cells are set to a default size.You do have the ability to modify cells, and to insert and delete columns, rows, and cells, as needed. In this lesson, you will learn how to change row height and column width; insert and delete rows and columns; wrap text in a cell; and merge cells.

Modify Column Width

  1. Position your mouse over the column line in the column heading so that the white crossCursor becomes a double arrowDouble-arrow.
    Positioning mouse over the column line  
    Positioning mouse over the column line
  2. Click and drag the column to the right to increase the column width or to the left to decrease the column width.
    Increasing the column width  
    Increasing the column width
  3. Release the mouse. The column width will be changed in your spreadsheet.
    Increasing the column width  
    Increased column width

To Set Column Width with a Specific Measurement:

  1. Select the columns you want to modify.
  2. Click the Format command on the Home tab. The format drop-down menu appears.
  3. Select Column Width.
    Increasing the column width 
     Increasing the column width
  4. The Column Width dialog box appears. Enter a specific measurement.
    Increasing column width to 258 pixels  
    Increasing column width to 258 pixels
  5. Click OK. The width of each selected column will be changed in your worksheet.
Tips: Select AutoFit Column Width from the format drop-down menu and Excel will automatically adjust each selected column so that all the text will fit.

Visit this page for For modifying Excel 2010 Row .
Share this article :
Support : Website Designed | LMSO Group | Organized By
Copyright © 2013. Learning MS Office - All Rights Reserved
Tutorials Developed by LMSO Experts Published by LMSO Group
Proudly powered by LMSO Group