align

  1. 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...
  2. 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...
  3. 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...
  4. 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...
  5. 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>...
  6. 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...
  7. 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...
  8. 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...
  9. 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...
  10. 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...
  11. 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...
  12. 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. https://ibb.co/nnGMqT
  13. 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...
  14. 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")...
  15. 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.
  16. 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...
  17. M

    align right if cell is greater than zero

    <b>Excel 2013/2016</b><table cellpadding="2.5px" rules="all" style=";background-color: rgb(255,255,255);border: 1px solid;border-collapse: collapse; border-color: rgb(187,187,187)"><colgroup><col width="25px" style="background-color: rgb(218,231,245)" /><col /><col /><col /></colgroup><thead><tr...
  18. N

    Aligned CAGR graph

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

    Aligning randomised worksheet columns

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

    Really Dislike the Keyboard Commands in Excel 2016 Query Editor

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

Watch MrExcel Video

This Week's Hot Topics

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 MrExcel.com.
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 "mrexcel.com".
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
Top