Spreadsheet Default Settings

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hello

I would like to adjust my default settings for excel sheet such that
whenever I open a new sheet it has as default the file path of spreadsheet
whenever it is printed out. Also I would like that gridlines do not show (ie
Tools, Options, Display gridlines = No)

I am certain this can be done in VB but cnanot remember how - any help
appreciated
 
Start a new workbook--single sheet only
Set up the footer and gridlines the way you want.
Save that workbook as a template in your XLStart folder. Name it sheet.xlt.

Then try it out.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Printing a blank spreadsheet 4
Gridlines won't show up in excel 2007 6
Excel 2002 default to printing gridlines 1
Gridlines have to be chosen each time 1
Printing a blank spreadsheet. 7
gridlines won't display 1
Setting Gridlines - Excel 2007 6
gridlines missing in web version 1

Back
Top