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 » Cut out spaces in a list
Cut out spaces in a list
Resolved · Medium Priority · Version 2003
Thu 14 May 2009, 11:14Delegate Amy said...
Amy has attended:
Excel Advanced course
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?
Thu 14 May 2009, 11:45Trainer Amanda said...
RE: Cut out spaces in a list
Hello Amy
Thank 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
Thu 14 May 2009, 11:50Delegate Amy said...
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?
Thu 14 May 2009, 12:10Trainer Amanda said...
RE: Cut out spaces in a list
Hi Amy
I 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
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:Jumping Across the Excel ScreenPgDn and PgUp keys scrolls up and down a screen page in most applications. |
