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".
  • Print selected rows and columns in Excel
    4 Now select Print selection for the first drop down and Settings section The Print Preview screen on the right hand side should immediately reflect the selected rows and columns Now use the Print button to take print out of the selected rows and columns Print Area The second method that we are going to see is by using the Print Area option available as part of Page Layout Step 1 Select the rows and columns and navigate to Print Layout menu Step 2 Navigate to Page Setup section then click Print Area option and select Set Print Area Step 3 Click File menu then Print menu to open the Print Screen The Print Preview screen should automatically display only the selected rows and columns without making any changes to Print Settings Now use the Print button to print the selection in Excel 2013 Set Print Area can be used when you are frequently printing only those selected rows and columns But make sure to clear the Print Area once you are done with your Printing In Category Excel 2013 Excel 2016 MS Office Tagged as Clear Print Area Excel 2013 Print Area Print Selection Rows and Columns Set Print

    Original URL path: http://blogmines.com/blog/print-selected-rows-and-columns-in-excel-2013/ (2016-04-25)
    Open archived version from archive

  • Clear Content
    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 2007 2016 blogmines com

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

  • Excel
    to insert to current date and time in Excel In Excel you can insert date and time using different formulas Listed below are the steps to insert date date and time and time in Excel 2016 2013 Excel 2010 and Excel 2007Navigate to the cell where you want to insert time and and press Ctrl Shift keysAlso See Disable conversion 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 15 How to change the decimal separator in Microsoft Excel Microsoft Excel 2013 and 2010 by default uses the system defined decimal separator In Windows 8 and Windows 7 this option is defined under the Regional and Language Settings available under Control Panel Step 1 Right click on the bottom end corner of Window 8 system and select Control Panel from the menu list In Read More Ravi

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

  • Preserve Format
    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 2007 2016 blogmines com

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

  • Save Format
    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 2007 2016 blogmines com

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

  • add sheet
    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 2007 2016 blogmines

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

  • prevent
    2016 2013 Read More Ravi Shankar 1 Prevent installing or uninstalling apps on iPad or iPhone In this tutorial we will be see the steps required to prevent any users from installing or uninstalling any apps on iPad or iPhone This is a useful tip if you are sharing your iPad with other people especially kids and do not want them accidentally uninstall and install any Apps To prevent users from removing Read More Ravi Shankar 4 Prevent kids from downloading adult apps on Google Nexus 7 This is about the step that needs to be taken to prevent your kids downloading adult content related apps on Google Nexus 7 Google Play Store allows users to restrict apps that can be downloaded based on their content You can use this feature to restrict any one from downloading apps based on content rating Read More Ravi Shankar 1 Prevent auto refresh of webpages in Firefox We had seen in the previous post about the auto refresh of webpage in Firefox But some websites have built in code to automatically refresh the web content at a pre defined time interval This tutorial is about the steps required to disable the automatic refresh of webpages in Firefox On Mac system click the Firefox Read More Ravi Shankar 3 Exclude folders from Spotlight search on Mac This tutorial provides the steps for excluding folders from Spotlight search on Mac System This is useful when you have private information in certain folders and don t want it to appear when any user does a Spotlight search Click the Apple icon and select System Preferences from the list of menus In the System Preferences window navigate Read More Ravi Shankar 0 How to disable auto sync of Ipad with iTunes The synchronization between iPad and iTunes

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

  • Protect Workbook Structure
    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 3 Different ways to protect workbook using Excel 2013 Excel 2013 provides users with different option to protect worksheet and workbook like Mark as Final Encrypt with Password Protect Current Worksheet Protect Workbook Structure

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



  •