ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Can I insert a row that has no column separators? (https://www.excelbanter.com/excel-discussion-misc-queries/66804-can-i-insert-row-has-no-column-separators.html)

ecodevah

Can I insert a row that has no column separators?
 
Is it possible to insert a row above my columns that does not separate into
columns? I'm looking for a header line that precedes several detail lines.

CLR

Can I insert a row that has no column separators?
 


This may give you what you're looking for.........

Try highlighting several cells across the row, the Right-click formatCells
AlignmentTab HorizontalBox CenterAcrossSelection


Vaya con Dios
Chuck, CABGx3



"ecodevah" wrote:

Is it possible to insert a row above my columns that does not separate into
columns? I'm looking for a header line that precedes several detail lines.


EdMac

Can I insert a row that has no column separators?
 

If you just want to combine the top of the columns to make a header box
that fits across them, hightlight the cells,
FORMATCellsAlignmentmerge cells.

You can then align the text as you want.

Ed


--
EdMac
------------------------------------------------------------------------
EdMac's Profile: http://www.excelforum.com/member.php...o&userid=30736
View this thread: http://www.excelforum.com/showthread...hreadid=504057



All times are GMT +1. The time now is 05:29 AM.

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