DATABASE FUNDAMENTALS
HOW TO INSERT HEADERS FOOTERS IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
#VALUE!
|
|
|
#####
|
|
|
#NUM!
|
|
|
#REF!
|
Detailed explanation-1: -How to Resolve This Error. Click on the right border of the column header and increase the column width. Pro Tip: You can double-click the right border of the header to automatically fit the widest cell in that column.
Detailed explanation-2: -Microsoft Excel might show ##### in cells when a column isn’t wide enough to show all of the cell contents. Formulas that return dates and times as negative values can also show as #####.
Detailed explanation-3: -Excel displays the error message #REF! in those cells to indicate a cell reference error.
Detailed explanation-4: -The #### error occurs when the column isn’t wide enough to fit the cell data. Double-click the line to the right of the column letter for the column containing the error.
Detailed explanation-5: -The most common reason you’ll see a ##### error in Excel is that the contents of the cell don’t fit into the column width. In other words, there isn’t enough space to display your content.