excel consultancy - Griflines

Resolved · Low Priority · Version Standard

Griflines

Nada has attended:
Excel Introduction course

by - delegate Nada [1 post] (2007 Dec 19 Wed, 16:20) Reply

how do i delete griflines from a chart if i don't want it to appear in the page?

Version	Date	Location	Places available	Book	Next place rate:
Excel VBA 2 day course
Version	Date	Location	Places available	Book	Card	Invoice
2007	2008 Dec 11 Thu + 12 Fri	Bayswater	3	book now	£525	£545
2007	2009 Jan 8 Thu + 9 Fri	Bloomsbury	7	book now	£450	£475
2003	2009 Jan 22 Thu + 23 Fri	Southwark	4	book now	£475	£485
2003	2009 Jan 29 Thu + 30 Fri	Bayswater	6	book now	£450	£485
2007	2009 Feb 5 Thu + 6 Fri	Bloomsbury	7	book now	£450	£475
2003	2009 Feb 19 Thu + 20 Fri	Southwark	8	book now	£275	£399
Full Schedule: See all 33 Excel VBA course dates. Bookings currently available until 26th November 2009.

RE: griflines

by - trainer Amanda diamond contributer [1243 posts] (2007 Dec 20 Thu, 10:42) Reply

Hi Nada

Thank you for your question.

You can remove the gridlines from a chart by double-clicking on one of the gridlines and changing the gridline colour on the Patterns tab so that the colour of the gridlines matches the colour behind the gridlines. Then click OK.

Happy Christmas and best wishes for your study next year.
Amanda

· Database Tips from an Excel Training Course
· Identifying Suitable Candidates For VBA For Excel Training
· Do You Really Need Excel VBA Training?
· How to Create Better Excel Spreadsheets: Part Three
· Microsoft Excel Features and Functions for Accountants

Excel tip:

Quickly create a list of numbers

The fill handle in Excel has many uses. If a number is typed into a cell and then the fill handle is used, the number will be copied from one cell to the next.

If you wish to create a list of numbers that increment by one at a time, hold down Ctrl in conjunction with using the fill handle - this should give you a series of numbers (e.g. 1, 2, 3 etc) rather than copying a single number.

View all Excel hints and tips

Rate this page: