1. Home
  2. Office 365
  3. Microsoft Excel: Frequently Asked Questions

Microsoft Excel: Frequently Asked Questions

1. Why do I see ### in some of my columns instead of data?

If a column is too narrow to display the data, you will see ### in the cell. You can manually adjust the column width or row height by dragging the cell boundaries. Learn more: Resize Rows and Columns.

2. One of the columns in my worksheet is missing. How can I see it?

Your column is hidden. You can unhide the column by double-clicking the boundary between the columns flanking the hidden column. Learn more: Unhide (show) columns or rows.

3. One of the rows in my worksheet is missing. How can I see it?

Your row is hidden. You can unhide the row by double-clicking the boundary between the rows flanking the hidden row.  Learn more: Unhide (show) columns or rows.

4. How can I filter a worksheet to display only the data that I want to see?

You can use the Filter option in Excel to display only the rows that meet criteria that you specify. Learn more: Filter data in a table.

5. Why does my menu (called the “ribbon”) disappear when I’m not using it?

You may have inadvertently hidden your ribbon. The quickest way to show the ribbon all the time is to double-click on any visible tab, like Home, Insert or Draw. Learn more: Show or hide the ribbon in Office.

6. How do I unmerge cells?

You can split merged cells by using the Unmerge Cells function on the Home tab. Learn more by watching the 30 second video on this page: Merge and unmerge cells.

 

Updated on March 7, 2018

Was this article helpful?

Related Articles