align

I have to combine several worksheets originally based on standard columns into a single worksheet, but users have randomly included extra columns. So for example if the original headers were: |Date|Forename|Surname|Address1|Address2|Town|Car user| Some now have additional columns inserted...

I am frequent user of the keyboard commands in Excel 2016 such as Alt,H,AC = Align Center or Alt,H,AR = Align Right. There are hundreds of these keyboards that are usually pretty easy to remember. HOWEVER, when you go to Data, From Table or Alt,A,PT,Enter you enter a whole world of...

Hi, I have an issue whereby i have 5 different sheets of information Each sheet signifies a different category. Each sheet contains two columns. One with a code and the other with the value of that code in that particular category. Example; Sheet 1: <tbody> Open 71224 $20.00 71848...

Dear all, Fairly new to excel, and have been trying for several days to solve this one with no success. I have a scenario where i have several different columns (which are in reality account strings) and i am required to match them across each row. My issue is that not all rows will have...

Hi good people!, I have googled and found some codes, but they do not work. Why off course, I cannot know. I am looking for vba code which will align 4 graphs, next to each other, horizontally. The first graph must be used as "anchor"..so the remaining 3 graphs must just shift to the left or...

I am trying to align shapes to a specific range such as range(B2:Z2), currently the shapes align to where ever the command button is placed. I don't want the command button to be treated as a shape. In addition I want to have a set of rectangle shapes and a rounded rectangle shapes. I need the...

PP_Slide.Shapes.Placeholders(1).TextFrame.TextRange.Text = "slide title" PP_Slide.Shapes.Placeholders(1).TextFrame.TextRange.VerticalAlignment = xlTop i just want to align the text (slide title) on top, but it gives me error "object or method no supported" :( note: i'm running this vba in an...

Hi everyone From part of an Excel VBA codebase, I'm failing to automate alignment of just one shape in a PPT presentation. This seems to be because Align is for ShapeRange rather than for Shape. In code below, VBA identifies vPic as the active shape ; that's why the SendToBack command works...

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've been going through fora, but haven't found a satisfactory answer. I have multiple column pairs (>80) of date/time-value data. Unfortunately the first date/time values are all of different beginnings. So one starts at noon, the other next pair starts at 12:05 etc. All have the...

I'm trying to help organize a colleagues data in Excel 2010 on Windows 7 and have encountered 3 issues that could be very time-consuming to resolve manually. The data is from a multi-year study, only a few samples and months are shown. The main issue: Sort & match in Excel, data from tables...

So I have a dilemma and I have made it work before but for some reason I can't remember how I did it or where I saved the file that i did it in before. I would like to align two columns of data side by side. one column has less rows than the other so I need a macro that will move the one...

Hey everyone! Brand new member here! I am running Excel for Mac OS X 2011 on Mac OS 10.8. I'm working on a science experiment involving a lot of data with multiple trials. Here is a sample of raw values: <tbody> x1 y1 x2 y2 x3 y3 51.4 2000.3334 50.7 2000.3334 51.1 2000.3334 52.7...

i have a chart with data for each week. i then added the legend below to correspond with the data for each week. i'm having problems aligning the dates on the chart to the dates on the legend. when that happens, one of the dates goes away and it all ties together. i cant figure out how to do...

I have two columns: <TBODY> red</SPAN> red</SPAN> yellow</SPAN> blue</SPAN> teal</SPAN> yellow</SPAN> black </SPAN> black </SPAN> green</SPAN> green</SPAN> pink</SPAN> pink</SPAN> orange</SPAN> grey </SPAN> grey </SPAN> white</SPAN> brown</SPAN> brown</SPAN>...

I'm trying to dynamic align column B to column A, but by matching a substring, and not by matching the whole content of the cell. I have two column, with filenames in each (all with the same format, basically: Show.name.SxxExx.optional.title.source.codec-group.extention), but they might be a...

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...

Hi all, I've found this forum after hours of google searching/researching. I've seen some fantastic examples that I've tried to amend to work for my situation, but am failing miserably. Here's my issue: Sheet 1: "monthly insurance invoice", column a- names (last first) & column b- premium...

Hi, I'm wondering if anybody can assist me in solving this. I have 2 columns of numbers. I want to match Col B to Col A and have the matching entries aligned next to one another. ColA is the "Mater List" and I want to arrange ColB so that ColB's entries align themselves next to ColA's matching...

Hi guys, I am generating several checkboxes onto a workbook I have via VBA, but the issue I'm having is that the checkboxes are not aligning to the centre of the cells. I was hoping someone could point me in the right direction with this. I have included a simple version of the code I am...