KKCOMPUTERINFO

  1. Making a Word File Customized Read-Only/password protect/restrict editing. A Word document can be made "read-only" using different methods. The document will then allow users to view it but prevent editing unless explicitly allowed. Below are the common ways to do this: Method 1: Protecting Document Using Password This prevents unauthorized editing by asking for a password to make changes. Steps: Open the Word document. Go to the File tab. Click Info/ prepare tab in the left sidebar. Click on Protect Document/encrypt documents . Choose Encrypt with Password . Set a password and confirm it. Save the document. Now, users need the password to edit it.   Method 2: Restricting Editing You can restrict editing in a Word file by allowing only specific types of changes, such as filling in forms. Steps: Open the Word document. Go to the Review tab. Click on Restrict formatting and Editing in the Protect sectio...

1. Quick Auto Border for Entire Table To quickly add borders to an entire table or selection, use the Format as Table option: Select the range of cells you want to format. Go to the Home tab on the ribbon. Click on Format as Table and choose a style. This automatically applies borders around your data, giving your table a clean, organized look. You can adjust the colour or style of the border if needed. 2. Using Conditional Formatting for Borders Excel’s Conditional Formatting tool lets you apply borders based on specific conditions, which is great for automatically highlighting certain data: Select the cells you want to format. Go to Home > Conditional Formatting > New Rule . Choose a rule (e.g., cells greater than a specific value). Under the Format button, click on Borders and choose your desired border style. The borders will automatically adjust based on the rule you've set. 3. Auto Borders with ...

  HLOOKUP (Horizontal Lookup) is a function in Excel that searches for a value in the top row of a table or range and returns a value in the same column from a row you specify. Syntax: HLOOKUP(lookup_value, table_array, row_index_num, [range_lookup]) lookup_value : The value you want to search for in the first row of the table. table_array : The range of cells that contains the data. row_index_num : The row number in the table from which to return the value. The top row is row 1. [range_lookup] : Optional. TRUE for an approximate match or FALSE for an exact match (default is TRUE). Example: Consider this table: A B C D Name John Sara Tom Age 25 30 22 Height 5'9" 5'5" 6'1" If you want to look up Sara's age , you can use the fol...