Cell formatting

[damionblaise]

I need to know how to select all of the cells in a workbook and get them to start at the top of the cell instead of having a space in between

 

[Scott Huish]

Not quite sure what you're asking, but this is my best guess.

CTRL-A to select all your cells (you might need to press this twice if you have gaps in your data)
CTRL-1
Select the Alignment tab
Under Vertical, select Top
Click OK

 

[damionblaise]

Not quite sure what you're asking, but this is my best guess.

CTRL-A to select all your cells (you might need to press this twice if you have gaps in your data)
CTRL-1
Select the Alignment tab
Under Vertical, select Top
Click OK

Sorry for the confusion. The data had an extra line with a space as follows:

blank space
data
blank space

I need to move the text to columns but the data is blank, I'm assuming because the first line is blank.

Thanks.

 

[damionblaise]

Sorry for the confusion. The data had an extra line with a space as follows:

blank space
data
blank space

I need to move the text to columns but the data is blank, I'm assuming because the first line is blank.

Thanks.

 

[MrExcel]

I am assuming that the data was created like this:
Alt+Enter,Data,Alt+Enter,Enter

That would cause the data to appear as if it was not at the top of the cell.

If that is the case, try these steps:
1. Select the cells that have this problem
2. Ctrl+H to display Find and Replace
3. In the Find What box, type Ctrl+J. Nothing will appear (except maybe a dot). This is the bizarre, unexplainable shortcut key for simulating an Alt+Enter in the Find and Replace box.
4. Leave the Replace With box blank
5. Choose Replace All

You might have to then use Align Top to move the one-line of data (which is not bottom-aligned) to the top of the cell.