Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How can you paste a spreadsheet from Excel without gridlines?
Hi guys,
I need to copy/paste some tables from Excel to my presentation in MS Word. The gridlines disappear when I turned them off in the TOOLS/OPTIONS/VIEW section, but they reappear when you paste them into MS Word What's the secret? PhillyRon |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
How can you paste a spreadsheet from Excel without gridlines?
If you paste special as unformatted text then that's what you will get, you
can also paste using ctrl + v, select the table, do tableconvert and select convert table to text and select your delimiter -- Regards, Peo Sjoblom "PhillyRon" wrote in message ... Hi guys, I need to copy/paste some tables from Excel to my presentation in MS Word. The gridlines disappear when I turned them off in the TOOLS/OPTIONS/VIEW section, but they reappear when you paste them into MS Word What's the secret? PhillyRon |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
How can you paste a spreadsheet from Excel without gridlines?
Peo,
The point is to preserve the table formatting that I worked hard to produce in Excel, so converting everythng to text would defeat the purpose. Sorry. Any other solutions out there? PhillyRon "Peo Sjoblom" wrote: If you paste special as unformatted text then that's what you will get, you can also paste using ctrl + v, select the table, do tableconvert and select convert table to text and select your delimiter -- Regards, Peo Sjoblom "PhillyRon" wrote in message ... Hi guys, I need to copy/paste some tables from Excel to my presentation in MS Word. The gridlines disappear when I turned them off in the TOOLS/OPTIONS/VIEW section, but they reappear when you paste them into MS Word What's the secret? PhillyRon |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
How can you paste a spreadsheet from Excel without gridlines?
In Word (it is actually more of a Word than Excel question) select the table
(click the little square top left), do tabletable properties, click borders and shading, then click the none icon However having said that, normally when you paste using ctrl + v you won't get gridlines, just formatting and borders if they exist in the source data. Also you can turn on and off gridlines from tablehide gridlines in Word -- Regards, Peo Sjoblom "PhillyRon" wrote in message ... Peo, The point is to preserve the table formatting that I worked hard to produce in Excel, so converting everythng to text would defeat the purpose. Sorry. Any other solutions out there? PhillyRon "Peo Sjoblom" wrote: If you paste special as unformatted text then that's what you will get, you can also paste using ctrl + v, select the table, do tableconvert and select convert table to text and select your delimiter -- Regards, Peo Sjoblom "PhillyRon" wrote in message ... Hi guys, I need to copy/paste some tables from Excel to my presentation in MS Word. The gridlines disappear when I turned them off in the TOOLS/OPTIONS/VIEW section, but they reappear when you paste them into MS Word What's the secret? PhillyRon |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
How can you paste a spreadsheet from Excel without gridlines?
Peo,
Oddly, initially using ctrl +v pasting doesn't remove the gridlines, but your two suggestions to eliminate them within WORD work perfectly (after which ctrl+v does work for the rest of the pasting). Thanks for ending my frustration! PhillyRon "Peo Sjoblom" wrote: In Word (it is actually more of a Word than Excel question) select the table (click the little square top left), do tabletable properties, click borders and shading, then click the none icon However having said that, normally when you paste using ctrl + v you won't get gridlines, just formatting and borders if they exist in the source data. Also you can turn on and off gridlines from tablehide gridlines in Word -- Regards, Peo Sjoblom "PhillyRon" wrote in message ... Peo, The point is to preserve the table formatting that I worked hard to produce in Excel, so converting everythng to text would defeat the purpose. Sorry. Any other solutions out there? PhillyRon "Peo Sjoblom" wrote: If you paste special as unformatted text then that's what you will get, you can also paste using ctrl + v, select the table, do tableconvert and select convert table to text and select your delimiter -- Regards, Peo Sjoblom "PhillyRon" wrote in message ... Hi guys, I need to copy/paste some tables from Excel to my presentation in MS Word. The gridlines disappear when I turned them off in the TOOLS/OPTIONS/VIEW section, but they reappear when you paste them into MS Word What's the secret? PhillyRon |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
How can you paste a spreadsheet from Excel without gridlines?
I have a similar question in Excel 2007/PowerPoint 2007.
I'm copying a mixed sheet (chart with separate numeric tables). I want to copy the sheet in Excel exactly as laid out into Power Point, just not the gridlines. I used to be able to do this in prior versions. I copy, then Edit|Paste Special. I need to be able to resize in PowerPoint too. Thanks, Bob Pomeroy p.s. NOT a fan of the new Ribbon in 2007. "PhillyRon" wrote: Hi guys, I need to copy/paste some tables from Excel to my presentation in MS Word. The gridlines disappear when I turned them off in the TOOLS/OPTIONS/VIEW section, but they reappear when you paste them into MS Word What's the secret? PhillyRon |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
How can you paste a spreadsheet from Excel without gridlines?
Odd, that doesn't happen here. Got all your updates installed, SP2 etc.?
bobpom1 wrote: I have a similar question in Excel 2007/PowerPoint 2007. I'm copying a mixed sheet (chart with separate numeric tables). I want to copy the sheet in Excel exactly as laid out into Power Point, just not the gridlines. I used to be able to do this in prior versions. I copy, then Edit|Paste Special. I need to be able to resize in PowerPoint too. Thanks, Bob Pomeroy p.s. NOT a fan of the new Ribbon in 2007. "PhillyRon" wrote: Hi guys, I need to copy/paste some tables from Excel to my presentation in MS Word. The gridlines disappear when I turned them off in the TOOLS/OPTIONS/VIEW section, but they reappear when you paste them into MS Word What's the secret? PhillyRon |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Gridlines on Excel Spreadsheet | Excel Discussion (Misc queries) | |||
How can I lock the gridlines in an excel spreadsheet? | Excel Discussion (Misc queries) | |||
how to copy and paste with the gridlines using excel | New Users to Excel | |||
how do I copy and paste and have my gridlines show using excel? | New Users to Excel | |||
removing gridlines in Excel spreadsheet | New Users to Excel |