How to create sheet without gridlines? in Excel General Questions    |   |  Help   Search For:     In:   Office   Excel     Excel General Questions     Excel New users     Excel Application Errors     Excel Charts     Excel Programming     Excel Setup     Excel Worksheet Functions              Sandeep Parkhi 1/16/2007 12:59 AM PST   Question   Many times, I see the excel sheets prepared by others which do not contain Gridlines. In these sheets the Gridlines option in Tools>Options>View>Windows Options is also enabled. Gridline colour is also Automatic. There is no sheet background as well. Can anybody tell how to create such sheets?     Was this post helpful to you?         Reply |   Top           Ken Johnson 1/16/2007 1:30 AM PST   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 Tools>Options>View>Windows > 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     Was this post helpful to you?         Reply |   Top           Bob Phillips 1/16/2007 4:18 AM PST   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" <KenCJohnson@gmail.com> wrote in message news:1168939760.474976.20080@38g2000cwa.googlegroups.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 Tools>Options>View>Windows > > 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 >     Was this post helpful to you?         Reply |   Top           JMay 1/16/2007 4:18 AM PST   Where/How is this achieved from the menu? "Ken Johnson" <KenCJohnson@gmail.com> wrote in message news:1168939760.474976.20080@38g2000cwa.googlegroups.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 Tools>Options>View>Windows > > 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     Was this post helpful to you?         Reply |   Top           David Biddulph 1/16/2007 5:20 AM PST   Answer   Format/ Cells/ Pattern -- David Biddulph "JMay" <jmay@cox.net> wrote in message news:Kk3rh.1427$lc5.162@newsfe20.lga... > Where/How is this achieved from the menu? > "Ken Johnson" <KenCJohnson@gmail.com> wrote in message > news:1168939760.474976.20080@38g2000cwa.googlegroups.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 >> > Tools>Options>View>Windows >> > Options is also enabled. Gridline colour is also Automatic. There is no >> > sheet >> > background as well. Can anybody tell how to create such sheets?     Was this post helpful to you?         Reply |   Top           JMay 1/16/2007 5:24 AM PST   Thanks David, the word "Fill" was throwing me.. "David Biddulph" <groups@biddulph.org.uk> wrote in message news:45acccbf_1@glkas0286.greenlnk.net: > Format/ Cells/ Pattern > -- > David Biddulph > > "JMay" <jmay@cox.net> wrote in message > news:Kk3rh.1427$lc5.162@newsfe20.lga... > > Where/How is this achieved from the menu? > > > "Ken Johnson" <KenCJohnson@gmail.com> wrote in message > > news:1168939760.474976.20080@38g2000cwa.googlegroups.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 > >> > Tools>Options>View>Windows > >> > Options is also enabled. Gridline colour is also Automatic. There is no > >> > sheet > >> > background as well. Can anybody tell how to create such sheets?     Was this post helpful to you?         Reply |   Top           Sandeep Parkhi 1/16/2007 10:19 PM PST   Thanks David. Thats the correct answer from all other posts. "David Biddulph" wrote: > Format/ Cells/ Pattern > -- > David Biddulph > > "JMay" <jmay@cox.net> wrote in message > news:Kk3rh.1427$lc5.162@newsfe20.lga... > > Where/How is this achieved from the menu? > > > "Ken Johnson" <KenCJohnson@gmail.com> wrote in message > > news:1168939760.474976.20080@38g2000cwa.googlegroups.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 > >> > Tools>Options>View>Windows > >> > Options is also enabled. Gridline colour is also Automatic. There is no > >> > sheet > >> > background as well. Can anybody tell how to create such sheets? > > > >     Was this post helpful to you?         Reply |   Top           Bernard Liengme 1/16/2007 5:52 AM PST   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 Parkhi@discussions.microsoft.com> wrote in message news:DB730A1F-B1D8-4806-A16E-7C88730A207F@microsoft.com... > Many times, I see the excel sheets prepared by others which do not contain > Gridlines. In these sheets the Gridlines option in > Tools>Options>View>Windows > Options is also enabled. Gridline colour is also Automatic. There is no > sheet > background as well. Can anybody tell how to create such sheets?     Was this post helpful to you?         Reply |   Top           Sandeep Parkhi 1/16/2007 10:19 PM PST   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 Parkhi@discussions.microsoft.com> wrote in message > news:DB730A1F-B1D8-4806-A16E-7C88730A207F@microsoft.com... > > Many times, I see the excel sheets prepared by others which do not contain > > Gridlines. In these sheets the Gridlines option in > > Tools>Options>View>Windows > > Options is also enabled. Gridline colour is also Automatic. There is no > > sheet > > background as well. Can anybody tell how to create such sheets? > > >     Was this post helpful to you?         Reply |   Top           Harry's GMail World 1/17/2007 2:06 PM PST   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 Tools>Options>View>Windows > 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'.     Was this post helpful to you?         Reply |   Top         Return to Microsoft Communities   Notify me of replies