Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Deleting this white line?
I am working on a report that has been made by other people in my department.
On almost every sheet I see white lines which I can't seem to delete. The only way I know is to delete the entire rows. No one knows how those lines are made. I put an example of the line in a file at http://www.tazlure.nl/whiteline.xls Can anyone tell me how this line can be deleted? Thanks. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Deleting this white line?
Seems to be a object Try Options view Hide Objects -- VBA Noob ------------------------------------------------------------------------ VBA Noob's Profile: http://www.excelforum.com/member.php...o&userid=33833 View this thread: http://www.excelforum.com/showthread...hreadid=561943 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Deleting this white line?
But then I hide it. I won't see it, but it will still be there.
I want it gone :) "VBA Noob" wrote: Seems to be a object Try Options view Hide Objects -- VBA Noob ------------------------------------------------------------------------ VBA Noob's Profile: http://www.excelforum.com/member.php...o&userid=33833 View this thread: http://www.excelforum.com/showthread...hreadid=561943 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Deleting this white line?
The example white line is in fact a collapsed embedded chart. Perhaps the
columns containing the charts in your workbook were deleted and the charts shrunk to zero width. To delete them, I suggest placing the Select Multiple Objects icon on the Worksheet Menu Bar (main tool bar): 1. Select ToolsCustomize from the Worksheet Menu Bar 2. Select the Command tab from the dialog that appears 3. Select Drawing from the Categories window 4. In the Commands window, left click the Select Multiple Objects icon (typically 3rd from the top) and drag the icon onto the Worksheet Menu Bar 5. Close the Cusomize dialog 6. Now click the Select Multiple Objects icon. If I am correct, you will see a chart or charts listed in the dialog that pops up 7. Click the chart(s) you want to delete (checkmarks will appear) 8. Click the OK button to close the dialog (this will select the charts) 9. Now click the Delete key Note that you can instead drag to the right the sizing handle of one of the selected charts to resize it so that it can be seen. FYI, the chart in your example has a Y-axis title "Avg Repair Cost" and a legend with series names "Labor", "Parts", "Handling", etc. Regards, Greg "Ozz" wrote: I am working on a report that has been made by other people in my department. On almost every sheet I see white lines which I can't seem to delete. The only way I know is to delete the entire rows. No one knows how those lines are made. I put an example of the line in a file at http://www.tazlure.nl/whiteline.xls Can anyone tell me how this line can be deleted? Thanks. |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Deleting this white line?
"Ozz" wrote:
But then I hide it. I won't see it, but it will still be there. I want it gone :) Perhaps try press F5 Special Check "Objects" OK (selects all objects on the sheet at one go) Then press Delete .. (Tinker on a spare copy first) -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
Deleting this white line?
Hi Ozz,
I don't know what it is but you can get rid of it by selecting columns A,B + C and deleting the entire columns. If there is other data in these columns that you wish to keep you can insert 3 new columns to the right of the object copy and paste the other data to there and then delete the columns. You will need to copy and paste one column at a time otherwise the white line comes with it. HTH Martin |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
Deleting this white line?
The white line is the chart object. If u can select the object( y using the
select object tool in drawing tools) and expand the object , u can see the chart/Graph. "MartinW" wrote: Hi Ozz, I don't know what it is but you can get rid of it by selecting columns A,B + C and deleting the entire columns. If there is other data in these columns that you wish to keep you can insert 3 new columns to the right of the object copy and paste the other data to there and then delete the columns. You will need to copy and paste one column at a time otherwise the white line comes with it. HTH Martin |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Keep formual intact after deleting a line | Excel Worksheet Functions | |||
Line Chart | Charts and Charting in Excel | |||
10 000 Line, every 2 Lines need a border and a open line inbet. e. | Excel Discussion (Misc queries) | |||
A 2 line text showing up in the Cell in Excel prints in 1 line | Excel Discussion (Misc queries) | |||
pivot table multi line chart | Charts and Charting in Excel |