Excel

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

Resolved · Low Priority · Version Standard

Excel

Aneta has attended:
Excel Intermediate course
Excel Advanced course

by - delegate Aneta [1 post] (2008 Feb 22 Fri, 16:40) Reply

When you hide some columns on the worksheet and then copy the remaining data you see to another workseet, hidden colums turn up as well! How to copy the data without the hidden colums?

Version	Date	Location	Places available	Book	Next place rate:
Excel Advanced 1 day course
Version	Date	Location	Places available	Book	Card	Invoice
2003/XP	2008 Aug 22 Fri	Bloomsbury	1	book now	£235	£240
2003/XP	2008 Aug 22 Fri	Bayswater	2	book now	£195	£205
2003/XP	2008 Aug 29 Fri	Southwark	3	book now	£224	£235
2003/XP	2008 Sep 3 Wed	Bloomsbury	5	book now	£219	£235
2003/XP	2008 Sep 5 Fri	Bayswater	4	book now	£195	£205
2003/XP	2008 Sep 10 Wed	Tooting	0	FULL
Full Schedule: See all 129 Excel Advanced course dates. Bookings currently available until 24th November 2009.

RE: excel

by - trainer Rich platinum contributer [704 posts] (2008 Feb 23 Sat, 21:49) Reply

Copy everything and go to paste and paste special. Select column widths first. No data will appear, but the column widths will all be the same. Paste again and this time the data will show. All data will still be there, but it will still be hidden. No way round this, if you dont want all the collumns then use the Ctrl key - hold it down when you are copying the columns to select only the required columns

· Microsoft Excel Training Course
· Compare Different MS Excel Training Methods
· How to Create Better Excel Spreadsheets: Part One
· Microsoft Excel Training: Not Just for Newbies Anymore
· 3 Ways that MS Excel Courses Can Drastically Improve Productivity for Teachers

Please browse our web site to find out more about
excel computer course london and other Microsoft training courses.

Excel tip:

Random Numbers

Type =RAND()*200 to generate a number between 1 and 200.
Use the fill handle to drag down and populate as many cells as you'd like with random numbers.

View all Excel hints and tips