ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Dividing a cell (https://www.excelbanter.com/excel-discussion-misc-queries/15435-dividing-cell.html)

salim

Dividing a cell
 
Is it possible to divide a cell so it will have two parts.
This is required to label heading one part for horizantal
heading and other part for the vertical headings. if it is
not possible is there is a workaround.
excel2003



-----Original Message-----
Is it possible to divide a cell so it will have two

parts.
This is required to label heading one part for horizantal
heading and other part for the vertical headings. if it

is
not possible is there is a workaround.
excel2003
.
you could draw a diagonal line from top left to bottom

right corner of cell, then put your 2 headers in. Most
people would understand. If you need to use each of the
headers to generate further headers, eg 1 might be a
date, you could use appropriate text formulas, such as
left, mid, right to extract the "variable".


All times are GMT +1. The time now is 10:11 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com