How to ungroup sheets, Right click on a sheet and Select Ungroup sheets.
It could be you have sheets grouped or you have Format as table activated.
Custom ViewĬustom view is a very useful tool when you find yourself changing the setting for printing your spread sheet, needing to change the page orientation, margins, page orientation, setting print area. When you use added features like a graph, Pivot Table, Table or Slicers you will notice an extra tab in the Ribbon specific to this task and at times you may be disabled from using one feature while another is turned on.
If you press Ctrl Enter you will exit the mode but stay in the same cell ready to preform your formatting. That is if you can see your cursor flashing in the cell next to the text or number you entered. Items on the Ribbon become greyed out when you are in Edit mode in a cell.