Gavin has attended:
Excel Introduction course
Excel Intermediate course
Address Field
Ive recently moved to Mac so am unsure of all the same functionality with Excel 2011.
I'm creating a spreadsheet with customer information which includes their full address which I later will need to use for printing.
Should I be setting the address field up in particular way so that it will print correctly in time?
RE: Address Field
Hello Gavin,
Hope you enjoyed your Microsoft Excel course with BEST Training.
Thank you for your question regarding setting up address fields.
Its always a good idea to separate the various components of the address, so that if you ever have to merge the information into labels, you can choose which fields to use.
So for example, you could have the following column names:
BUILDING
STREET
TOWN/CITY
POSTCODE
I hope this resolves your question. If it has, please mark this question as resolved.
If you require further assistance, please reply to this post. Or perhaps you have another Microsoft Office question?
Kind regards,
Richard
Microsoft Office Trainer
