• Skip to primary navigation
  • Skip to main content
  • Skip to primary sidebar

Digital Answers

How to tech tutorials in simple words

  • Home
  • About Us
  • Disclaimer
  • Privacy Policy

Excel 2013

How to change default ruler units in Excel

October 19, 2015 by Admin 1 Comment

The default ruler units in Excel 2016, 2013 and Excel 2010 is set to Centimetres and users can change this default units using the Settings available as part of the Excel options.

View Ruler in Excel 2013

The Page Layout view will be display the ruler in Excel. And in case if the ruler is not displayed then make sure to mark the checkbox with label as Ruler.

image

Change ruler units in Excel

Step 1: Click the File menu and select Options from menu list.

Step 2: In the Excel options window, click Advanced tab and navigate to Display section.

image

Step 3: In the Display section, click the Ruler units drop down and select your preferred unit.

image

Step 4: Click Ok button to apply and save the changes.

Filed Under: Excel, Excel 2010, Excel 2013, Excel 2016, MS Office Tagged With: Change, default units, Excel 2013, Ruler units, View Ruler

How to hide row and column headers in Excel

October 19, 2015 by Admin 1 Comment

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.

row and column headers in Excel 2013 and Excel 2010

Step 1: Click the File menu and then options link.

Step 2: In The Excel Options windows, select Advanced tab and scroll down to Display options for this worksheet section.

Step 3: To hide the rows and columns headers in a Excel 2010 worksheet, un mark the checkbox labelled as Show row and column headers.

Show row and column headers in Excel 2013 and Excel 2010

Click OK button available at the bottom of the screen to confirm the changes.

 

Excel worksheet without row and column header

Also See: How to hide header/footer while typing in Excel

Filed Under: Excel, Excel 2010, Excel 2013, Excel 2016, MS Office Tagged With: Excel 2010, headers, hide, Office 2010

How to check version of Excel

October 17, 2015 by Admin 3 Comments

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.

Help menu in Excel 2013 and Excel 2010

Navigate to the About Microsoft Excel section displayed on the right hand side. This would display the Excel Version details, as shown below.

About Microsoft Excel window in Excel 2013 and Excel 2010

Screenshot in Excel 2013

About Excel option in Excel 2013

And if you want to see additional information then you can click on the Additional Version and Copyright Information. This would display the following About Microsoft Excel Window

Excel version in Excel 2013 and Excel 2010

Also See: Disable automatic conversion of hyperlink in Excel

Filed Under: Excel, Excel 2010, Excel 2013, Excel 2016, MS Office Tagged With: About Excel, Check Version, Excel 2010, Office 2010

How to enable auto filter for protected sheet in Excel

October 10, 2015 by Admin 11 Comments

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 enabled while protecting the worksheet. This tutorial is about the steps required for enabling auto filter for a protected worksheet in Excel 2010.

Click the Protect Sheet option available under Review menu or Info menu.

Review Menu

Click Review menu –> Changes –> Protect Sheet

Review menu - Protect Sheet

Info Menu

Click File menu –> Info menu –> Protect Workbook –> Protect Current Sheet.

Info Menu - Protect Sheet

On clicking the Protect Sheet option would display the following Protect Sheet window.

Protect Sheet Excel 2010

Scroll down the “Allow all users of this worksheet to” list and make sure to tick the check box with caption as “Use AutoFilter”. Click OK button to confirm and save the changes.

Now excel users will be able to use the auto filter option even in a protected worksheet.

Protected Sheet with auto filter

Filed Under: Excel, Excel 2010, Excel 2013, Excel 2016 Tagged With: auto filter, Enable, Excel 2010, Protect, Worksheet

How to search, print and unhide comments in Excel

July 24, 2015 by Admin 3 Comments

Adding a comment to a cell in Microsoft Excel is very useful feature. You can always locate a comment by red arrow appearing at the top right corner of the cell.

Comments in Excel 2013 and Excel 2010

