Search notes:
Tabs (Menus) in Excel's Ribbon bar
File _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ The File's item are not displayed on the Ribbon, but in vertical order
Info
(Security Warning) _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ Allows to enable disabled content such as Macros, Data connections and workbook links.
Protect Workbook _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ Controls the types of changes that users can make in a workbook.
Inspect Workbook _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ Finds and optionally removes properties (see below) and PivotTable, PivotChart, cube formulas, slicers and timeline, macros, hidden names etc.
Manage Workbook
BrowserView Options
Properties _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ Such as size, title, tags, categories, last modified, created, last printed, author etc. (Compare with *Inspect Workbook* above)
Related Dates _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ Last modified, created, last printed
Related People _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ Author, Last Modified By
Related Documents Including «Edit Links»
Save
Save As
Print
Share
Export _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ Create PDF/XPS documents.
Publish _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ Publish to *Power BI*.
Close
Account _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ Choose *Office Theme*, manage *Account privacy*, sign in to Office …
Feedback
Options
General
Formulas _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ Related to formula calculation, performance, and error handling
Data Data import and data analysis
Proofing _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ How text is corrected and formatted
Save How Workbooks are saved
Language _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ Office Language Preferences
Ease of Access
Advanced
Customize Ribbon
Quick Access Toolbar
Add-ins _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ Manages add-ins
Trust Center
Home
Clipboard
Paste
Use Text Import Wizard
Paste Special
Cut
Copy
Copy
copy as Picture
Format Painter
Font
Alignment
Top|Middle|Bottom Align
Aligh Left|Center|Right
Angle…
Wrap Text
Merge & Center
Merge & Center
Merge Across
Merge Cells
Unmerge Cells
Sensitivity (or «Protection» in older versions?) _ _ _ Microsoft Azure Information Protection
Sensitivity (or «Protect»)
Show Bar
Custom Permissions
Track and Revoke
Help and Feedback
Number
Number Format
Accounting Formats
Percent Style
Comma Style (with thousands separator)
Increase/decrease decimal
Styles
Conditional Formatting
Format as Table
Cell Styles
Cells
Insert
Insert Cells
Insert Sheet Rows
Insert Sheet Columns
Insert Sheet
Delete
Delete Cells
Delete Sheet Rows
Delete Sheet Columns
Delete Sheet
Format
Cell Size
Row Height
AutoFit Row Height
Column width
AutoFit Column Width
Default Width
Visibility
Hide & Unhide
Organize Sheets
Rename Sheet
Move or Copy Sheet
Tab Color
Protection
Protect Sheet
Lock Cell
Format Cells
Editing
Auto Sum|Average|Count Number|Max|Min|…
Fill Down|Right|Up|Left|Across Worksheets|Series…|Justify|Flash Fill
Sort & Filter
Find & Select
Ideas
Ideas
Ideas
Insert
Tables
PivotTable
Recommended PivotTables
Table
Illustrations
Pictures
Online Pictures
Shapes _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ When working with shapes, also includes the Format tab on the ribbon, see below
Icons
3D Models
SmartArt
ScreenShot _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ Insert a screenshot of any currently running application.
Add-ins _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ Compare with with «Add-ins» under «Developer»
Charts
Tours
Sparklines
Filters
Links _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ Hyperlinks to files, webpages, places in this document, to create new documents and eMail addresses
Comments
Text
Symbols
Draw
Tools
Select
Draw with Touch
Erase
Lasso Select
Pens
Add Pen
Convert
Ink to Shape
Ink to Math
Replay
Ink Replay
Page Layout
Themes
Themes
Colors
Fonts
Effects
Page Setup
Margins
Orientation
Size
Print Area
Breaks
Background
Print Titles
Scale to Fit
Width
Height
Scale
Sheet Options
Gridlines (View, Print)
Headings (View, Print)
Arrange
Bring Forward
Send Backward
Selection Pane
Align
Group
Rotate
Formulas
Function Library
Insert Function
AutoSum
Recently Used
Financial
Logical
Text
Date & Time
Lookup & Reference
Math & Trig
More Functions
Defined Names
Name Manger
Define Name
Use in Formula
Create from Selection
Formula Auditing
Trace Precedents
Trace Dependents
Remove Arrows
Show Formulas
Error Checking
Watch Window _ _ _ _ _ _ _ _ _ Allows to select cells whose values will be watched.
Calculation
Data
Get & Transform Data _ _ _ _ _ _ _ Access features to combine and shape data from a variety of sources (See also the workbookQuery object)
Get Data
From File
From Database
From Azure
From Online Services
From Other Services
Combine Queries
Launch Power Query Editor
Data Source Settings
Query Options
From Text/CSV
From Web
From Table/Range
Recent Sources
Existing Connections
Queries & Connections
Refresh All
Queries & Connections
Properties
Edit Links
Sort & Filter
Sort
Filter
Clear
Reapply
Advanced
Data Tools
Text to Columns
Flash Fill
Remove Duplicates
Data Validation _ _ _ _ _ _ _ _ Define restrictions for allowed data types and value ranges that can be entered into cells.
Consolidate
Relationships
Manage Data Models (= Go to the Power Pivot Window in Office 365?)
Forecast
What-If Analysis
Forecast Sheet
Outline
Group/Ungroup
Subtotal
Show/Hide Detail
Review
Proofing
Spelling
Thesaurus
Workbook Statistics
Accessibility
Check Accessibility
Insight
Smart Lookup
Language
Translate
Comments
New Comment
Delete
Previous Comment
Next Comment
Show Comments
Notes
Notes
Protect
Unprotect Sheet
Protect Workbook
Allow Edit Ranges
Unshare Workbook
Ink
Hide Ink
View
Workbook Views
Normal
Page Break preview
Page Layout
Custom Views
Show
Ruler
Gridlines
Formula Bar
Headings
Zoom
Zoom
100 %
Zoom to Selection
Window
New Window
Arrange All
Freeze Panes _ _ _ _ _ _ _ _ _ keep a specified portion (such as first row or left most column) of a worksheet visible while navigating through the rest of the worksheet.
Split
Hide/Unhide
View Side by Side
Synchronous Scrolling
Reset Window Position
Switch Windows
Macros
View Macros
Record Macros
Use Relative References
Developer _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ Must be enabled, otherwise not shown
code
Add-ins _ _ _ _ _ _ _ _ _ _ _ _ _ Compare with «Add-ins» under «Insert»
Controls
Insert
Form Controls
ActiveX Controls
Design Mode _ _ _ _ _ _ _ _ _ _ toggle between enabled and disabled.
Properties
View Code
Run Dialog
XML
Help
Data Streamer
Data Sources
Connect a Device
Import Datafile
Data Streaming
Start Data
Stop Data
Data Recording
Record Data
Stop Recording
Capture Screen
Advanced
Reset Data
Advanced
Inquire
Report
Workbook Analysis
Diagram
Workbook Relationship
Worksheet Relationship
Cell Relationship
Compare
Compare Files
Miscellaneous
Clean Excess Cell Formatting
Workbook Passwords
Help
Power Pivot
Data Model
Calculations
Tables
Relationships
PivotTable Analyze _ _ _ _ _ _ _ _ _ _ Visible only when pivot tables etc. are worked on
PivotTable
ActiveField
Group
Filter
Data
Actions
Calculations
Tools
Show
Design _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ Visible only when pivot tables etc. are worked on
Layout
PivotTable Style Options
PivotTable Styles
Format (images) _ _ _ _ _ _ _ _ _ _ _ _ Visible only when images are worked on
Adjust
Picture Styles
Accessibility
Arrange
Size
Format (shapes) _ _ _ _ _ _ _ _ _ _ _ _ Visible only when shapes are worked on
Insert Shapes
Shape Styles
WordArt Styles
Accessibility _ _ _ _ _ _ _ _ _ _ _ As in *Format (images)* ?
Arrange
Size
Search