Insert tab > Text group > Header & Footer Insert tab > Illustrations group > Insert a SmartArt Graphic Insert tab > Illustrations group > Screenshot Insert tab > Illustrations group > Shapes Insert tab > Illustrations group > Online Pictures Insert tab > Illustrations group > Pictures The Insert tab contains ten groups – 1-Tables, 2-Illustrations, 3-Add-ins, 4-Charts, 5-Tours, 6-Sparklines, 7-Filters, 8-Links, 9-Text, and 10-Symbols. The Insert tab provides additional functions for things you may need to insert into the worksheet, such as tables, pictures, charts, links, filters, headers and footers, symbols, etc. Insert (cells, rows, columns, and sheets)ĭelete (cells, rows, columns, and sheets) Home tab > Clipboard group > Format PainterĪLT + H, FS, use the DOWN ARROW or type the size and press ENTER Home tab > Clipboard group > Paste Special Paste from the clipboard and choose formatting Home tab commands Actionĭelete selection and copy it to the clipboard The Home tab contains seven groups – 1-Clipboard, 2-Font, 3-Alignment, 4-Number, 5-Styles, 6-Cells, and 7-Editing. It contains the options to apply formatting and styles to text, cut and paste as well as search your worksheet. The Home tab contains the most used functions/features. Options – Customize the way Excel looks and functions, including the commands available on the ribbons
Publish – Once you’re finished preparing your data analysis, you can share it with your workgroup or clients through Power BI.Īccount – Manage your Office, Windows and One Drive accounts
Share – Share the spreadsheet via email, Web, SharePoint, etc.Įxport – Convert the spreadsheet to a different file format History – See a complete list of changes that have been made to your workbook and access earlier versions. Save As – Save the workbook with a new name or in a new location (Save as) Information: The circled arrow in the top left corner of the backstage screen will return you to your spreadsheet. This tab contains many of the common file tasks, including opening and saving documents, printing, setting options, and sharing options.
Instead, when you click File, you are taken to the area that Microsoft calls the “backstage.” This is the area where you work with your worksheet and Excel as a whole, rather than individual changes within the worksheet. The File tab works differently than any of Excel’s other ribbon tabs as it does not give a set of commands on the ribbon. This means you don’t have to keep going back and forth from the keyboard to the mouse! File Tab / Backstage Remember, shortcut keys allow you to navigate the tabs and ribbons without having to use the mouse. So, to add to your collection here are the Excel 2016 tabs/ribbons shortcut keys. In previous blogs, I’ve given you the shortcut keys to both Word and PowerPoint.