the ens key takes

Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

Forum home » Delegate support and help forum » Microsoft Excel Training and help » The Ens key takes me way beyond the last row of the spreadsheet

The Ens key takes me way beyond the last row of the spreadsheet

resolvedResolved · Medium Priority · Version 2003

Sue has attended:
Excel Advanced course

The Ens key takes me way beyond the last row of the spreadsheet

How do you reset the end of a spreadsheet

RE: The Ens key takes me way beyond the last row of the spreadsh

Hi Sue

Hope you enjoyed yesterday

Here is a link to an article on Microsoft that shows you how to reset the last cell manually and by use of an Excel add-in

http://support.microsoft.com/default.aspx?scid=kb ;en-us;244435

The support article applies to all versions of Excel. Hope that helps any problems please do get in touch


 

Excel tip:

Create a unique items table from a duplicating table

1. Ensure that your list has column headings
2. Select the entire list
3. From the menu bar, select DATA, FILTER, ADVANCED FILTER
4. Select "Filter the list, in place", and tick the "Unique Records Only" box
5. Click OK, filtered list appears.

View all Excel hints and tips


Server loaded in 0.08 secs.