Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Newspaper Columns
Is it possible in Excel 2002 or 2003 to create newspaper columns, that will
snake properly when an item is added and can be sorted if necessary? -- Regards Michael Koerner |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Newspaper Columns
Michael,
You can do it using formulas to create your columns, referencing a table of values where your text is entered. The formula in the first column could be as simple as =A1 and at the top of the second column =A21 When both are copied down 20 rows, you would get two columns of 20 items that snakes properly, and will reflect any sorting applied to the source table. HTH, Bernie MS Excel MVP "Michael Koerner" wrote in message ... Is it possible in Excel 2002 or 2003 to create newspaper columns, that will snake properly when an item is added and can be sorted if necessary? -- Regards Michael Koerner |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Newspaper Columns
That seemed to work well <g Thanks very much.
Next question When the list does not fill the page, Excel puts "0" in the blank cell, even if the cell is formatted as text. I would like it to be blank. Is there something I need to add to the formula. -- Regards Michael Koerner "Bernie Deitrick" <deitbe @ consumer dot org wrote in message ... Michael, You can do it using formulas to create your columns, referencing a table of values where your text is entered. The formula in the first column could be as simple as =A1 and at the top of the second column =A21 When both are copied down 20 rows, you would get two columns of 20 items that snakes properly, and will reflect any sorting applied to the source table. HTH, Bernie MS Excel MVP "Michael Koerner" wrote in message ... Is it possible in Excel 2002 or 2003 to create newspaper columns, that will snake properly when an item is added and can be sorted if necessary? -- Regards Michael Koerner |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Newspaper Columns
Michael,
Change your formulas to =IF(A1="","",A1) =IF(A21="","",A21) HTH, Bernie MS Excel MVP "Michael Koerner" wrote in message ... That seemed to work well <g Thanks very much. Next question When the list does not fill the page, Excel puts "0" in the blank cell, even if the cell is formatted as text. I would like it to be blank. Is there something I need to add to the formula. -- Regards Michael Koerner "Bernie Deitrick" <deitbe @ consumer dot org wrote in message ... Michael, You can do it using formulas to create your columns, referencing a table of values where your text is entered. The formula in the first column could be as simple as =A1 and at the top of the second column =A21 When both are copied down 20 rows, you would get two columns of 20 items that snakes properly, and will reflect any sorting applied to the source table. HTH, Bernie MS Excel MVP "Michael Koerner" wrote in message ... Is it possible in Excel 2002 or 2003 to create newspaper columns, that will snake properly when an item is added and can be sorted if necessary? -- Regards Michael Koerner |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Newspaper Columns
Worked like a charm,thank you very much
-- Regards Michael Koerner "Bernie Deitrick" <deitbe @ consumer dot org wrote in message ... Michael, Change your formulas to =IF(A1="","",A1) =IF(A21="","",A21) HTH, Bernie MS Excel MVP "Michael Koerner" wrote in message ... That seemed to work well <g Thanks very much. Next question When the list does not fill the page, Excel puts "0" in the blank cell, even if the cell is formatted as text. I would like it to be blank. Is there something I need to add to the formula. -- Regards Michael Koerner "Bernie Deitrick" <deitbe @ consumer dot org wrote in message ... Michael, You can do it using formulas to create your columns, referencing a table of values where your text is entered. The formula in the first column could be as simple as =A1 and at the top of the second column =A21 When both are copied down 20 rows, you would get two columns of 20 items that snakes properly, and will reflect any sorting applied to the source table. HTH, Bernie MS Excel MVP "Michael Koerner" wrote in message ... Is it possible in Excel 2002 or 2003 to create newspaper columns, that will snake properly when an item is added and can be sorted if necessary? -- Regards Michael Koerner |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel to Word for Newspaper | Excel Discussion (Misc queries) | |||
printing worksheet in newspaper columns | Excel Worksheet Functions | |||
Can you print xcel in "newspaper colmn" fashion? | Setting up and Configuration of Excel | |||
Combine multiple columns into two long columns, Repeating rows in first column | Excel Discussion (Misc queries) | |||
Newspaper layout using Excel? | Excel Discussion (Misc queries) |