1. S

    Align zero on secondary axis with primary

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

    Please help me create an IndexMatch-like formula

    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)...
  3. V

    Bug? Aligning Shapes to Cell dimensions is now not and exact match?

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

    How to align data in different colums

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

    VBA Code Help with Text align and All Borders

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

    Can You Align Table Headers In Power Query Table?

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

    VBA Spacing between two words

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

    Align Data in Multiple Columns Without Formula

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

    grid a range

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

    Align Text on a Specific Character

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

    Excel charts / Align grid lines of 3 separate charts

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

    number format with the flexibility to align

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

    Excel VBA Center header/footer “Align Left”

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

    How to align common field in excel which are in different columns

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

    Line up strings of text

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

    Align button to Top Right corner of cell

    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")...
  17. bencar

    How Do I Align Top and Right When Merging Cells?

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

    Align duplicated values and string another column

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

    align right if cell is greater than zero

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

    Aligned CAGR graph

    Hi guys, I wanted to create a similar graph to the following: but with the following data: I tried doing it in excel but I cannot find a way to align the CAGR's column to the...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back