"Formats the Excel Table As You Wish - The Step-by-step Guide!"

How you also can formats the excel table easily?

This tutorial shows you how to adjust various aspects of the table's appearance to suit your needs. These including changing the columns width, row height, add rows and columns, etc.

To add a new column to the end of a table, just active a cell in the column to the right of the table and start entering the data. Excel automatically extends the table horizontally.

Similarly, if you enter data in the row below a table, Excel extends the table vertically to include the new row.


To change columns width and row height

  • Position the mouse pointer on the border below the row or to the right of the column that you want to resize. The mouse pointer turns into a line with arrows on each side of it.
  • Hold down the mouse button as you drag the row or column to a new height or width. A dotted line appears showing where it will go.
  • Release the mouse button.
  • You can have a column automatically resize to fit the contents of column by double-clicking on the column edge.


To add rows or columns

  • Click within the row where you want to insert a new row or column.
  • Right-click and point to Insert from the shortcut menu and choose one of the options.
  • insert row or column in Excel 2007

  • To delete a row, click within the row you want to delete.
  • From the Table Tools Layout tab, in the Rows & Columns group, click the Delete icon and from the menu select Delete Rows.


To delete column or row

  • Click within the column or row where you want to delete.
  • Right-click and point to Delete from the shortcut menu and choose one of the options.
  • delete row or column in Excel 2007


To move a table within the worksheet

  • Move the mouse pointer to any of the table borders.
  • When the mouse pointer turns into a cross with four arrows, click and drag the table to its new location.


To move a table to a different worksheet

  • Press Alt + A twice to select the entire table.
  • Press Ctrl + X to cut the selected cells.
  • Activate the new worksheet and select the upper-left cell for the table.
  • Press Ctrl + V to paste the table.



Can't find what you're looking for? Try Google Search!

Custom Search


Back to Top

You're viewing the formats the Excel table info page, click here to go back to the Home Page

Add To Your Social Bookmarks: add to BlinkBlink add to Del.icio.usDel.icio.us add to DiggDigg
add to FurlFurl add to GoogleGoogle add to SimpySimpy add to SpurlSpurl Bookmark at TechnoratiTechnorati add to YahooY! MyWeb


Google Search:

Custom Search

Recommended Books:

Click on the image to view the details of the book.
Excel 2007 ebook
The Ultimate Guide to
Excel 2007!


PowerPoint 2007 ebook
The Ultimate Guide to
PowerPoint 2007





XML RSS
What is this?
Add to My Yahoo!
Add to My MSN
Add to Google


Enjoy This Site?
Then why not use the button below, to add us to your favorite bookmarking service?

Copyright © www.msoffice-tutorial-training.com. All Rights Reserved.