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

excel

ResolvedVersion 2007

Robert has attended:
Word Intermediate course
Excel Intermediate course

Excel

how do i create printable boxes / columns and rows around data on my screen

RE: excel

Hello Robert

Thank you for your question.

I'm guessing you are referring to applying borders to (i.e. putting lines around) your spreadsheet data?

To apply borders to your spreadsheet:
1. Select the cells you would like to put borders onto.
2. Go to the Home tab, and click the dropdown arrow next to the Borders button.
3. Select the type of border you would like to apply.

Kind regards
Amanda

Thu 16 Apr 2009: Automatically marked as resolved.

 

Training courses

Training information:

See also:

Welcome. Please choose your application (eg. Excel) and then post your question.

Our Microsoft Qualified trainers will then respond within 24 hours (working days).

Frequently Asked Questions
What does 'Resolved' mean?

Any suggestions, questions or comments? Please post in the Improve the forum thread.

Excel tip:

Create a unique items table from a duplicating table

1. Ensure that your list has column headings
2. Select the entire list
3. From the menu bar, select DATA, FILTER, ADVANCED FILTER
4. Select "Filter the list, in place", and tick the "Unique Records Only" box
5. Click OK, filtered list appears.

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