A Complete Guide To Become An Excel Expert

Skyrocket your productivity by mastering the basics of Microsoft Excel. With this comprehensive Excel course, you’ll learn everything you need to know about Microsoft Excel.

Get Started
Learn More

 

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.

Boost Up Your MS Excel Workflow!

Learn the basics of Microsoft Excel and improve your productivity.

Get Started
(Visited 1,178 times, 9 visits today)