Home |
Search |
Today's Posts |
#1
|
|||
|
|||
How do I align cells in Excel onto one line?
Hi
I want to align cells in Excel onto one line. Example data: Column1 Column2 Column3 Column4 Row1 ABC Row2 DEF Row3 GHI Row4 JKL Should be Column1 Column2 Column3 Column4 Row1 ABC DEF GHI JKL Thanks a mil |
#2
|
|||
|
|||
Hi
Into B1 enter the formula =(OFFSET(B1,COLUMN()-1,) Copy the formula in B1 to right for as much columns as you have them in table Select all cells with formulas in row1, copy them, and replace with values (PasteSpecial.Values) Select the range from B2 to lower right corner of table, and clear all entries (when you have in some cells formulas or values which must remain, then probably you have to clear diagonal cellwise instead). -- When sending mail, use address arvil<attarkon.ee Arvi Laanemets "Mario" wrote in message ... Hi I want to align cells in Excel onto one line. Example data: Column1 Column2 Column3 Column4 Row1 ABC Row2 DEF Row3 GHI Row4 JKL Should be Column1 Column2 Column3 Column4 Row1 ABC DEF GHI JKL Thanks a mil |
#3
|
|||
|
|||
Select all the cells
Choose EditGo to, and click the Special button Select Blanks, click OK Choose EditDelete Select 'Shift Cells up', click OK Mario wrote: Hi I want to align cells in Excel onto one line. Example data: Column1 Column2 Column3 Column4 Row1 ABC Row2 DEF Row3 GHI Row4 JKL Should be Column1 Column2 Column3 Column4 Row1 ABC DEF GHI JKL Thanks a mil -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to align check boxes on an Excel sheet? | Excel Worksheet Functions | |||
How do I merge cells in Excel, like just 2 cells to make one big . | Excel Discussion (Misc queries) | |||
Convert data of cells to any type: Number, Date&Time, Text | Excel Discussion (Misc queries) | |||
linking cells in Excel 2003. How to not truncate to 255 characters. | Excel Discussion (Misc queries) | |||
Excel Charts and cells | Charts and Charting in Excel |