how do i centre headings accross the screen in excell?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

all i can manage to do is centre it in the cell. How do i put it accross the
whole screen without dragging column A acrross the screen and the centering
the text in it?
 
Select all the cells, Format>Cells>Alignment, and in the Horizontal
dropdown, select Center across selection.

--

HTH

RP
(remove nothere from the email address if mailing direct)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel 2002: Formating tab color 6
column 4
How to apply a formula accross all the rows when the total rows are too much in no. ? 6
column heading 1
Split report for email 5
How do I get "centre across selection" to centre properly? 5
How to display the cell it goes to at the centre of the monitor screen? 1
'Centre across selection' format to apply to vertical range 3

Back
Top