Hide formulas

Page 4 of 4 FirstFirst ... 234

  1. Posts : 135
    windows 7 ultimate x64
    Thread Starter
       #31

    Hi Tanya, thanks for your help.
    make it read only, now why did I not think of that.
    I think I will enroll in a class that teaches Excel to get more familiar with it. cant hurt.

    best regards
    Sven
      My Computer


  2. Posts : 784
    Linux Mint 17 Cinnamon | Win 7 Ult x64
       #32

    lol. Good luck with your spreadsheet and excel learning.
      My Computer


  3. Posts : 15
    Windows 7 Home 32bit
       #33

    Sven1458 said:
    I have another Question:
    is it possible that after data input in the first 4 columns, the form must be printed and can not be saved with the data in it? Tis way the form is always empty when you open it.

    Thanks
    Sven
    The first thing to do is to SAVE your file in multiple locations so that you will have backup copies that do not have any data entered. You have worked too hard on this to lose it due to a twitch of a finger. I have seen a few instances of the Read-Only being override-able. For the part about always starting with a blank sheet, consider saving the "daily use" copy as a Template. When things work properly in a template, a User can try to Save it and is then required to use a new/different name for the file. File->Save-As->File Type = Template(.xlt)
      My Computer


 
Page 4 of 4 FirstFirst ... 234

  Related Discussions
Our Sites
Site Links
About Us
Windows 7 Forums is an independent web site and has not been authorized, sponsored, or otherwise approved by Microsoft Corporation. "Windows 7" and related materials are trademarks of Microsoft Corp.

© Designer Media Ltd
All times are GMT -5. The time now is 05:49.
Find Us