Windows 7 Forums
Welcome to Windows 7 Forums. Our forum is dedicated to helping you find support and solutions for any problems regarding your Windows 7 PC be it Dell, HP, Acer, Asus or a custom build. We also provide an extensive Windows 7 tutorial section that covers a wide range of tips and tricks.


Windows 7: Hide formulas

25 May 2014   #31
Sven1458

windows 7 ultimate x64
 
 

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 System SpecsSystem Spec
.
26 May 2014   #32
TanyaC

Linux Mint 17 Cinnamon | Win 7 Ult x64
 
 

lol. Good luck with your spreadsheet and excel learning.
My System SpecsSystem Spec
27 May 2014   #33
RickL1

Windows 7 Home 32bit
 
 

Quote   Quote: Originally Posted by Sven1458 View Post
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 System SpecsSystem Spec
.

Reply

 Hide formulas




Thread Tools




Similar help and support threads
Thread Forum
Excel 2016: Displaying formulas in the formula bar
I am using Win 7 Pro 7601 Multiprocessor Free SP1, 64-bit. Intel Core i7-4770, 16GB installed memory. Excel 2016. I have a spreadsheet with formulas, none of which display in the formula bar. All my other spreadsheets display their formulas in the bar. I have tried the following to display the...
Microsoft Office
Hide program hide popup.
I have windows media recorder set to record local talk radio for most of the day I have it set to record by the hour, it pops up to alert you its recording....every hour on the hour...and it pops up above EVERYTHING its driving me crazy, anyone know of a hide program program that can hide new...
Software
Taskbar (Auto-Hide) doesn't hide all the way?
My friend was wandering how you could get rid of that barely top part of the task bar when it is in auto-hide. So is this possible? Note: You have to look really close to see it.
Themes and Styles
A Program For Mathematical Drawings and Formulas
Hi, Does anybody know a program, using which I will be able to make mathematical drawings and write formulas at the same time? Any help will be greatly appreciated!
Software
Make explorer hide folders or hide files?
In Win 7 64 bit explorer, can I make it show me only folders or only files? Another way of saying this: can I make it hide folders, or hide files?
General Discussion


Our Sites

Site Links

About Us

Find 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 12:51.
Twitter Facebook Google+ Seven Forums iOS App Seven Forums Android App