Bookmark page
Printable version
Course updatesForum home » Delegate support and help forum » Microsoft Excel Training and help » Cut out spaces in a list
|
|
|
Bookmark this page|
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. |
Cut out spaces in a list
Resolved · Medium Priority · Version 2003
Reply
Cut out spaces in a list
How do I select a list that has spaces in it and chop out all the spaces by moving the cells that have data up to the top to form a consolidated list, with spaces below?For upcoming training course dates see: Pricing & availability
RE: Cut out spaces in a list
Hello AmyThank you for your question.
If the cells with the spaces (blank cells, I assume), are in one of the columns in your list, then if you sort by that column in ascending order, the rows containing blank cells will move to the bottom of the list.
Does this help?
Kind regards
Amanda
RE: Cut out spaces in a list
Hi Amanda, thanks for your response.That does work, yes, but what if I wanted to keep the list in the same order as previous, except for the blank cells. I know that there is a way to do this as our excel tutor showed us how. I think it is something to do with selecting and formatting?
RE: Cut out spaces in a list
Hi AmyI see Stephen was your trainer - I've checked with him to find out about what he showed you, and he tells me you do the following:
1. Select the whole list first.
2. Go to Edit - Go To (or use F5).
3. Click Special...
4. Select Blanks.
5. Click OK.
6. Right-click on top of some of the selected cell.
7. Select Delete from the shortcut menu.
8. Select the appropriate Delete option; click OK.
I hope this was what you were after.
Kind regards
Amanda
RE: Cut out spaces in a list
AmandaThat is exactly what I wanted.
Many thanks to you and Stephen.
Kind regards
Amy
|
 |
IT Training Programs: How To Choose The Best Ones For You Look online and you will find training provider after training provider waiting to serve your needs especially within the world of IT. In fact, these days finding a training provider is as easy as finding a bag of sugar in the local supermarket. But how do we find the time to sift through every training company in a bid to find the one which most suits our needs, time and money? » Article: Training company uk |
» Forum post: Macros |
» Tip: Change Constant Value |
What is a macro? What are they best used for?
When using a named constant in a worksheet, you may wish to change the value of that constant.
