98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View Reviews
Forum home » Delegate support and help forum » Microsoft Excel Training and help » training in excel - Excel exported data
training in excel - Excel exported data
Resolved · Low Priority · Version Standard
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
Thu 26 Jul 2007, 12:59Trainer Pete said...
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.
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. |
Excel tip:Make a quick copy of a worksheetHold down the Ctrl key, then click and drag on a sheet tab to make a copy of that sheet. Though this process usefully copies the formats of the original sheet, note that any Range Names you have on the original sheet will be duplicated too. |
