Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

weird in-cell tab effect spreading across cells

Posted on 2014-02-15
3
Medium Priority
?
257 Views
Last Modified: 2014-02-15
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
0
Comment
Question by:developingprogrammer
3 Comments
 
LVL 16

Accepted Solution

by:
Sheils earned 1000 total points
ID: 39862198
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
 
LVL 120

Assisted Solution

by:Rey Obrero (Capricorn1)
Rey Obrero (Capricorn1) earned 1000 total points
ID: 39862203
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
 

Author Comment

by:developingprogrammer
ID: 39862213
whao i learnt something new today! thanks guys!! = ))
0

Featured Post

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Instead of error trapping or hard-coding for non-updateable fields when using QODBC, let VBA automatically disable them when forms open. This way, users can view but not change the data. Part 1 explained how to use schema tables to do this. Part 2 h…
If you’re using QODBC to update QuickBooks data from Microsoft® Access but Access is not showing the updated data, you could have set up QODBC incorrectly.
In Microsoft Access, learn the trick to repeating sub-report headings at the top of each page. The problem with sub-reports and headings: Add a dummy group to the sub report using the expression =1: Set the “Repeat Section” property of the dummy…
Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…
Suggested Courses

782 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question