microsoft-excel-courses - Showing text

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

Resolved · Low Priority · Version Standard

Showing text

James has attended:
Excel Intermediate course

by - delegate James [1 post] (2007 Aug 9 Thu, 16:30) Reply

Please could you tell me how to make sure that ALL text in cell shows once you've copied data?

Thanks

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	4	book now	£207	£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: Showing text

by - trainer Amanda diamond contributer [1199 posts] (2007 Aug 10 Fri, 12:30) Reply

Hi James

Thanks for your question.

When you copy and paste data, the columns you paste into will not automatically adjust their width so you only see some of the data unless you then adjust the widths of the columns.

I hope this helps.
Amanda

· Reporting and Analysis with Excel
· How to Create Better Excel Spreadsheets: Part Two
· Microsoft Excel Features and Functions for Accountants
· Microsoft Excel Training: Essential for Today's Employees
· Microsoft Excel Training Advanced Courses - Making Data Validation Work For You

Excel tip:

Colouring cells containing formulas

Cells in a worksheet can contain values or they can contain formulas. You may wish to identify all the cells in your worksheet that contain formulas by colouring those cells.

Follow these steps:
1. Choose Edit > Go To menu, or press either F5 or Ctrl+G. Excel displays the Go To dialog box.
2. Click Special. Excel displays the Go To Special dialog box.
3. Select the Formulas radio button option.
4. Select OK.

At this point, every formula cell in the worksheet is selected, and those cells can be coloured formatted as desired.

View all Excel hints and tips