Show or hide subtotals and totals in a PivotTable
When you create a PivotTable that shows value amounts, subtotals and grand totals appear automatically, but you can also show or hide them. Show or hide subtotals. Click anywhere in the PivotTable to show the PivotTable Tools. Click Design > Subtotals. Pick the option you want: Do Not Show Subtotals. Show all Subtotals at Bottom of Group.
Show the ribbon - Microsoft Support
Expand the ribbon in Excel to find the commands you need. Click any tab to show the Ribbon, or use the Ribbon Display Options at the top of your document.
Design the layout and format of a PivotTable - Microsoft Support
On the Display tab, under Display, do one or more of the following: To show items with no data on rows, select or clear the Show items with no data on rows check box to display or hide row items that have no values.
Hide error values and error indicators in cells - Microsoft Support
When your formulas have errors that you anticipate and don't need to correct, but you want to improve the display of your results. There are several ways to hide error values and error indicators in cells in Excel.
Show or hide the ribbon in Office - Microsoft Support
Customize the ribbon in Office. Show the ribbon when hidden, and set options to shows tabs and commands, just tabs, or automatically hide the ribbon for the maximum document space.
Hide or Unhide worksheets - Microsoft Support
Hide or display workbook windows with the Single Document Interface, where each workbook opens in its own window. Click File > Options . Then click Advanced > Display > clear or select the Show all windows in the Taskbar check box.
Customize the ribbon in Office - Microsoft Support
You can add custom tabs or rename and change the order of the default tabs that are built in to Office. Custom tabs in the list have (Custom) after the name, but the word (Custom) does not appear in the ribbon. To work with your ribbon, you need to get to the Customize the Ribbon window. Here's how you do that.
Display or hide formulas - Microsoft Support
You can control the display of formulas in the following ways: Switch between displaying formulas and their results from the ribbon. Switch between displaying formulas and their results from the keyboard. Prevent a formula from displaying in the formula bar. Show formulas that were previously hidden by removing protection.
Show or hide gridlines on a worksheet - Microsoft Support
Show or hide gridlines in Word, PowerPoint, and Excel. Print gridlines in a worksheet. Gridlines are the faint lines that appear around cells to distinguish them on the worksheet. By default, gridlines are displayed in worksheets using a color that is assigned by Excel.
Edit titles or data labels in a chart - Microsoft Support
If your chart contains chart titles (ie. the name of the chart) or axis titles (the titles shown on the x, y or z axis of a chart) and data labels (which provide further detail on a particular data point on the chart), you can edit those titles and labels.
Keyboard shortcuts in Excel - Microsoft Support
Display the context menu, or "right click" menu. Shift+F10 Display a pop-up menu (on object button menu), such as by clicking the button after you paste into a sheet.