Quick Links ▼

Bookmark page

Printable version

Customer: Sign in
Delegate: Sign in
Trainer: Log in

Forum home » Delegate support and help forum » Microsoft Excel Training and help » excel+courses - Excel

	98.1 % recommend us
	More live stats...

The UK's most regular
instructor-led training courses.

Training information:

excel+courses - Excel

Resolved · Low Priority · Version Standard

Reply Mon 28 Jan 2008, 14:04Delegate Rhianwen said...

Rhianwen has attended:
Excel Introduction course

Excel

How do I print with a grid showing? i.e with lines.

For upcoming training course dates see: Pricing & availability

Reply Mon 28 Jan 2008, 14:32Trainer David said...

RE: excel

Rhianwen,

To print the grid lines, I would just use the border tool to place a thin border arround all of the cells. When you print you will find that the border is printed as well.

Hope this helps
David

Reply Mon 28 Jan 2008, 15:22Delegate Paul said...

RE: excel

Surely she could just go

File > Page setup > the sheet tab and check the 'gridlines' check box?

Reply Tue 29 Jan 2008, 10:33Trainer David said...

RE: excel

Yes, that is also a perfectly good method to use.

David

Excel articles

· Crazy Things People Have Done With Excel
· Conditional Formatting: A Useful Feature Of Excel
· How to Create Better Excel Spreadsheets: Part Three
· Interesting Things About Charts In Excel 2003
· Plug Into The Big Grid

Excel tip:

LARGE and SMALL functions and their uses

Two of Excel's most common functions are the MAX and MIN functions which will display the largest (MAX) or smallest (MIN) value in a series. What if you need the 2nd or 3rd largest or smallest values instead of the largest or smallest?

The =LARGE(array,n) returns the nth largest value of a series.

The =SMALL(array,n) function returns the nth smallest value of a series.

In both functions, 'n' represents the order of the number you want to display. For example, putting in 2 as n will give you the second highest number; putting in 3 as n will give you the third highest number.

View all Excel hints and tips