Forum home » Delegate support and help forum » Microsoft Excel Training and help » vba-excel-training - MS Excel 2007

vba-excel-training - MS Excel 2007

ResolvedVersion Standard

Tue 13 Nov 2007, 17:10 Delegate Stewart said...

Stewart has attended:
Excel Intermediate course

MS Excel 2007

How do you convert a special table to a normal table?

Thu 29 Nov 2007, 13:17 Trainer Amanda said...

RE: MS Excel 2007

Hi Stewart

Thanks for your question. Apologies for the delay in replying.

To convert a table into a normal range of cells in Excel 2007, you can right-click within the table area, and from the shortcut menu go to Table then select Convert Table to Range. Click OK when the message comes up asking you to confirm this action. Then the data will be converted to a 'normal' cell range.

Amanda

Training courses

98.7 % recommend us

More live stats...

Training information:

Excel tip:

Saving your Excel Spreadsheet as a CSV File

In situations where you need to save your Excel spreadsheet as a CSV file, follow these simple steps.

Click the File tab and click Save As.
Enter a name in the File name field.
Click the drop-down arrow next to the Save as type field to select the file type. Scroll down the list and select CSV (comma delimited) (*.CSV)
Click Save

The data will now be saved to a separate CSV file which can be used in different applications.

View all Excel hints and tips

vba-excel-training - MS Excel 2007

MS Excel 2007

RE: MS Excel 2007

Excel articles

Excel tip:

Saving your Excel Spreadsheet as a CSV File