training in excel - Insert symbols

The UK's most regular instructor-led training courses.
Training information: training in excel · Excel-courses-london · Microsoft Excel Training London
See also · excel-courses-london · excel courses in london · excel microsoft training

Resolved · Low Priority · Version Standard

Insert symbols

Nick has attended:
Excel Introduction course
Word Introduction course
Word Introduction course

by - delegate Nick [5 posts] (2007 Feb 23 Fri, 10:33) Reply

Hi,
Was just wondering how I can insert symbols into an excel spreadsheet? I want to place ticks in a column on a spreadsheet to show whether a certain job has been done or not.

Many Thanks

Nick Adams

Version	Date	Location	Places available	Book	Next place rate:
Excel Intermediate 1 day course
Version	Date	Location	Places available	Book	Card	Invoice
2007	2008 Nov 25 Tue	Bloomsbury	0	FULL
2003	2008 Nov 27 Thu	Southwark	3	book now	£210	£215
2007	2008 Nov 28 Fri	Bloomsbury	0	FULL
2003	2008 Dec 2 Tue	Bloomsbury	3	book now	£210	£215
2003	2008 Dec 4 Thu	Bayswater	6	book now	£195	£205
2007	2008 Dec 8 Mon	Bayswater	5	book now	£212	£224
Full Schedule: See all 113 Excel Intermediate course dates. Bookings currently available until 25th November 2009.

RE: insert symbols

by - trainer Tracy platinum contributer [586 posts] (2007 Feb 23 Fri, 12:32) Reply

Once in excel if you go into Insert and down to symbol there is a dialog box which appears where you can choose a type of tick symbol. Once you have down that once you can copy and paste it to other cells.

Good luck

Tracy

· Why Excel Training (Sometimes) Doesn't Work and What You Can Do About It
· Do You Really Need Excel VBA Training?
· Creating Charts with Excel
· Customized Financial Excel Courses in London
· Take the Anxiety out of Domestic Finances with Microsoft Excel

Excel tip:

Do a fast scroll

In big Excel databases with many records, you can move down thousands of rows super-fast as follows: hold down Shift then click on the scrollbar somewhere below the scrollbar handle. This will move you way down the sheet without your having to use the scrollbar up/down arrows or drag on the scrollbar handle.

View all Excel hints and tips