Bayt.com

Start networking and exchanging professional insights

Register now or log in to join your professional community.

Follow

In Excel when we enter numbers, the value appears as # in cells Whats the keyboard shortcut to resolve this matter other than mouse?

Only Keyboard shortcut combination is required.!

Microsoft Excel
user-image
Question added by Mukkaram Siddique , Finance, Management & Stocks , Amazon Foods Saudi Arabia
Date Posted: 2014/04/22
Upvote (2) Views (15) Followers (3) Answers (4) Report Question
Write an Answer
Register now or log in to answer.
Atif Tanveer
by Atif Tanveer , Decision Support Specialist , Hamilton Health Science

ALT + H + O + I - Excel2007

ALT + O + C + A - Excel2003

Deleted user

Good question, and to be honest never used it. the Alt O C A works in Excel2013 version as well as the Alt O invokes the earlier versions of excel shortcuts.

Rahul kumar Rahul
by Rahul kumar Rahul , SAP EXECUTIVE , APTARA TECHBOOKS

null character/DAta mismatch

Gaone Mookodi
by Gaone Mookodi , Procurement Officer , Third Market Pty (Ltd)

press Alt key followed by F1key

Write Your Answer
More Questions Like This

Do you need help in adding the right keywords to your CV? Let our CV writing experts help you.

Get Help