LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #3   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 492
Default hide formulas on the worksheet

CRTl + ` doesn't hide formulas, its a quick way to show all the formulas in
a sheet. The ` is the key to the left on the keyboard just below the escape
key, you can toggle formulas by doing this.
To hide your formulas as you want to do, click 'Edit' on the top toolbar,
click 'GoTo', click 'Special', check 'Formulas', OK
This will highlight all your formulas. Right click on one of the highlighted
areas, 'Format Cells', 'Protection', check 'Locked' and 'Hidden', OK
Protect the sheet using Tools Protection, apply a password if you want to
and there you go,
Regards,
Alan.
"Shariq" wrote in message
...
I searched on help menu for hiding formulas on the sheet, so what I found
was
this

Switch between displaying formulas and their values on a worksheet

Press CTRL + ` (grave accent).

but I've got no clue what it means to press control + ?? so what is this
grave accent?
how do I get it?
please help!

What I really want to do is in a worksheet what I have made for some
calculation pupose for other users too, to avoid any kind of overwriting
in
those cells containing formulas, to be protected+hide the formulas anyhow
so
what should be done to do this please somebody tell me.

thanks in advance



 
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
Linking Formulas, Worksheet to Worksheet - Excel 2003 windsong Excel Discussion (Misc queries) 2 November 14th 05 01:37 AM
copy worksheet to a new workbook with formulas .... but new file not point to old one newToExcel Excel Discussion (Misc queries) 7 November 13th 05 09:55 PM
Comparing a list to a Calendar worksheet. PatrickL Excel Worksheet Functions 0 August 25th 05 04:21 PM
Using worksheet names in formulas WightRob Excel Discussion (Misc queries) 2 August 7th 05 07:17 PM
copying formulas from worksheet to worksheet yesbob Excel Discussion (Misc queries) 1 February 7th 05 02:25 AM


All times are GMT +1. The time now is 08:23 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"