ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   How do center headings across columns in excel (https://www.excelbanter.com/excel-worksheet-functions/52185-how-do-center-headings-across-columns-excel.html)

ASL

How do center headings across columns in excel
 
This newer version does not easily (for me) identify a button for this
function. The button that is similar is "merge and center", but it does not
do what I want to do.

RagDyer

How do center headings across columns in excel
 
I believe that went out with XL5.0.
The newer versions don't have such a button.

You'll have to select your range, then:

<Format <Cells <Alignment tab,
Expand the "Horizontal" window, and click on the last choice, "Center Across
Selection", then <OK.
--
HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================



"ASL" wrote in message
...
This newer version does not easily (for me) identify a button for this
function. The button that is similar is "merge and center", but it does

not
do what I want to do.




All times are GMT +1. The time now is 12:03 PM.

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