Would you like to react to this message? Create an account in a few clicks or log in to continue.



 
HomeTheAppleBytesLatest imagesMailRegisterLog in

Share | 
 

 Hide Cell Contents in Microsoft Excel

View previous topic View next topic Go down 
AuthorMessage
PHOENiX.505
Administrator
Administrator


Location : Noida, India
iPoints : 63430
Warning Level : Safe

Hide Cell Contents in Microsoft Excel Empty
PostSubject: Hide Cell Contents in Microsoft Excel   Hide Cell Contents in Microsoft Excel Icon_minitime16th March 2011, 9:39 pm

1)Start Microsoft Excel and open an existing workbook that contains cells you would like to hide the contents of, or start a new workbook and enter some content into a cell that you would like to hide.

2)Select the cells that contain data you would like to hide. You can select cells by clicking on them and using the SHIFT or CTRL keys on your keyboard to select additional cells.

3)Choose the "Format" menu and click "Cells" to open the "Format Cells" dialog box.

4)Click on the "Number" tab in the "Format Cells" dialog box to display the formats that can be applied to Excel cells.

5)Select "Custom" from the "Category" text box so you can type your own custom formatting to hide your selected cells.

6)Type 3 semicolons (;;Wink in the "Type" text box to tell Excel that you want to hide the cells.

7)Click the "OK" button to close the "Format Cells" dialog box and hide the selected cells.
Back to top Go down
http://www.theapplebytes.com
 

Hide Cell Contents in Microsoft Excel

View previous topic View next topic Back to top 

 Similar topics

-
» Hide your External IP and prevent yourself from getting traced.
» 'COUNT' Function in MS Excel.
» Creating a "Splash Screen" for a Excel Workbook.
» Break Excel Workbook Internal Passwords using a Macro
» Apple now beats Microsoft in most metrics, including profits
Page 1 of 1

Permissions in this forum:You cannot reply to topics in this forum
 :: . . : : Tips Tricks & Tweaks : : . . :: . . : : Microsoft Office : : . . :: . . : : Microsoft Excel : : . .-
Create a forum | ©phpBB | Free forum support | Report an abuse | Forumotion.com
© Copyright TheAppleBytes | All Rights Reserved.