Dividing a cell
Date: Tue, 1 Mar 2005 04:38:31 -0800
>-----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".
Relevant Pages
- Re: Cells that run on to another page
... > insertion point anywhere within a cell in that row, click Table, click ... To repeat table headers at the top of each page, ... Word automatically repeats table headers on new pages that result from ... >> and pasted a heading onto each page. ...
(microsoft.public.word.tables) - Re: External images
... <<What i was hoping was for the cell to wrap according to the image ... size...basically accomodate the image>> ... the cell location will vary bacause the amount of data that ... that you will have to select each heading cell and run it for each heading. ...
(microsoft.public.excel.programming) - Re: VBA Filter (with many variables) and copy result to new Worksheets
... Set up the criteria area with a blank heading cell, ... Assuming your first division is in cell C2, ... Under the first Emp# heading, ... To extract the results to a new sheet, start the Advanced filter from ...
(microsoft.public.excel.misc) - Re: Help with Advanced Filter Comparison Criteria
... Leave cell C1 blank -- when you use formulas in the criteria range, ... either leave the heading cell blank, or use a heading that is different ... When you run the Advanced Filter, select cells C1:C2 as the criteria range. ... > I have a spreadsheet that lists database records, ...
(microsoft.public.excel.worksheet.functions) - Re: code to match and sort
... ' assumes heading in row 1, ... clears column K and cell M1. ... If you have data in column E, you'll need to put the filtered Levels ...
(microsoft.public.excel.programming) |
|
