alignment

I am having troubles formatting columns in a chart to match a specific font, colour, alignment etc. This code, while focused on column A:A, it applies to every single cell in the worksheet. I only want it to affect Column A: <code style="margin: 0px; padding: 0px; border: 0px; font-family...

I am trying to align multiple jobs to a Master List. For example: Master List Job 1 Value Job 2 Value Job 3 Value 1 1 A 2 2 B 1...

Hi - I'm trying to get text from a datasource into a specific format on another Sheet. I've created a new table style and that works fine. However, whenever new rows are added, it will not align the text automatically, and has to be done manually after the event. The datasource is an excel dump...

Can anyone help please. I have a large amount of data in excel 2013 and needs to be imported into another application, I am wanting the format to be set so that the information is displayed in a set format. e.g. MOTOR AGE 125 1500rmp 4Kw In the text above the first word 'MOTOR' is 5 characters...

I have fought with this for an hour or two and would greatly appreciate any help. I have a document that I need the periods to be aligned, the need to be in percent format with two decimal places. Some of the numbers have negatives and others have not. All help I've found doesn't keep the...

Hello, I have a spreadsheet that is center aligned, however, every time I scroll over the cells it changes them to be right aligned. It does this for every other line so in other words it only changes every other row into the right alignment. [/IMG]

Hello all, I am using Excel 2013. I have multiple columns w/ addresses (only the numbers, not the streets). I would like for odd ending numbers to be left-aligned and even ending numbers right-aligned. Is there a formula or macro (if any) that I can utilize to select all the cells within a...

Hi, I have this function which is used when generating a word document from my excel data. The problem is that in the worrd document, if there is a value, the alignment is right (which is what i want). But if there is no value, the alignment becomes left. How do I change it to right? Thank you...

Hi, I have a worksheet that allows users to select various data for clients. The columns are set up as follows: Client Property1 Property2 Property3 etc. At the top of each property column is a drop-down allowing users to select the various data elements available - balance, address, tenure...

Hello Board, Hopefully this is something simple. Once I apply any "Conditional Formatting" to an area of cells, I loose the alignment for the (text, number, date, etc..) I had selected for that area. I can't seem to find where (or what method is available) that will allow me to reset the...

I have 30-day data running from (eg) 16/04/2013 to 15/05/2013 to display on a graph. Since having intervals of 1 day on the x-axis overcrowds the labels I want intervals between them. However, I want the latest date (15/05/2013) to display on the right and the intervals to work backwards to the...

I'm designing a worksheet by adding some textboxes, labels, symbols. Looks good on the screen. But when I want to look at it using Print Preview, my worksheet seems out of alignment. That is, the textboxes don't line up with the textbox beneath it. It does on the screen but not in Print...

Hello, I am dealing with texts, not numbers. Column A has a text in English, and column B a text in Portuguese. I need to find pairs of cells A1-B1 or A1234-B1234 whose number of words have a difference of 9 words minimum. For that I have this formula which I wrote on column C, to identify such...

Hey, Apologies if this is not the correct place for this question, as it may have more to do with Outlook than Excel. The issue that I am having is when pasting Autofitted columns from Excel into an Outlook email. In Excel, the table is formatted correctly, and none of the cells contain...

Hello, I am trying to align a column of data with a neighboring column so that the data is in one continuous row. For instance, this is how the data looks now: Bill (e.g. A2 5 (neighboring column, one space down. e.g. B3) Chrissy 8 (neighboring column, one space...

I am using an IF formula to return a text string if conditions are satisfied and return a blank cell "" if conditions are not satisfied. My problem is that the when the text is returned from the formula, half of it is cut off by the adjacent cell because excel does not recognise "" as an empty...

Hi, I am new to the forum and also not very savvy with Excel. This may be an easy question but I just don't know how to solve it. Any help is appreciated! I use Excel 2008 on mac. 1. I am using accounting format for the price column of my spreadsheet. I like how the figure is indented away...

I am using excel 2000. How do I Change the format of a fields to Bold and Alignment Horizontal to Left indent and the Indent to the value of a field? This needs to happen for a range of rows. The range can be variable depending on how much data is in the spreadsheet. So if Field b2=2 I want to...

Greetings to all. We have a application in excel 2003 with lots of VBA controls in it. Now we have upgraded the Excel to 2007. when we open the application in Excel 2007 some of the controls sizes are inconsistent. Could you please any one know that what will will be the problem. Thanks in...