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 move or copy worksheets in Excel
    Format menu options Step 1 Select the Sheet tab that needs to be copied or moved If you want to copy or move more than one Worksheets then press Ctrl key on the Keyboard and select the Sheet tabs Step 2 Right on selected Sheet tabs and select Move or Copy from the menu list Or you use Format menu option and select Move or Copy Sheet from the dropdown list This should then display the following Move or Copy Window Step 3 Now if you want to move the worksheet within the same workbook then choose the sheet under Before Sheet And to move or copy the Worksheets to different workbook click To book dropdown and select the Workbook The To book dropdown will list only the open workbooks In order to copy worksheets make sure to mark the check box with caption as Create a copy In Category Excel 2013 Excel 2016 MS Office Tagged as Copy Worksheets Excel 2013 Move Worksheets 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

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


  • Excel 2007
    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 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 0 VLOOKUP function in Mircrosoft Excel explained with an example VLOOKUP in Excel can be used to automatically populate values from a given list based for specified identifier For example you can use VLOOKUP to pre populate employee code based on employee name Let us take the following example where the employee list name code is defined in the range A2 B6 Now we can use VLOOKUP Read More Ravi Shankar 5 Change display of recent documents workbooks in Excel Microsoft Excel has a feature that allows users to change the number of recent workbooks or documents shown in the Open screen Listed below are the steps to increase or decrease the recent documents in Excel 2013 Excel 2010 and Excel 2007 Recent documents or workbooks in Excel 2013 and Excel 2010 The default value Read More Ravi Shankar 1 How to change the installed user name in Microsoft Excel Microsoft Excel by default takes the installed user s name as the owner of the installed version You can personalize the username to your desired name using the Excel options This is the same username that appears when you add a comment in Excel worksheet Listed below are the the steps to be followed to update Read More Ravi Shankar 2 Disable conversion of two numbers with hyphen as date in Excel Microsoft Excel has a feature that automatically coverts two numbers separated by hyphen in to a date formatted value For example if you type 6 7 in a cell Excel would reformat this in to a date value as 7 Jun But if you do not want to reformat then you can use any of the below Read More Ravi Shankar 0 Tables and Borders in Microsoft Office 2007 Tables and Borders is a very useful styling property in Microsoft Office 2007 Using this you can create a new table and style it to best suit to your document Here I will discuss some of the useful aspects of Tables and Borders which is necessary in almost every Office environment even in Excel How Read More Ravi Shankar 18 How to turn on or off Auto fill feature

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

  • Office 2007
    if the emails are Read More Ravi Shankar 1 How to clear content only in Excel Microsoft Excel provides users with various formatting option such as Number Currency Date and time that can be applied to a cell But if you have a scenario where you want to only clear the content of the excel sheet and to preserve the format applied to the cells then you can use Clear Contents Read More Ravi Shankar 1 Request for delivery message and receipt message in Outlook Microsoft Outlook users can request for delivery message and read receipt message These options are useful to keep track of the messages that are being sent and to find out whether the users have actually read these messages Let us see the steps required for enabling tracking feature in Outlook 2013 Outlook 2010 and Outlook Read More Ravi Shankar 3 How to sort list of items in Word In Microsoft Word you can automatically sort list items in a paragraph This can be done by using the Sort Option present in Paragraph ribbon For example if you want to sort the following list of items London New York Paris Delhi Tokyo Select the list items in the paragraphThen navigate to paragraph section in the Read More Ravi Shankar 7 Autocorrect in Word Replace text as you type Autocorrect in Microsoft Word 2016 Word 2013 2010 and 2007 has a feature called replace any text as you type This tutorial provides an example for replacing text with text and image in Word document Replace text as you type in Word 2016 Word 2013 Word 2010 and Word 2007In Word 2013 and Word 2010 you Read More Ravi Shankar 0 How to include original message in Outlook Microsoft Outlook users can include the original message while forwarding or replying to an email The users can choose any one of the following options for original message Do not include original message Attach original message Include original message text Include and indent original message text Prefix each line of the original message Listed below Read More Ravi Shankar 1 Turn Off feature description in screen tips in Microsoft Word In Microsoft Word 2007 screen tips are available for each command The screen tips by default show feature description For example the replace command screen tips with feature description looks as shown belowMicrosoft Word provides option to enable or disable feature description in Screen Tip If you do not want to display the feature description Read More Ravi Shankar 5 How to automatically clear deleted items folder in Outlook When you delete any items in Microsoft Outlook they are moved to the deleted items folder Microsoft Outlook has an option to automatically clear deleted items folder when user quits the application In this tutorial we will see the steps to enable auto clear deleted items option in Outlook 2016 Outlook 2013 Outlook 2010 Outlook Read More Ravi Shankar 18 Disable permanently delete items warning message in Outlook Outlook displays a

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

  • Office 2010
    in Excel 2013 Excel 2010 Read More Ravi Shankar 0 A trick to flip a column upside down in Excel Excel users can sort a column using the Sort feature available as part of Sort Filter menu But what if you want to flip a column upside down Let us see this with an example column having some text values as shown below We will not be able to apply sort feature directly on this Read More Ravi Shankar 0 How to schedule email delivery in Outlook Outlook provides users with the option of scheduling an email message so that it can be delivered at a later time For example if you are in a boring meeting and want to catch up with your pending emails during the meeting then use this option to schedule your replies Because if the emails are Read More Ravi Shankar 1 How to clear content only in Excel Microsoft Excel provides users with various formatting option such as Number Currency Date and time that can be applied to a cell But if you have a scenario where you want to only clear the content of the excel sheet and to preserve the format applied to the cells then you can use Clear Contents Read More Ravi Shankar 2 Prevent users from adding new worksheet in Excel Excel 2016 2013 and 2010 provides an option to prevent users from adding new worksheet to existing Workbook structure So if you are the owner of Excel file and you do not want to allow other users to add any new worksheet rename or move worksheet then you can use Protect Workbook Structure option to Read More Ravi Shankar 0 Change outgoing port for email accounts in Outlook The outgoing port for an email account configured in Outlook 2016 2013 and 2010 can be changed using the Change Account options To change the outgoing port click File menu then navigate to Account Settings and click the Account Settings dropdown arrowThis would display the following Account Settings window with different E mail accounts Now select the Read More Ravi Shankar 2 Slide Show keyboard shortcuts in PowerPoint PowerPoint 2016 2013 and 2010 Slide Show keyboard shortcut will be displayed as part Slide Show help by pressing F1 during a Slide Show The different Slide Show Shortcuts available as part of PowerPoint are Advanced to the next slide N space right or down arrow enter or page down Return to the previous slide Read More Ravi Shankar 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 3 Insert a Cover Page for document in Word Now using Word 2010 2013 and 2016 you

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

  • Office 2013
    in Excel 2013 Excel 2010 Read More Ravi Shankar 0 A trick to flip a column upside down in Excel Excel users can sort a column using the Sort feature available as part of Sort Filter menu But what if you want to flip a column upside down Let us see this with an example column having some text values as shown below We will not be able to apply sort feature directly on this Read More Ravi Shankar 0 How to schedule email delivery in Outlook Outlook provides users with the option of scheduling an email message so that it can be delivered at a later time For example if you are in a boring meeting and want to catch up with your pending emails during the meeting then use this option to schedule your replies Because if the emails are Read More Ravi Shankar 1 How to clear content only in Excel Microsoft Excel provides users with various formatting option such as Number Currency Date and time that can be applied to a cell But if you have a scenario where you want to only clear the content of the excel sheet and to preserve the format applied to the cells then you can use Clear Contents Read More Ravi Shankar 2 Prevent users from adding new worksheet in Excel Excel 2016 2013 and 2010 provides an option to prevent users from adding new worksheet to existing Workbook structure So if you are the owner of Excel file and you do not want to allow other users to add any new worksheet rename or move worksheet then you can use Protect Workbook Structure option to Read More Ravi Shankar 0 Change outgoing port for email accounts in Outlook The outgoing port for an email account configured in Outlook 2016 2013 and 2010 can be changed using the Change Account options To change the outgoing port click File menu then navigate to Account Settings and click the Account Settings dropdown arrowThis would display the following Account Settings window with different E mail accounts Now select the Read More Ravi Shankar 2 Slide Show keyboard shortcuts in PowerPoint PowerPoint 2016 2013 and 2010 Slide Show keyboard shortcut will be displayed as part Slide Show help by pressing F1 during a Slide Show The different Slide Show Shortcuts available as part of PowerPoint are Advanced to the next slide N space right or down arrow enter or page down Return to the previous slide Read More Ravi Shankar 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 3 Insert a Cover Page for document in Word Now using Word 2010 2013 and 2016 you

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

  • Decrease sheets
    Shankar 1 How to increase number of worksheets Excel Microsoft Excel by default contains 3 worksheets while creating a new Workbook For creating a new workbook you can specify the number of Worksheet that a Workbook needs to contain This can be modified using Excel Options Listed below are steps for increasing number of Worksheets for a new Workbook in Excel 2013 Excel 2010 Read More 2007 2016 blogmines com

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

  • increase sheets
    needs to contain This can be modified using Excel Options Listed below are steps for increasing number of Worksheets for a new Workbook in Excel 2013 Excel 2010 Read More Ravi Shankar 0 How to increase the default number of sheets in Excel The default number of sheets for a new workbook is set to 1 in Excel 2016 Excel 2013 and Excel 2010 But Users are allowed to change

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

  • Workbook
    Power Point Similarly an excel workbook can be made read only using Excel Options Listed below are the steps to make a workbook read only in Excel 2013 and Excel 2010 Click on the File menu Info menu Click on Read More Ravi Shankar 0 How to see and update workbook properties in Excel 2013 This tutorial is about the steps to see and update workbook properties in Excel 2013 Launch Excel 2013 click File menu and select Info from the menu list In the Info screen navigate to Properties section available on the right hand side The Properties panel will display details such Size Title Tags Categories Date and Read More Ravi Shankar 1 How to hide header footer while typing in Excel 2010 This is in response to question asked by a reader of this blog related with header and footer in Excel 2010 how do I make the header footer not visible on the page while typing When you click on the insert header and footer option in Excel 2010 excel would immediately change the view Read More Ravi Shankar 0 How to change default number of worksheet in Excel 2011 Mac The number of worksheet associated with a new workbook in Excel 2011 for Mac is 1 And if your work requires adding a worksheet then you can click the plus sign to insert new sheet If you always require minimum of 3 worksheet in your new workbook then it is recommended to change the default Read More Ravi Shankar 0 How to password protect workbook in Excel Mac 2011 Excel for Mac 2011 users can password protect the workbook using the option provided as part of the File menu Click the File menu and select Passwords from the displayed menu list This would display the

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



  •