border

  1. M

    Blue border appearing around everything I select

    Earlier today a blue border began appearing around everything I select, to include tables, cells and even individual characters within a cell. I am using "Normal" view and am at a loss as to how to turn this off. I do not have a print area set. I'm using Excel 2013 on Parallels 9 on my MacBook...
  2. J

    VBA code to create a border around used cells in a worksheet

    Hi excel gurus, I'm writing/recording a macro and would like some VBA code. I'm trying to make a border around all used cells in my sheet. When I use the macro there will be a variable number of used cells. I'd like code that says: If cell A2 has text then format cells A2:CL2 with an outline...
  3. D

    Macro for diagonal border based on the input of a cell?

    Hello, I am fairly new to writing macros for excel. I have played around with programming in C but that is it. I am wanting to make a macro that reads the value in a cell (C4) and if that value >= 3 then a certain cell lets say (i31) has a diagonal up border. Else nothing. This is the basic...
  4. S

    Print - Rows repeat at top - Border on repeated row does not repeat?

    Hi I have a basic layout question about excel that I just cant figure out. I have a sheet where I have set the 3 top rows to repeat when printing. Row 3 has a "full border" at the bottom of cells... Rest of sheet has "dotted border" in top and bottom of cells Now when I print only the first...
  5. R

    VBA Help Requested - Bottom border across a table row to indicate a "threshold"

    Hi, I'm new to VBA and could really use some help with a table formatting issue. I've created a macro that creates a table from raw data and sorts it (high-to-low) by a column noting probability of success. Is there code that can be added to place a bottom border across the last row of data...
  6. C

    Macro To Add Border If Font Is Bold

    Hi All, I was wondering if anyone knew of a way to write a macro that would add a top border to some cells in a selected range. All of my number data is columns I:O with subtotals every so often (example of columns F:O below): <TABLE style="WIDTH: 451pt; BORDER-COLLAPSE: collapse" border=0...
  7. Big Bruiser

    Help! Border color in table will not change

    I am using a table and the top border refuses to change color. It is stuck on blue. Has this happened to anyone and do you know how to change it (I want it to be black). <TABLE style="WIDTH: 940pt; BORDER-COLLAPSE: collapse" cellSpacing=0 cellPadding=0 width=1252 border=0><COLGROUP><COL...
  8. K

    Perform Macro Based on Border Color

    Hi all, I'm looking to create a Macro that searches the defined ranges (Range1 to 75) in a sheet called "Layout" and if it has a red border then I want it to perform a Macro after users double click on the Range. The Macro will be to unhide rows on a second sheet called "Reports". I have a...
  9. J

    Make it 'Pop!', How to?

    Hi all! I am currently working on an Excel file that could be considered a work of art. I am sure we have all found ourselves in a position where you look at your work and say, "Hey!, who said these spreadsheets can't be fashionable!?" Having said that, I would like to create a visual effect...
  10. K

    Section breaks and formatting

    I am creating a report that has several "ID's" that have various information for each one. Is there a way that I can group together these ID's so when I print it out it will have the following format? ID 1 other info and columns 1 other info and columns 1 other info and columns 1...
  11. F

    Conditional formatting broken xl 2007->2010

    I've been happily using the much improved conditional formatting that arrived with Excel 2007, but having just upgraded to 2010 it seems to have been broken again. I have conditional formats that remove the borders (defined using a cell style) from a small number of cells within a large column...
  12. Big Bruiser

    Format graphs across workbook

    I have a workbook with several tabs and graphs on most tabs. The graphs contain titles and borders for presenation within Excel. However, when I copy and paste the graphs into PowerPoint, I prefer the graphs to not have a title and no borders. I would like to save myself the time of making this...
  13. R

    Macro to Border and Select Print Area for Queried Data

    I have a workbook that queries a SQL database and returns a different number of records each time. The query populates data from columns A thorugh J, however I'd also like to have an additional blank column print as well. My challenge is that I want to include this additional column, in this...
  14. S

    Paste Special - Borders, Gridlines, Comments using Enhanced Metafiles

    In Excel 2007, when I select a range of cells (typically outlined by the print range, in print view mode) and paste into Word as an enhanced metafile, the picture is bordered in blue (from the print range). How do i keep the blue border from appearing? Additionally, when pasting as enhanced...
  15. M

    line or border inside a cell?

    I have a unique cell, lets say A1="A" and i want to draw a line or place a border horinzontal or vertical inside the cell, so that the letter "A" looks like it was crossed.
  16. J

    XL07: Copy subset or named range into new range based on column values

    Hello, I have a spreadsheet that tracks stocks I'm interested in. The first 3 columns are (the rest of the columns being data such as P/E, Yield, etc.) # Ticker Name 1 BAC Bank of America 1 WFC Wells Fargo 2 IBM IBM 2 ORCL Oracle 2 CSCO Cisco The '#' is an arbitray...
  17. N

    How to apply border to a new row created by VBA in a table/list in excel?

    How to apply border to a new row created by VBA in a table/list in excel?:warning: I have created a button which adds new rows to the table which is bordered and the background of whole sheet is white.Now when the new row is added the new row does not have any border.I want that the new row...

Some videos you may like

This Week's Hot Topics

  • populate from drop list with multiple tables
    Hi All, i have a drop list that displays data, what i want is when i select one of those from the list to populate text from different tables on...
  • Find list of words from sheet2 in sheet1 before a comma and extract text vba
    Hi Friends, Trying to find the solution on my task. But did not find suitable one to the need. Here is my query and sample file with details...
  • Dynamic Formula entry - VBA code sought
    Hello, really hope one of you experts can help with this - i've spent hours on this and getting no-where. .I have a set of data (more rows than...
  • Listbox Header
    Have a named range called "AccidentsHeader" Within my code I have: [CODE]Private Sub CommandButton1_Click() ListBox1.RowSource =...
  • Complex Heat Map using conditional formatting
    Good day excel world. I have a concern. Below link have a list of countries that carries each country unique data. [URL...
  • Conditional formatting
    Hi good morning, hope you can help me please, I have cells P4:P54 and if this cell is equal to 1 then i want row O to say "Fully Utilised" and to...
Top