Maximum Number of rows..

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

Resolved · Low Priority · Version Standard

Stephen has attended:
Excel Introduction course

by - delegate Stephen [1 post] (2008 Feb 18 Mon, 16:51) Reply

What happens if i exceed the maximum number of rows provided?

Version	Date	Location	Places available	Book	Next place rate:
Excel VBA 2 day course
Version	Date	Location	Places available	Book	Card	Invoice
2003/XP	2008 Jul 30 Wed + 31 Thu	Bayswater	0	FULL
2003/XP	2008 Aug 7 Thu + 8 Fri	Bloomsbury	3	book now	£475	£495
2003/XP	2008 Aug 14 Thu + 15 Fri	Bloomsbury	5	book now	£450	£485
2003/XP	2008 Aug 26 Tue + 27 Wed	Bayswater	6	book now	£450	£485
2003/XP	2008 Sep 8 Mon + 9 Tue	Bayswater	7	book now	£345	£399
2003/XP	2008 Sep 18 Thu + 19 Fri	Bloomsbury	7	book now	£345	£399
Full Schedule: See all 47 Excel VBA course dates. Bookings currently available until 26th November 2009.

RE: Maximum Number of rows..

by - delegate Paul gold contributer [121 posts] (2008 Feb 18 Mon, 17:00) Reply

You can't

If you have data in the last row of the spreadsheet and then insert a row before that data, then Excel will warn you that you are about to lose some data...

· Tools From Advanced Excel Courses: Goal Seek and Solver
· 3 Reasons Why Excel Training Courses For Employees Can Improve Your Business
· Microsoft Excel Training Course
· Do You Really Need Excel VBA Training?
· Microsoft Excel Training: Not Just for Newbies Anymore

Please browse our web site to find out more about
microsoft-excel-courses and other Microsoft training courses.

Excel tip:

Quickly insert a function

In Excel 97 and 2000 it was known as the Paste Function dialog box, these days it's known as the Insert Function dialog box. Regardless, one has to choose Insert|Function. or the fx button to open it up. There is, however, a non-mousey way to get hold of the Insert Function dialog box: press Shift+F3 in a blank cell to open the Insert Function dialog.

Press Shift+F3 after a function name and open bracket to open the Function Arguments dialog. For example, type =VLOOKUP( into a cell and press Shift+F3 to obtain a detailed description of VLOOKUP's arguments.

View all Excel hints and tips