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

tables

ResolvedVersion 2003

Naomi has attended:
Excel Advanced course

Tables

where do i go to make complex table structures? and is it possible to import tables from microsfoft to excel and vice versa?

RE: Tables

Hi Naomi,

Thank you for the question and welcome to the forum.

You can create your spreadsheet and make it as complex as you like by entering the data and formulas. Always ensure your headings are in row 1.

If you want to import or export data you could use copy and paste special.

I hope this answers your question.

Regards

Simon

Fri 7 Aug 2009: Automatically marked as resolved.

Excel tip:

Quick Absolute Cell References

When entering cell references in a formula you probably click the cell, or you may type in the cell reference. If you require any of the 4 variations, press the F4 key now before you press Enter to toggle around the relative and absolute entries ($signs).

Note that the F4 key outside of editing a formula is the Repeat key to repeat a previous action.

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.1 secs.