Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
vishu
 
Posts: n/a
Default Excel Sheet default setting.

I have problem in Excel settings. I tried something in excel setting and its
saved.
Now problem is whenver open blank excel sheet it open with different setting.
Can you please tell me how to open the excel sheet in MS Excel default
settings.

regards
vishu

  #2   Report Post  
David McRitchie
 
Posts: n/a
Default

Hi Vishu,

do you mean tools, options
If you don't have a personal.xls file perhaps it would be a good
idea to create one so that it will be the first workbook that is opened.

If you do have one, then unhide it, cloase the other workbooks,
change your options, save your personal.xls file, and hide it again.
Window, unhide
Window, hide

Or might it be a style that is messing you up.
Format, Style, Normal
then save your workbook
--
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"vishu" wrote in message ...
I have problem in Excel settings. I tried something in excel setting and its
saved.
Now problem is whenver open blank excel sheet it open with different setting.
Can you please tell me how to open the excel sheet in MS Excel default
settings.

regards
vishu



  #3   Report Post  
vishu
 
Posts: n/a
Default

Dear david,

I have problem with excel setting, I have created correct template and saved
in XLStartup as .xlt file.
Now problem is when I open blank work book, it open as .xlt file but not .xls.
And one problem is if save it without changing any location it directly
saving as .xlt format.
Now I am totally confussed. I want to have factory default settings for
excel. Please advice me in this.


"David McRitchie" wrote:

Hi Vishu,

do you mean tools, options
If you don't have a personal.xls file perhaps it would be a good
idea to create one so that it will be the first workbook that is opened.

If you do have one, then unhide it, cloase the other workbooks,
change your options, save your personal.xls file, and hide it again.
Window, unhide
Window, hide

Or might it be a style that is messing you up.
Format, Style, Normal
then save your workbook
--
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"vishu" wrote in message ...
I have problem in Excel settings. I tried something in excel setting and its
saved.
Now problem is whenver open blank excel sheet it open with different setting.
Can you please tell me how to open the excel sheet in MS Excel default
settings.

regards
vishu




Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Marcro recroding/ stop Ikon not appearing in middle of excel sheet vishu Excel Discussion (Misc queries) 3 July 6th 05 11:37 PM
Periodically exporting Excel sheet to HTML SupportX New Users to Excel 1 July 4th 05 07:00 PM
Setting and KEEPING the default chart redbelly Charts and Charting in Excel 0 June 30th 05 02:35 PM
Does excel recognise names rather than cells? Sue Excel Worksheet Functions 9 May 22nd 05 04:51 AM
create price list from excel sheet -keevill- Excel Discussion (Misc queries) 1 February 8th 05 12:02 AM


All times are GMT +1. The time now is 04:21 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"