Forum home » Delegate support and help forum » Microsoft Excel Training and help » training in excel - Excel exported data
|
|
|
The UK's most regular Training information: See also: |
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
training in excel - Excel exported data
Resolved · Low Priority · Version Standard
Reply Tue 24 Jul 2007, 16:13Delegate Lisa said...
Lisa has attended:
Powerpoint Introduction course
Powerpoint Intermediate Advanced course
Excel exported data
Hi,
Another question please.
When we have exported data and there are pages and pages of data as we have to export from our backoffice say back to 2004.
We have alot of data and we cannot export at present from our back office specific dates so there are pages and pages.
We only require for example 2007 although we have back from 2004.
If we sort etc and ascend so that 2007 is at the top of the spread sheet - how can delete all the other info without having to hightlight pages and pages down there are alot and then pressing delete which takes ages.
Please?
Kind regards
Lisa
For upcoming training course dates see: Pricing & availability
RE: Excel exported data
Hi Lisa, Thanks for the post, if we take your last paragraph, where it is I assume you need the help, from the start of the first row that you wish to delete, press CTRL + SHIFT + END, this will highlight everything from that point onwards, then press Delete which will delete all the data you do not require.
|