Become an Excel Master with Our Expert Guides

We provide comprehensive guides on Microsoft Excel, designed to help you become an expert in no time. From basic concepts to advanced techniques, we cover it all. Discover the full potential of Excel with ExcelGraduate.

Blog Videos

 

SKILL Matters

Strong Basics Means Smooth Workflow

Learning the basics of Microsoft Excel will butter-smooth your Excel workflow; hence you can be hyper-productive.

Formulas

Formulas are everything about Microsoft Excel. Expertise in Excel formulas will make your life a lot easier.

Pivot Table

Analyze your business within a bleak of an eye by using Pivot Table. It’s such an amazing feature inside MS Excel.

VBA

Make your own customized function using Microsoft Excel VBA. You can do some incredible stuff with the help of MS Excel VBA.

Our Recent Posts

Frequently Asked Questions

That’s because your spreadsheet is in Read Only mode. To change the settings,

  1. Right-click on your spreadsheet file name.
  2. From the pop-up menu, choose Properties.
  3. Under the General tab, look for the Attributes option. You will find it at the bottom of the General tab.
  4. Uncheck the Read Only option.

That’s because your cell border is not wide enough to display the contents into the cell. Drag the right border of the cell further away to avail enough space for the cell content. This will solve the problem.

  1. First, press CTRL + H keys to avail the Find and Replace dialog box.
  2. Keep the mouse cursor in the Find What box.
  3. Then press and hold the ALT button and type 0160. This will insert a hard space into the Find What box.
  4. After that leave the Replace With box blank.
  5. Now hit the Replace All button.
  1. Go to the Formulas tab.
  2. From the Formula Auditing group, click on the Show Formulas button.

Or, press CTRL + ~ keys together to display the cell formulas.

  1. Click on the cell where you want to insert the current date.
  2. After that type =NOW() into that cell.
  3. Then hit the ENTER button.

Because your Calculation Options feature is set to Manual. To set it to Automatic.

  1. Go to the Formulas tab.
  2. From the Calculation group, click on the Calculation Options.
  3. From the drop-down list, click on Automatic.