Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do i split my column excluding the header into three sections
i have created a spreadsheet but now realise i need 3 boxes for each month
and my original only has 1 how do i split the column without creating a new one? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do i split my column excluding the header into three sections
Hi Linzi,
It seems by 3 boxes you mean 3 cells and if you need some calculations in each cell you have to insert new 2 columns for each month and make the header Center Across Selection. No other way. If you dont need any calculations you can split the column by drawing lines from drawing tool bar. Regards, Jaleel "Linzi" wrote: i have created a spreadsheet but now realise i need 3 boxes for each month and my original only has 1 how do i split the column without creating a new one? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do i split my column excluding the header into three sections
Copy and paste a sample of your data as it is now and show us how you want it to
look. Gord Dibben MS Excel MVP On Wed, 30 Aug 2006 05:33:01 -0700, Linzi wrote: i have created a spreadsheet but now realise i need 3 boxes for each month and my original only has 1 how do i split the column without creating a new one? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Column picked randomly with probability relative to number of entr | Excel Worksheet Functions | |||
Replace all non blanks in a column with column header | Excel Discussion (Misc queries) | |||
Conditional Format as a MACRO | Excel Worksheet Functions | |||
creating a bar graph | Excel Discussion (Misc queries) | |||
Lookup Table Dilemma | Excel Worksheet Functions |