List below are the steps to search, print and unhide comments in Excel 2013 and Excel 2010.

Search comment in Excel 2013 and Excel 2010

But searching and finding inserted comments in a excel worksheet with number of rows spanning across more than a page will be a huge task. This can be simplified using the Search Comments option available as part of the Find feature. To find comments in Excel 2010 and Excel 2013, navigate to Editing section and click the drop down arrow available next to Find & Select option.

Find option in Excel 2013 and Excel 2010

This would display the following menu options as part of the Find & Select feature.

Find comments in Excel 2013 and Excel 2010

Click Comments from the list of available menus. This would locate the comment  in your Excel Worksheet. And if you have more than one comment, then press tab to navigate to each comment.

Print cell comment in Excel 2013 and Excel 2010

Excel by default does not print the comments and you can enable this feature using the Page Setup option.

Let us added the following comment for a cell in Excel Worksheet.

Print comments in Excel 2010 and Excel 2013

Now when you navigate to Print Preview option (File –> Print), Excel will not show the added comments. Click the Page Setup option available under Print Preview Settings page.

Page setup option in Excel 2013 and Excel 2010

In the Page Setup Window, click the Sheet tab and navigate to Print section. For comments drop down, choose “At end of sheet” or “As displayed on sheet” for Comments. Let us go with “At end of sheet”, click Ok button to confirm and save the changes.

image

Now the print preview screen will display the comments at the end of sheet and the same will get printed while printing the worksheet.

Print preview comments in Excel 2013 and Excel 2010

Unhide comment in Excel 2013 and Excel 2010

If you are not able see the comments in worksheet then you can try to use the unhide option available as part of the Excel Advanced Options.

  1. Click the File menu and then the Options link.
  2. In the Excel Option window, navigate to Advanced Options.
  3. Scroll down to display section and For cells with comments radio option select your preferred choice i.e either Indicators only, and comments on hover or Comments and indicators.

Unhide comments in Excel 2010 and Excel 2013

Click Ok to save and confirm the changes.

Also See: How to Insert, Delete, Customize Comments in Excel 2010

Filed Under: Excel, Excel 2010, Excel 2013, MS Office Tagged With: Excel 2010, find comments, navigate, print comments, search, unhide comments

How to Add calculator in Excel 2013 & 2010

July 21, 2015 by Admin 1 Comment

Excel users can customize the Quick Access Toolbar and add Calculator as part of the toolbar. This would allow users to access Calculator without leaving Excel application. Let us now see the steps for adding Calculator as part of QAT

Adding Calculator to Quick Access Toolbar in Excel 2013 & Excel 2010

Step 1: Launch Excel and click Customize Quick Access Toolbar dropdown.

Customize Quick Access Toolbar in Excel 2013

Step 2: Select More Commands from the drop down list.

Commands Not in the Ribbon

Step 3:  In the Excel Options window, select Commands Not in the Ribbon for the “Choose commands from” dropdown.

Caculator to QAT

Step 4: Scroll down the commands list and select Calculate Full or Calculator.

Add Calculator to QAT

Then Click Add button to add the command as part of the Customize Quick Access Toolbar list. Click OK button on Excel Options screen to close the Window.

Now you should see Calculator as part of QAT as shown in the below screenshot. And you can quickly access Calculator without leaving Excel 2013.

Calculator in Excel 2013

 

 

 

Filed Under: Excel, Excel 2013, Office 2013 Tagged With: Add Caculator, Customize Ribbon, Excel 2013, Quick Access Toolbar

  • « Go to Previous Page
  • Go to page 1
  • Go to page 2
  • Go to page 3
  • Go to Next Page »

Primary Sidebar

Recent Posts

  • Disable conversion of two numbers with dash as date in Excel
  • How to Protect Formulas in Excel
  • How to Change the Default Font in Excel
  • How to Add Country Code to Phone Automatically in Excel
  • How to Insert Pictures in Excel

blogmines.com Copyright © 2023