| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to create sheet without gridlines?
Many times, I see the excel sheets prepared by others which do not contain
Gridlines. In these sheets the Gridlines option in ToolsOptionsViewWindows Options is also enabled. Gridline colour is also Automatic. There is no sheet background as well. Can anybody tell how to create such sheets? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How to create sheet without gridlines?
Sandeep Parkhi wrote: Many times, I see the excel sheets prepared by others which do not contain Gridlines. In these sheets the Gridlines option in ToolsOptionsViewWindows Options is also enabled. Gridline colour is also Automatic. There is no sheet background as well. Can anybody tell how to create such sheets? Cells have a white fill. Ken Johnson |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How to create sheet without gridlines?
And what a waste when you can turn gridlines off!
-- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "Ken Johnson" wrote in message ps.com... Sandeep Parkhi wrote: Many times, I see the excel sheets prepared by others which do not contain Gridlines. In these sheets the Gridlines option in ToolsOptionsViewWindows Options is also enabled. Gridline colour is also Automatic. There is no sheet background as well. Can anybody tell how to create such sheets? Cells have a white fill. Ken Johnson |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How to create sheet without gridlines?
Where/How is this achieved from the menu?
"Ken Johnson" wrote in message ps.com: Sandeep Parkhi wrote: Many times, I see the excel sheets prepared by others which do not contain Gridlines. In these sheets the Gridlines option in ToolsOptionsViewWindows Options is also enabled. Gridline colour is also Automatic. There is no sheet background as well. Can anybody tell how to create such sheets? Cells have a white fill. Ken Johnson |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How to create sheet without gridlines?
Format/ Cells/ Pattern
-- David Biddulph "JMay" wrote in message ... Where/How is this achieved from the menu? "Ken Johnson" wrote in message ps.com: Cells have a white fill. Sandeep Parkhi wrote: Many times, I see the excel sheets prepared by others which do not contain Gridlines. In these sheets the Gridlines option in ToolsOptionsViewWindows Options is also enabled. Gridline colour is also Automatic. There is no sheet background as well. Can anybody tell how to create such sheets? |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How to create sheet without gridlines?
Thanks David, the word "Fill" was throwing me..
"David Biddulph" wrote in message : Format/ Cells/ Pattern -- David Biddulph "JMay" wrote in message ... Where/How is this achieved from the menu? "Ken Johnson" wrote in message ps.com: Cells have a white fill. Sandeep Parkhi wrote: Many times, I see the excel sheets prepared by others which do not contain Gridlines. In these sheets the Gridlines option in ToolsOptionsViewWindows Options is also enabled. Gridline colour is also Automatic. There is no sheet background as well. Can anybody tell how to create such sheets? |
|
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How to create sheet without gridlines?
Tools | Option; open Edit tab; in lower half (Windows Options) unselect
Gridline box best wishes -- Bernard V Liengme www.stfx.ca/people/bliengme remove caps from email "Sandeep Parkhi" <Sandeep wrote in message ... Many times, I see the excel sheets prepared by others which do not contain Gridlines. In these sheets the Gridlines option in ToolsOptionsViewWindows Options is also enabled. Gridline colour is also Automatic. There is no sheet background as well. Can anybody tell how to create such sheets? |
|
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How to create sheet without gridlines?
Thanks David. Thats the correct answer from all other posts.
"David Biddulph" wrote: Format/ Cells/ Pattern -- David Biddulph "JMay" wrote in message ... Where/How is this achieved from the menu? "Ken Johnson" wrote in message ps.com: Cells have a white fill. Sandeep Parkhi wrote: Many times, I see the excel sheets prepared by others which do not contain Gridlines. In these sheets the Gridlines option in ToolsOptionsViewWindows Options is also enabled. Gridline colour is also Automatic. There is no sheet background as well. Can anybody tell how to create such sheets? |
|
#9
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How to create sheet without gridlines?
Thats offcourse one of the ways of doing it but I had ruled that out in my
initial question itself. David has given me the correct answer. Thanks anyways. This is how we keep learning. "Bernard Liengme" wrote: Tools | Option; open Edit tab; in lower half (Windows Options) unselect Gridline box best wishes -- Bernard V Liengme www.stfx.ca/people/bliengme remove caps from email "Sandeep Parkhi" <Sandeep wrote in message ... Many times, I see the excel sheets prepared by others which do not contain Gridlines. In these sheets the Gridlines option in ToolsOptionsViewWindows Options is also enabled. Gridline colour is also Automatic. There is no sheet background as well. Can anybody tell how to create such sheets? |
|
#10
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How to create sheet without gridlines?
Sandeep Parkhi wrote: Many times, I see the excel sheets prepared by others which do not contain Gridlines. In these sheets the Gridlines option in ToolsOptionsViewWindows Options is also enabled. Gridline colour is also Automatic. There is no sheet background as well. Can anybody tell how to create such sheets? Could be PageSetup/Sheet/Gridlines is 'unchecked'. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Cell References | Excel Discussion (Misc queries) | |||
| Using an offset formula for the reference in a relative reference | Excel Worksheet Functions | |||
| Asked previously...can this not be done in excel | Excel Discussion (Misc queries) | |||
| Compiling macro based on cell values | Excel Discussion (Misc queries) | |||
| Does excel recognise names rather than cells? | Excel Worksheet Functions | |||
Linear Mode
