weird in-cell tab effect spreading across cells

hey guys,

i'm quite familiar with Excel but i'm not sure how this is done = (

check out this attached file. "MEPS" is in range A1 and it seems as though it's merged across A to D. however when you click on it, we'll realise the following:

- there is no cell merger
- there is no space formatting
- there is no indent
- there are no spaces before the word "MEPS"

how is this effect done? thanks! = )
EE.xls
developingprogrammerAsked:
Who is Participating?

[Webinar] Streamline your web hosting managementRegister Today

x
 
SheilsConnect With a Mentor Commented:
Use centre across selection.

Enter value in one cell. Select a number of cells in the row. Right click and select cell format. In alignment select centre across selection
0
 
Rey Obrero (Capricorn1)Connect With a Mentor Commented:
the value "MEPS" is in A1
select the cells A1 to D1, then select Format Cells

go to Alignment tab, in the Horizontal drop down, select Canter across selection.
0
 
developingprogrammerAuthor Commented:
whao i learnt something new today! thanks guys!! = ))
0
All Courses

From novice to tech pro — start learning today.