vba-excel-training - ms excel
The UK's Number 1 for Microsoft Office Training Add this page to your favourites/bookmarksBookmark page
 
View printable version of pagePrintable version
Plus One Google
Customer: Sign in
Delegate: Sign in
Trainer: Log in

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

vba-excel-training - MS Excel 2007

resolvedResolved · Low Priority · Version Standard

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

Stewart has attended:
Excel Intermediate course

MS Excel 2007

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

For upcoming training course dates see: Pricing & availability

replyReply Thu 29 Nov 2007, 13:17Trainer 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

 

Excel tip:

Some examples of CTRL key shortcuts in Excel 2010

Did you know that the old CTRL key shortcuts haven't changed from previous versions of Excel to the 2010 version?

They remain exactly the same:

Ctrl+B for bold
Ctrl+I for italics
Ctrl+P to Print
Ctrl+S to Save

View all Excel hints and tips


Microsoft Certified Partner Accredited Training Provider: Institute of IT Training Institute of Leadership and Management - Certified Courses Security Seal verified by visa, mastercard securecard