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".
  • Excel 2016
    cursor to the Read More Ravi Shankar 1 Screen capture in Excel Excel 2016 2013 allows users to insert screenshot of open windows or take quick snapshot of part of screen The screen capture feature in Excel is available as part of the Insert menu Click the Insert menu and navigate to Illustrations section Under Illustrations section click the Screenshot option Now if you want to insert any open Read More Ravi Shankar 1 How to move or copy worksheets in Excel This is a short tutorial is about the steps required for moving or copying worksheets in Excel 2016 and Excel 2013 Excel users can copy or move users using the right click context menu or Format menu options Step 1 Select the Sheet tab that needs to be copied or moved If you want to copy Read More Ravi Shankar 1 How to use conditional formatting to colour alternate rows in Excel Excel 2016 2013 users can use conditional formatting to colour alternate rows Let us take the following sample dataNow you can add background colours to alternate rows by adding conditional formatting rules Listed below are the steps for changing the background colour of alternate rows using conditional formatting Step 1 Select the data for which the Read More Ravi Shankar 2 How to use Watch Window in Excel Watch Window in excel helps users to monitor cells and their formulas This tool is quite useful when you have a large data set and want to periodically monitor the result Let us see this with an example worksheet used for calculating expenses This excel worksheet uses formula for calculating Total monthly expenses and Annual Expense Read More Ravi Shankar 0 How to hide and unhide worksheets in Excel When you are sharing your excel workbook to other users and want to hide unnecessary worksheets then you can follow below mentioned steps 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 Read More Ravi Shankar 2 How to enable developer menu in Excel This tutorial is about the steps required to enable developer menu Excel 2016 and Excel 2013 The Developer menu provides option for writing VBA code enable or disable add ins form controls and XML interactionsStep 1 Click the File menu and select Options from the list Step 2 In the Excel Options window navigate to Customize Ribbon Read More Ravi Shankar 1 How to quickly send worksheet as PDF in Excel We have already covered the procedure for converting excel worksheet in to PDF In this short tutorial we are going to see the the steps required for quickly sending worksheet as PDF in Excel 2016 and Excel 2013 Step 1 Open the Excel worksheet that needs to shared with other as PDF file Step 2 Click the Read More Ravi Shankar 0 Excel displays formula instead of value In

    Original URL path: http://blogmines.com/blog/category/ms-office/office-2016/excel-2016/ (2016-04-25)
    Open archived version from archive


  • Auto fill
    you turn off auto complete suggestion feature if you find it distracting Listed below are the steps to disable autocomplete suggestion in Excel 2016 Excel 2013 Read More Ravi Shankar 15 How to disable auto fill feature in Excel Auto fill in excel is quite handy feature using this you can fill series of cells based on the entries of other excel cells But if you want to turn off or disable auto fill feature then you can use Excel options for doing this Listed below are the steps to turn off auto fill Read More Ravi Shankar 0 Fill rows and columns with Time values in Excel This tutorial is about the different steps required automatically generate time based data as shown below in Excel The difference between the rows and columns are 10 17 19 25 and 15 respectively Instead of manually entering these values we can automatically generate using the TIME function and excel auto fill feature Step 1 Read More Ravi Shankar 18 How to turn on or off Auto fill feature in Excel 2007 Auto fill in excel is quite handy feature Using this you can fill series of cells based on the entries of

    Original URL path: http://blogmines.com/blog/tag/auto-fill/ (2016-04-25)
    Open archived version from archive

  • Autocomplete
    save password message in Internet Explorer 10 Internet Explorer 10 ie10 displays a message Do you want Internet Explorer to remember the password when you try to sign in to any website with username and password You can turn off this message using the AutoComplete settings under Internet Options Step 1 Click Settings icon on the Internet Explorer 10 and select Internet Read More Ravi Shankar 2 Manage website user credentials on Windows 8 Windows 8 has a feature that allows users to manage the web credentials saved via Internet Explorer 10 This option is helpful when you have forgotten the website username or you do not want to save the user credential Click the Tools menu on the Internet Explorer 10 and select Internet Options from the menu Read More Ravi Shankar 2 How to enable autocomplete in Google Docs Spreadsheet Autocomplete feature helps users by automatically filling the content of cell when users starting entering the first couple of letters in the Cell The automatic entry is picked from the previously entered values for the same column Let us say you have got the following list of entries in one of the columnArizonaAlabamaCaliforniaFloridaIndianaNow when you start Read More

    Original URL path: http://blogmines.com/blog/tag/autocomplete/ (2016-04-25)
    Open archived version from archive

  • Disable
    Listed below are the steps to turn off auto fill Read More Ravi Shankar 2 Enable or disable automatic numbered and bulleted list in Word Microsoft Word users can use automatic numbered and automatic bulleted list by typing and 1 respectively By default these features are disabled in Word Listed below are the steps to disable automatic numbered and bulleted list in Word 2016 Word 2013 and Word 2010Click on the File menu Word Options Navigate to Read More Ravi Shankar 1 How to turn off drag and drop of text in Word Microsoft Word 2016 2013 and 2010 has feature using which you can drag and drop the text in a document But if you do not want drag and drop then you can use Word Options to disable or turn off the feature Listed below are the steps to turn off drag and drop of text Read More Ravi Shankar 1 Disable automatic conversion of hyperlink in Excel Excel 2016 2013 and 2010 have feature that automatically does a conversion of all web address in to hyperlinks This conversion takes place as you complete typing the internet address But if you want to turn off this feature then you can use the relevant settings available as part of Excel options Step 1 Click the Read More Ravi Shankar 6 Turn Off password popup in Outlook This is in reply to a query posted by a reader in this blog that Mine was doing the automatic from the start I only want it send and receive when I click on send and receive I took the check marks off send automatic but now every time I click send receive a pop up comes Read More Ravi Shankar 1 Turn off displaying users photos in Outlook We had earlier seen about the steps required for configuring social network accounts such LinkedIn Facebook etc in Outlook 2016 Outlook 2013 If a sender has photos linked to their social network account then it is displayed in the email message header section as shown below But if you do not want to display Read More Ravi Shankar 7 Save messages in sent items folder in Outlook Microsoft Outlook automatically saves the sent messages in sent items folder But if you do not want to automatically save the sent messages then you can turn off this feature using Outlook Options Listed below are steps to enable or disable saving copies of messages in Sent Items folder in Outlook 2013 Outlook 2010 and Read More Ravi Shankar 1 How to turn off display of screen tips in PowerPoint 2013 2010 PowerPoint 2013 and 2010 displays screen tips along with feature description when we hover the mouse over the menu items By default screen tip feature is enabled in PowerPoint but if you do not want this extra information to be displayed then you can turn off using PowerPoint options Click File menu and then Options linkIn Read More Ravi Shankar 3 How to turn off

    Original URL path: http://blogmines.com/blog/tag/disable/ (2016-04-25)
    Open archived version from archive

  • Enable
    How to enable auto filter for protected sheet in Excel We had already seen the following tutorials related with protection of worksheet in Excel 2016 2013 2010 Prevent users from adding new worksheet Password Protect Worksheet in Excel Unprotect Worksheet in Excel And if a worksheet with auto filter is protected then users will not be able to use auto filter unless it is Read More Ravi Shankar 3 Enable automatic warning for missing attachment in Outlook How many times you have sent an email referring to attached documents but with out any attachments Now here is a feature in Outlook 2016 Outlook 2013 that would display a warning message if it finds the message might be missing attachments For example an email message that has text such as Please find Read More Ravi Shankar 0 Show or hide envelope icon for new message in Outlook A envelope icon will be displayed in Windows Taskbar when a new email message is received in Outlook 2010 and Outlook 2013 This is the default behaviour of Outlook and in case if this is not displayed then you can enable this feature using mail Options available as part of Outlook Settings Listed below are Read More Ravi Shankar 1 How to turn off display of screen tips in PowerPoint 2013 2010 PowerPoint 2013 and 2010 displays screen tips along with feature description when we hover the mouse over the menu items By default screen tip feature is enabled in PowerPoint but if you do not want this extra information to be displayed then you can turn off using PowerPoint options Click File menu and then Options linkIn Read More Ravi Shankar 1 How to enable auto archive in Outlook Outlook archive feature is useful when your company has restriction on users Outlook Mailbox size and you want to backup old emails periodically to your archive folder Outlook 2013 and Outlook 2010 allows auto archiving of folders using the Outlook Options To enable auto archive feature in Outlook 2010 and Outlook 2013 click File menu Read More Ravi Shankar 9 How to enable a disabled add in in Excel 2010 Office products such as Word Excel Outlook will automatically disable installed add in if any add in prevented the software from functioning correctly And it also provides option for enabling the disabled add in items In Excel 2010 you can enable a disabled add in using the add in options Click the File menu Options link Navigate to Read More Ravi Shankar 2 How to disable advance slide on mouse click in PowerPoint In this short beginners PowerPoint 2013 and PowerPoint 2010 tutorial we will see the steps to disable advance slide on mouse click During a slide show you can move to next slide either by pressing ENTER or SPACEBAR on keyboard or on mouse click And using Transitions menu you can disable or enable the advance Read More Ravi Shankar 6 How to enable auto logon on Windows This tutorial provides step

    Original URL path: http://blogmines.com/blog/tag/enable/ (2016-04-25)
    Open archived version from archive

  • Excel 2010
    with the other Sheet This can be done by Read More Ravi Shankar 3 How to change date system for a workbook in Excel Microsoft Excel allows users to change to 1904 date system difference between 1900 and 904 date system using the Excel Advanced Options Listed below are the steps to change the date system in Excel 2016 2013 and 2010Step 1 Click the File menu then select Options link Step 2 In the Excel Options window click Advanced Read More Ravi Shankar 0 How to hide row and column headers in Excel Excel Worksheet by default displays the rows and columns header For some reason if you want to hide these headers then you can use Excel Advanced Options Listed below the steps to hide or unhide row and column headers in Excel 2016 Excel 2010 and Excel 2010 Step 1 Click the File menu and then options Read More Ravi Shankar 0 How to display results inside shapes in Excel Here are the steps required for displaying any calculation result or cell value inside shapes in Excel 2016 2013 and 2010 Let us see this with an example that displays the max of marks obtained in a shape Step 1 Create the required Data set Step 2 Select the cell to calculate the Max of marks in Read More Ravi Shankar 3 How to check version of Excel In Excel 2016 2013 and 2010 the version of excel can be checked using the Help or Account menu Click the File menu and select Help menu Navigate to the About Microsoft Excel section displayed on the right hand side This would display the Excel Version details as shown below Screenshot in Excel 2013And if you want to Read More Ravi Shankar 0 Rename a worksheet in Excel In this short beginners tutorial let us see the different ways to rename an worksheet in Excel 2016 2013 and Excel 2010 The easiest option to rename a sheet is to simply double click the Sheet tab and rename it nbsp Read More Ravi Shankar 0 Print end date of previous month in Excel In Microsoft Excel if you want to find out the end date of previous month for the given current date then you can use TODAY or EOMONTH TODAY Returns the current date formatted as a date EOMONTH Returns the number of the last day of month before or after the specified number of month For example Read More Ravi Shankar 0 How to turn off printing cell errors in Excel In the previous post we had seen how to print cell comments in Excel and in this tutorial we will be seeing the steps required to turn of the cell errors displayed while printing a Worksheet in Excel 2016 2013 and 2010 A worksheet displays different cell errors for example when you have an invalid expression Read More Ravi Shankar 0 How to quickly find the sum of selected range in Excel Even beginners to Microsoft Excel

    Original URL path: http://blogmines.com/blog/tag/excel-2010/ (2016-04-25)
    Open archived version from archive

  • Office 2010
    4 Go To specific page number in Word In Word 2013 and Word 2010 you can go to specific page in the Word document using the Find and Replace dialog To display the Find and Replace dialog Navigate to Home menu and click on the drop down arrow under Find menu Another shortcut for launching Find and Replace is by pressing Ctrl Read More Ravi Shankar 2 Repeat action keyboard shortcut in Microsoft Office Microsoft Office Applications such as Word and Excel last action can be repeated using keyboard shortcuts For example if you have formatted a word with specific style and you want to repeat apply the same format for other words then you can press F4 or Ctrl Y or Alt Enter This can be used Read More Ravi Shankar 1 Find and change default pst file location in Outlook PST file Refers to the pst personal storage table filename extension used by Microsoft products The file is a locally stored copy of any message task calendar item etc from Microsoft Exchange mailboxes The default location of archive pst in Outlook is C Users username Documents Outlook Files archive pst You can find the default pst file location in Outlook 2010 and Read More Ravi Shankar 4 How to do a word wrap in Excel In Excel 2016 2013 and 2010 when the typed text is larger than the width of the cell the text entered will appear as single line of text If you want to align this text to the width of the cell then you can use excel 2010 word wrap feature If you want to do the Read More Ravi Shankar 11 What is a status bar in Word document Microsoft Word 2016 2013 and 2010 displays a status bar at the bottom of a Word document Word status bar displays information such word count page number line number zoom zoom slider Language and many more details These details displayed on the word status bar can be configured by using the Customize Status Bar context menu Read More Ravi Shankar 1 How to turn off drag and drop of text in Word Microsoft Word 2016 2013 and 2010 has feature using which you can drag and drop the text in a document But if you do not want drag and drop then you can use Word Options to disable or turn off the feature Listed below are the steps to turn off drag and drop of text Read More Ravi Shankar 9 How to create a link between two worksheets in Excel In this short beginners tutorial let us see the steps for creating a simple link between two worksheets in Excel 2016 2013 and 2010 In Excel two worksheets can be linked using the paste options 1 From Sheet1 Copy the cell value which needs to be linked with the other Sheet This can be done by Read More Ravi Shankar 3 How to change date system for a workbook in Excel Microsoft

    Original URL path: http://blogmines.com/blog/tag/office-2010/ (2016-04-25)
    Open archived version from archive

  • Suggestion
    Shankar 1 Disable autocomplete suggestion feature in Excel Excel Auto Complete features automatically suggests a value based on previous entries Similar to disabling auto fill feature Excel provides option for disabling the autocomplete suggestion feature as well So you turn off auto complete suggestion feature if you find it distracting Listed below are the steps to disable autocomplete suggestion in Excel 2016 Excel 2013 Read More 2007 2016 blogmines com

    Original URL path: http://blogmines.com/blog/tag/suggestion/ (2016-04-25)
    Open archived version from archive



  •