The title in the attached chart is a camera shot transferred from another excel 2007 worksheet in the same workbook.
I'd like to remove the border line, I've tried right clicking... then format picture ...no dialogue box comes up. I've scrolled through all the commands in the ribbon + non ribbon commands and can't find anything that seems appropriate that's not greyed out ....
border line.docx
I'm having this problem where I used the camera tool to take a shot of some range of cells. After taking here on the worksheet the image looks fine but when I print preview the same image seems to be bigger than the actual image.
View 4 Replies View RelatedI've got a formula that gives me an "#N/A" in a cell when certain conditions are met, otherwise it gives me the results of a calculation.
On the line graph that goes with uit, the "#N/A" is being treated as a zero.
(Excel 2003, using Format/Cells)
I have selected a range of multiple rows and columns. I can change the alignment, cell color, where border lines appear, and the color of border lines.
However, I can not change the border line style. No matter what style I select, when drawn on the sheet it apppear as a thin solid line. I've tried all the dashed/dotted line options, but they appear to have no effect.
Ultimately, I want to color alternating rows of cells, and (since coloring hides grid lines) I want to add border lines the same color and style as the hidden grid lines.
I merged about 15 adresslists from media contacts to one excel list. Each list had a name i.e. music, health, theater, etc. and the same logic in colums. I added a few columns and have 1 large list now.
As some journalists write about music & health & theater, architecture, etc. they are listed up to 10 times in the new list now. But the "genres" from the original list i.e. music, health, theater, etc. are in different columns. Some of the lines have empty fields (i.e. no address or mail)
All I want to do is have one line with all the information of all 10 lines in it, merged, dupes removed:
company - firstname - lastname - Adress - Mail, etc. : genre: music - health - theater:
example.xlsx
I atteched an example of the full list and the result i want
Can someone look at the sheet sample? I am trying to turn duplicates into a zero like Ive done in record 1 so that the same tax bill is not counted twice. The records are in rows and if I do a transpose and try to do it by hand it will take forever cause I have hundreds of records.
Excel 2007
BQBRBSBTBUBVBWBXBYBZCACBCCCDCE1txt_nme_taxpayertxt_nme_streetcity state txt_addr_1txt_parcel
Year 10Year 9Year 8Year 7Year 6Year 5Year 4Year 3Year 2Year 12QUINCY'S REALTY INC % RASH & A19900
HOLIDAY LNCHARLOTTE, NCPO BOX 16003192170500.55516.22712.71768.860000780.713FERGUSON, BENJAMIN10733
MONTECARLO DRCHARLOTTE, NC3508 SARGEANT DR151840720.4423.5180.381.988.2387.689.1789.1789.1789.174HARVEY,
[Code] ........
I've used Group Boxes to isolate some Option Buttons. I would like to remove the line border of the Group Box, but I don't see a way to format it.
View 2 Replies View RelatedI have recived a CSV file with dollar amounts that need to be formated with out a deciaml and with our rounding. Example I need 12558.64 to be changed to 1255864.
View 3 Replies View RelatedI'm working with a very large spreadsheet which has somehow divided itself into print areas. Each section has 'Page 1' or the equivalent as a background, behind the data itself. I thought it would be simple to remove this, but for the life of me I can't see how. I'm using Excel 2007.
View 6 Replies View RelatedI have several sheets with about 250,000 rows per sheet.
But, even I sort by Column A, there are STILL hundreds or rows that are total blank interspersed down the page . . . I can't autofilter for blanks because there is too much data . .
How can I get rid of them?
I've got a whole load of cells that have a pipe ( | ) on the end of the value which I'm trying to remove.
Easy enough thinks me, so;
Code:
=LEFT(AB188,LEN(AB188)-1)
And then Copy / Paste Values Still has a pipe on the end... I check the cell for trailing spaces, there are none...
I check the length of the cell (658) against the length of the result from the formula (657)...
So, my formula works, but when I copy and paste as values the pipe remains.
I'm using Excel 2007 and the cell contatins other pipe characters I'd like to keep in there so I can't find and replace or anything.
I am using Excel 2007 on Windows 7. I would like to remove duplicates as follows: If column A = column A, column B = column B, and the two rows are within one hour of each other, then remove all duplicates, leaving one instance of the row. As you can see, sometimes the duplicates are right next to each other, and sometimes have rows between them. (Rows 1 & 2, Rows 30 & 32). Even though this sample doesn't show it, sometimes there can be tens of duplicates within an hour, not just two.
Excel 2007
ABCD1EruptionI Can't Stand The Rain (78)3/7/20129:12:55
AM2EruptionI Can't Stand The Rain (78)3/7/20129:10:02
AM3ChicagoJust You 'N' Me (73)3/7/20129:05:59
[Code] .........
When I duplicated a worksheet in Excel 2007, I received a warning that "A formula or sheet you want to move or copy contains the name ___" (an existing Name) and was given options. The Name in question should not have been relevant because I never intentionally linked it to the worksheet that was being duplicated, but apparently something happened at some point to create such a link.
I opened Name Manager and deleted the Name in question, and this invoked a warning. "Privacy warning: This document contains macros, ActiveX controls, XML expansion pack information, or Web components. These may include personal information that cannot be removed by the Document Inspector." I had no macros. Each time I attempted to save the document, I got this error/warning, even after disabling Macro Security completely.
It was still saving, fortunately, so I closed Excel and relaunched, and the issue seemed to vanish.
Should I be worried about the integrity of my document? Everything seems fine now, but I'm a little concerned.
I am having trouble delete a drop down list inspite of selecting clear all from the data validation tab in excel 2007. When I hit Alt + Down Arrow, I still see picklist options. I didnt set up the spreadsheet, hence I am not sure how to begin troubleshooting.
View 1 Replies View RelatedI'm trying to use VBA to draw a border using the drawing toolbar and using the line. i need it to draw a border around a select area i hightlight.
i have attached a example below, but not sure if it will appear.
I have two line charts in Excel 2007.
One chart has the values going down from upper left to lower right
The other chart has the values going up from lower left to upper right
Is there anyway to merge these charts to see if they intersect at all?
Why is the VBA for putting a simple border around a cell so convoluted. For example cell A2:
Code:
Sub CellBorder()
Range("A2").Select
With Selection.Borders(xlEdgeLeft)
.LineStyle = xlContinuous
.Weight = xlThin
[Code] ........
So many lines to put a simple - single line border (square) around a cell.
I am trying to add several border lines to the bottom of a row from A to AI start from row 12.
There is probably a few things you need to know
1. Starting from row 11 each data section is two rows deep
2. The data section could be repeated and if this is the case do not insert border until it changes
3. The border line needs to be added underneath the second line i.e. to split the different types of data
I have a range of data (not a named range, just a selection) and I typically want:
- the top 2 rows to have a heavy border on the left, top and right sides with a light line on the bottom.
- On the bottom line, I need a heavy line on the left, bottom and right sides.
- The body in between needs to have heavy lines on the left and right sides with dots for all in between.
The top 2 lines show titles, the bottom line is for totals and the body in between shows the data.
I've made 3 separate macros that do each part but I'm hoping that they can be integrated into one.
I have a line charts with values above and below zero.
Im looking for a way to colour the steps below zero in one colour, and above zero in another colour - without doing it manually.
Using Excel 2007.
I have this simple code which sets the objects format as default.
Private Sub FormatTextBox()
ActiveSheet.Shapes("FormatBox").Select
Selection.ShapeRange.SetShapesDefaultProperties
End Sub
Is there a way to set an objects shape to the default format...not as default?
ie: if the default line color is blue. what code could i use to set an object with a black line color, to the default blue?
I am using the following macro to set print area which I found on the net. I am trying to modify it as I would also like to place a border line on the bottom row but cant find anything to assist me despite searching through several threads.
Dim myrange As String
With ActiveSheet.Range("A:A")
myrange = .Find(What:="*", After:=.Range("A1"), LookIn:=xlValues, LookAt:=xlPart, _
SearchOrder:=xlByRows, SearchDirection:=xlPrevious, MatchCase:=False).Address
End With
ActiveSheet.PageSetup.PrintArea = "$K$1:" & myrange
End Sub
In Excel 2010, I used the camera tool to take a snapshot of a selction of cells. How do I save the snapshot only as a JPG or GIF file?
I know that there are programs outside of Excel that can take snapshots or print screens, but I need to accomplish it using the camera tool so the snapshot is the exact selection everytime. Is the excel snapshot temporarily saved somewhere on my computer where I can access it?
I have place a camera-picture of a table on the right side of a chart. On the screen it looks great! (See below - with some redaction)
Problem Example.png
.... but when I print it the table expands off of the side of the chart. Scale is 100%, zoom is 100%, Excel 2010 (See below - with some redaction). Whether or not I have a print area does not seem to make a different in the problem. Also, it appears that this happens with any shape I put in that place, it's not specific to the camera tool.
Problem Example_Print Preview.png
Excel 2010 and the camera function.
I have been using it to take a picture of a graph, pasting to an alternative sheet within the same workbook, and renaming the picture by a defined name. S by selecting the names from a drop down list the picture will select various different sized graphs defined within my drop down.
What I am experiencing is when I initially do this the pic works great and resizes automatically with each selection, however the next day some of the pictures resize and some do not.
Is this a glitch within excel or am I missing a setting which will resolve this?
This seems so simple but i looked everywhere and i cannot find the vba script to add a 3 point solid black line border around the chart and plot area of my graphs. The record macro option does not record this.
View 3 Replies View RelatedI am trying to split cells that have addresses in them into separate cells via writing a formula but am having no joy, i wonder if anyone could help me please.
What i need is to split cell A1 which contains an address i.e
Red Roofs
12 Chiltern walk
Tunbridge Wells
Kent
TN1 1PL
England
I need to put a formula in cells B1,C1,D1,E1,F1 and G1 tha splits each line of the address and puts it in the separate cells so it would look like:
B1 Red Roofs
C1 12 Chiltern walk
D1 Tunbridge Wells
E1 Kent
F1 Tn1 1pl
G1 England
Creating border in different size at single attempt. Example as shown in the picture.
Excel Format.jpg
I have a spread sheet with product codes on and 5 different prices types but they have only pulled through 4 times so need to insert a 5th line for each product code
View 2 Replies View RelatedI am trying to assign a border and fill to cells, of identical colors, using VBA. Simple enough, yes? I am using the same RGB value for both the fill and the border, but in Excel 2003, they are assigned two different colors: the fill is the correct shade, but the border is not, which makes absolutely no sense to me. I could understand if both colors were slightly off from the shade I'm getting in 2007, but to have one be correct and the other not? I can manually assign the border to be the proper color, but this doesn't help.
The code is:
