Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

vba-excel-training - ms excel

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

Stewart has attended:
Excel Intermediate course

MS Excel 2007

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

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

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

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.08 secs.