archive-com.com » COM » B » BLOGMINES.COM

Total: 339

Choose link from "Titles, links and description words view":

Or switch to "Titles and links view".
  • How to use conditional formatting to colour alternate rows in Excel
    colour of alternate rows using conditional formatting Step 1 Select the data for which the conditional formatting needs to be applied Step 2 Click Conditional Formatting menu option and select New Rule from the menu list Step 3 In the New Formatting Value window select the Rule Type as Use a formula to determine which cells to format Step 4 Now copy the formula MOD ROW 2 0 inside Format values where this formula is true Step 5 Click the Format button under New Formatting Value and specify the colour for the rows matching this condition Step 6 Now to add another colour for rows ending with odd number repeat Step 1 and Step 2 But enter the formula as MOD ROW 2 1 Then choose a colour for the rows matching this condition If you want to edit these rules for changing the colours then click Conditional Formatting menu and select Manage Rules option In Category Excel 2013 Excel 2016 MS Office Tagged as Alternate rows background colour Conditional Formatting Excel 2013 Spread the word How to insert current date and time in Word How to set Out of Office reply in Outlook Disable autocomplete suggestion feature in Excel

    Original URL path: http://blogmines.com/blog/how-to-use-conditional-formatting-to-colour-alternate-rows-in-excel-2013/ (2016-04-25)
    Open archived version from archive


  • How to use Watch Window in Excel
    2013 The Watch Window can be accessed by navigating to Formula menu and then the Formula Auditing section Adding Cell to Watch Window You can monitor a cell by selecting it and then click Add Watch option under Watch Window In the above screenshot we are adding cell E38 as part of the Watch Window After adding the cell you should be able to watch the value and the corresponding formula You also have an option to drag the Watch Window to any desired location on the Window In the below screenshot the Watch Window has been positioned at the bottom right hand side Even if you scroll down your Worksheet the Watch Window would remain in this position Delete Cell from Watch Window Excel users can remove a cell from Watch Window by selecting the row and clicking the Delete Watch Option available at the top of the Window In Category Excel 2013 Excel 2016 MS Office Tagged as Add Watch Delete Watch Excel 2013 Monitor Cell Monitor Formulas Watch Window Spread the word How to insert current date and time in Word How to set Out of Office reply in Outlook Disable autocomplete suggestion feature in Excel How

    Original URL path: http://blogmines.com/blog/how-to-use-watch-window-in-microsoft-excel/ (2016-04-25)
    Open archived version from archive

  • How to hide and unhide worksheets in Excel
    you want to Unhide the Sheet then again right click on the Sheet tab and select Unhide option This should then display the following Unhide window with a list of hidden sheets Now select the Sheet that needs to unhidden Hide Unhide using xlSheetVeryHidden attribute If you want to make life little tougher for the users to unhide the worksheet then you can use xlSheetVeryHidden attribute to hide a Worksheet Click the Developer menu and navigate to Controls section If you cannot find Developer menu on Office Ribbon then check steps to enable developer menu in Excel Click the Properties option under Controls section This should display the following Properties for the selected Worksheet Now to hide the Worksheet set the value of Visible property to xlSheetVeryHidden To unhide the worksheet navigate to Developer menu and click Visual Basic option under Code section Now select the Worksheet that needs to be unhidden Then click View menu and select Properties Window from the menu list Now change the value of Visible property from xlSheetVeryHidden to xlSheetVisible By this way you can unhide the Worksheet using xlSheetVeryHidden attribute In Category Excel 2013 Excel 2016 MS Office Tagged as Excel 2013 Hide Worksheet

    Original URL path: http://blogmines.com/blog/how-to-hide-and-unhide-worksheets-in-excel-2013/ (2016-04-25)
    Open archived version from archive

  • How to perform simple math calculation in Word
    More Commands from the drop down list Step 2 Now to Customize the Quick Access Toolbar select Commands Not in the Ribbon for Choose commands from dropdown Step 3 Then select Calculate from the commands list and Add that as part of Customize Quick Access Toolbar Click Ok button available at the bottom of the Word Options window to confirm and save the changes Now the Calculate command should be in QAT as shown in the below screenshot Also See Customize quick access toolbar in Word Perform Simple Math Calculation in Word Document If you want to find out the sum of the following series of numbers then select those numbers and click Calculate on QAT The result of this calculation will be displayed in the status bar Calculate sums the series of numbers of no operator is specified If you want multiply some numbers then make sure to enter the numbers along with Operator and click the Calculate on QAT In Category MS Office Word 2013 Word 2016 Tagged as Addition calculate Math Calculation Multiplication Quick Access Toolbar Word 2013 Spread the word How to insert current date and time in Word How to set Out of Office reply

    Original URL path: http://blogmines.com/blog/how-to-perform-simple-math-calculation-in-word-2013/ (2016-04-25)
    Open archived version from archive

  • Add Office ribbon command to Quick Access Toolbar in Word
    click on Show Comments command Step 3 Select Add to Quick Access Toolbar option from the listed menus This should add the Show Comments command as part of Quick Access Toolbar Removing command from Quick Access Toolbar Word 2016 2013 users can remove a command from QAT by simply right clicking on the command and selecting Remove from Quick Access Toolbar option In Category MS Office Word 2013 Word 2016

    Original URL path: http://blogmines.com/blog/add-office-ribbon-command-to-quick-access-toolbar-in-word-2013/ (2016-04-25)
    Open archived version from archive

  • Fix functionality is currently limited problem in Word
    menu lit Step 2 Click the Convert option under Info section This display the following dialog asking for your confirmation Click OK button to convert the document to new file format The above steps will apply only for the current document And if you want this to be permanent file format then change the default file format to docx In Category MS Office Word 2013 Word 2016 Tagged as Compatibility

    Original URL path: http://blogmines.com/blog/fix-functionality-is-currently-limited-problem-in-word-2013/ (2016-04-25)
    Open archived version from archive

  • How to use Word as PDF Converter
    Open the word document that needs to be converted to PDF Step 2 Click File menu select Save As from the menu list and double click on the Computer option Step 3 In the Save As window select PDF pdf for the Save as type dropdown list Then enter filename and click Save button Convert document to PDF using Export Option Step 1 Open the word document that needs to be converted to PDF Step 2 Click the File menu and select Export from the menu list Step 3 In the Export screen select Create PDF XPS Document and click Create a PDF XPS Document from the menu list Step 4 In the Publish as PDF or XPS document enter name for the PDF file and click Publish button In Category MS Office Word 2013 Word 2016 Tagged as Export to PDF PDF Converter Publish PDF Save As PDF Word 2013 word document Spread the word How to insert current date and time in Word How to set Out of Office reply in Outlook Disable autocomplete suggestion feature in Excel How to increase number of worksheets Excel A trick to flip a column upside down in Excel Ravi Shankar A

    Original URL path: http://blogmines.com/blog/how-to-use-word-2013-as-pdf-converter/ (2016-04-25)
    Open archived version from archive

  • How to check document compatibility in Word
    Navigate to Inspect Document section and select Check Computability from the Check for Issues dropdown list This should display the following Microsoft Word Compatibility Checker window along with summary of compatibility issues for the current document Step 4 Click the Select versions to show option and pick the version from the list This will filter out the issues based on the selected Word version In Category MS Office Word 2013

    Original URL path: http://blogmines.com/blog/how-to-check-document-compatility-in-word-2013/ (2016-04-25)
    Open archived version from archive



  •