• 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

Office 2010

How to change worksheet theme in Excel

October 8, 2015 by Admin Leave a Comment

In this short tutorial we will be seeing how to change theme of worksheet in Excel 2016, Excel 2013 & Excel 2010. You can change the theme using the option available as part of the Page Layout menu.

Navigate to Page Layout and click the Themes menu option under Themes section. The themes option allows users to change the overall design of the worksheet including fonts, colors and effects.

image

From the Themes drop down, you can pick any theme from the built-in list. If you want to look for more themes then you can download themes from office.com and select it using the Browse For themes option. Excel 2010 also provides option to save the current theme for future re-use.

Filed Under: Excel, Excel 2010, Office 2010 Tagged With: chgange, Colors, effects, Excel 2010, Fonts, theme, Worksheet

How to turn off auto calculation in Excel

October 2, 2015 by Admin 1 Comment

In this tutorial, we will see how to disable auto calculation in Excel 2016, 2013 & 2010. Auto calculation in Excel is an useful feature which would automatically recalculate results based on the changes to the input values. But if you want to temporarily disable this option then you can use the settings available as part of the Formulas Ribbon menu.

Step 1: Launch Excel Application and click the Formulas menu.

image

Step 2:  Navigate to the Calculation section and click on the Calculation Options.

image

Step 3: Select Manual from the Calculation Options drop down list.

Now when ever user makes any changes to excel cell values and if any formula is based on these input cells then the result will not be automatically recalculated.

There is also an option available to do manual recalculation.  Navigate to the Calculation section and click the Calculate Sheet available next to Calculation options.

image

Filed Under: Excel, Excel 2010, MS Office, Office 2010

Hide worksheet formula in Excel 2013 & Excel 2010

July 26, 2015 by Admin Leave a Comment

Excel 2013 and Excel 2010 allow users to hide formula used in a Worksheet. You can use this feature when you want to prevent any one from accidentally changing the entered formula.

Let us say you want to hide the formula (=SUM(F5:F8)) which has been used in the bellow example.

image

Select the cell where the formula has been entered and navigate to Format menu and click the Format Cell menu option (You can also right click and select Format Cell in the Context menu).

In the Format Cell window, navigate to Protection tab and tick the checkbox with Label as Hidden. Click the Ok button to save the changes.

image

Then right click on the Sheet and select Protect Sheet from the list of available menu option.

image

In the Protect Sheet window, tick the check box with label as Protect worksheet and contents of locked cells.

image

If you want to just hide formula then it is not needed to password protect the sheet. Click Ok button to save the changes.

Now when you navigate to the Formula Cell, the formula bar will not displayed any information.

image

Bu this you can prevent excel users from seeing formula used in the worksheet.

Filed Under: Excel, Excel 2010, Office 2010 Tagged With: Excel 2010, Format Cell, Formula, Hidden, hide, Protect, Worksheet

How to unhide comments in Excel

July 25, 2015 by Admin 1 Comment

Excel 2013 and Excel 2010 generally shows comments in worksheet with the Indicator as shown below.

image

And when you hover over the indicator it will display the added comments.

image

But in case if you are not able see the comments added to your worksheet then try the unhide option available as part of the

  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.
    4. Click Ok to save and confirm the changes.

image

Filed Under: Excel, Excel 2010, Office 2010 Tagged With: comments, Excel 2010, indicator, unhide comments

How to Insert, Delete, Customize Comments in Excel

July 22, 2015 by Admin 8 Comments

This tutorial provides information on the comment feature available in Excel 2013 & Excel 2010. The following will be covered as part of this tutorial.

  • How to insert comment
  • Customize the comment box
  • Navigate between Comments
  • Delete Comment

How to insert comment

Excel allows users to insert comment using the options available as part of the Review menu. But if you want to quickly insert then right click on the cell and select Insert Comment from the listed menus.

image

image

 

Customize Comment

A typical comment box in Excel is as shown below.

image

In order to change the name that appears on the Comment box, click on the File menu then the Option link then in the General tab, navigate to Personalize your copy if Microsoft Office and enter your desired name in the User name box. Click OK button to save the changes. Now the entered name will appear when you Insert new Comments.

image

Similarly if you want to change the Font Style used in Comment box then select then right click on the Comment box and select Format Comment menu option.

image

The Format Comment window allows you change the Comments Font Style.

image

Navigate between Comments

If you have more than one comment inserted in the Excel worksheet and you want to navigate between the comments then you can use the menu options available as part of the Comment section under Review menu. The list option includes Show All Comments, Previous and Next.

image

Delete Comment

A Comment can be quickly deleted are hidden by right clicking on the cell and selecting the required menu option. You can also use the menu option available as part of the Comments section under Review menu.

image

image

By this way you can Insert, customise, navigate and delete comments in Excel 2013 and Excel 2010

Filed Under: Excel, Excel 2010, Office 2010 Tagged With: comments, Cutomize, Delete, Excel 2010, hide, Insert, navigate, Office 2010, Show

How to recover a workbook in Excel 2013 and Excel 2010

May 29, 2015 by Admin 1 Comment

recycle files  folder

This tutorial explains the auto recover feature available in Excel 2013 and Excel 2010. The auto recover feature regularly takes a backup of the workbook and stores it in a pre defined location. This feature is useful if Excel suddenly crashes and you want to recover the working copy.

Document Recovery

A document recovery pane will be displayed on the left hand side of the Excel worksheet when excel is opened after a crash.This would contain the workbook(s) which were kept open during the crash.

image

If you want to recover any of the displayed workbook, then select the required file from the available files list.

Change AutoRecover file location

You can specify the path for auto recovery feature using Save workbooks Options. Click the File menu then Options link and then navigate to the Save tab.

image

Again navigate to the Save workbooks section in Save Options screen. Using AutoRecover file location you can specify the path for automatic backup.

Change AutoRecover Time interval

Using Save AutoRecover information spinner field you can increase or decrease the minutes at which the auto save needs to happen.

Disable AuoRecovery

We have seen the importance of AutoRecovery feature in Excel and by default this is enabled. But Excel also provides option for disabling this feature.

image

You can disable this by navigating to AutoRecover exceptions section then un tick the checkbox with label as Disable AutoRecover for this workbook only.

Any changes made to this would get reflected after clicking on the OK button available at the bottom of the Save options screen.

del.icio.us Tags: Excel 2010,auto recover,auorecovery,workbook,backup,file location,time interval

Filed Under: Excel, Excel 2010, Excel 2013, Office 2010, Office 2013 Tagged With: auorecovery, auto recover, Backup, Excel 2010, file location, time interval, Workbook

  • « Go to Previous Page
  • Go to page 1
  • Go to page 2
  • Go to page 3
  • Go to page 4
  • 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