align

Hi, I am running a macro to create some charts, my orange line is on the primary axis with the blue and purple are on the secondary. I need the secondary zero point to start at the same as the primary, is there a change to my VBA code that would do this?? Also... how do i change the colour of...

Dear all, I am currently sitting with a rather large sheet of data. I have made a smaller, and more simple data sheet for simplicity's sake. Currently I have the following information: As you can see, the data for 2016 has already been filled out (through an old and more manual method)...

Hi all, I have a macro that fills a textbox with a picture from a URL and aligns the textbox to a cell. Sub FillPic() Dim i As Long, URL As String Dim oTextBox As TextBox For Each oTextBox In ActiveSheet.TextBoxes oTextBox.Delete Next oTextBox i = 2 Do While...

Hi Guys, Please help me how to align data in different columns. Please see below raw data given. C-1 C-2 C-3 A 1 B JOHN C CRUZ -Given the sample above. Can you please help me what would be the formula on this? Because, i'm having...

I have had some brilliant help in this forum with this code. What I would like to try and add when creating the new Column A is to ensure any new text is set to "Top Align" and Create an "All Borders" around the New Cells in Column A Sub EnterTeamName() Dim ws As Worksheet For Each ws...

Hi, I have a table in Power Query that mostly contains numeric data. Therefore, I want to align the column headers to the right so they are right-aligned with the numbers. This way, when I refresh the query, and Excel populates the table on the worksheet, the column headers will align with...

Hi everyone, I've been trying the whole day but can't figure it out. I need to align words in two rows. (It's used in an automatic header.) What I've stumbled upon was that adding spaces doesn't automaticly mean words align perfectly. What is want to accomplish is something like this. <tbody>...

Hello, I need someone to help me to find the best and fastest way to align data in Excel Sheet. 1) I have the names in column A fixed and always in the same order. 2) I have the same names in column C but their order changes all the time. 3) I have budgets in column D that each number is...

Good evening, A worksheet I am working on ( only 100+ rows ATM but will grow to 8000!) Range is a1:k8000, can someone sort some VB so when 'data' is in entered into any cell within the range it will grid the complete range & when the data is removed, grid reforms accordingly, fomat:- font...

Hi. I want to align the text in a column so that a specific character (±) is in the centre. The number of characters either side will vary depending on the value, # decimal places etc, but the one constant will be the ± character. This is an example of some data: <colgroup><col...

Hello, i'm trying to align grid lines of 3 separate Excel charts as seen on image (i'm new to charts), representing Actual sale by products and % variance to Plan/Prior Year. Manually i cannot align them to the exact alignment (check the mismatch on last grid lines below): Is it possible to...

Hi there, I have this number format - _-* £#,##0_-;[Red]* £(#,##0)_-;_-* "-"??_-;_-@_- however I cant align left, centre or align right from the buttons on the ribbon. Is there a way that the above format could be altered to allow me to use the alignment buttons Also is there a way...

Is there any way to align Center Header in Excel? I know there is no any built in solution but is there any VBA code that would work. I have been trying copying cells to header, setting center header with VBA but my Center Header is "Align Center" all the time. I have even found very complex...

Hello Everyone would like to know how to align common field in excel file which are in different columns as have merge various excel file hence it have appeared in different columns. Kindly check the screenshot for the same to understand the query. https://ibb.co/nnGMqT

Hi, I have a list of data in sheet1. Column A contains cells which all contain text. They are capital letters apart from the right hand value which is lower case letter ("a", "b", "c", "d" or "e") e.g "TELEVISION.a", "TELEVISION.b" and so on until "TELEVISION.e". The item varies and the length...

I want to align an active x button to the top right corner of cell A1 but not getting it I can align it to the top let corner with the code below Is this possible? Thanks Sub btnReposition() Dim ws As Worksheet Dim Rng As Range Set ws = ThisWorkbook.Sheets("Original_<wbr>Data")...

Is there a way to automatically align left and align top cells when merging cells? Its annoying when it defaults to center and bottom.

Hi everyone, I am having trouble aligning multiple columns. For instance, I have this: <tbody> 12 15 a 15 17 b 17 10 c 16 12 d 10 16 e </tbody> And I need to keep the values in the second and third columns together but align the duplicates in columns 1 and 2 like this: <tbody> 12...

Excel 2013/2016ABC1accountDebitCredit2Cash253sales1004Sheet1 in this table i want to align column A to right if column C is greater than zero, thanks :)

Hi guys, I wanted to create a similar graph to the following: https://i.gyazo.com/155179a79801ecb4e72b180403eb776c.png but with the following data: https://i.gyazo.com/99fe1a1dbf95277cf9209bd82b5e90d2.png I tried doing it in excel but I cannot find a way to align the CAGR's column to the...