![]() Unique cell formats/cell styles: Maximum of 64,000 Maximum number of line feeds per cell: Maximum of 253 linesĬolors in a workbook: Maximum of 16 million colors (32 bit with full access to 24 bit color spectrum) Number of characters that a cell can contain: Maximum of 32,767 charactersĬharacters in a header or footer: Maximum of 255 characters Page breaks: Maximum of 1,026 horizontal and vertical Linked sheets: Limited by available memory Zoom range: Maximum of 400 percent (minimum is 10 percent) Named views in a workbook: Limited by available memory Windows in a workbook: Limited by available memory Names in a workbook: Limited by available memory Sheets in a workbook: Limited by available memory (default is 1 sheet) Open workbooks: Limited by available memory and system resources Worksheet size: Maximum of 1,048,576 rows and 16,384 columns Click the Ribbon Display Options arrow in the upper-right corner of the Ribbon.Excel Worksheet and Workbook Maximum Limits and Specifications.The Ribbon is designed to respond to your current task, but you can choose to minimize it if you find that it takes up too much screen space. These tabs contain special command groups that can help you format these items as needed.Ĭertain programs, such as Adobe Acrobat Reader, may install additional tabs to the Ribbon. These commands will also be helpful when preparing to print a workbook.Ĭontextual tabs will appear on the Ribbon when working with certain items, like tables and pictures. ![]() The View tab allows you to switch between different views for your workbook and freeze panes for easy viewing. These features make it easy to share and collaborate on workbooks. You can use the Review tab to access Excel's powerful editing features, including comments and track changes. The Data tab makes it easy to sort and filter information in your workbook, which can be especially helpful if your project contains a large amount of data. These commands will help you calculate and analyze numerical data, such as averages and percentages. The Formulas tab gives you access to the most commonly used functions and formulas in Excel. These commands will be especially helpful when preparing to print a workbook. The Page Layout tab allows you to change the print formatting of your workbook, including margin width, page orientation, and themes. The Insert tab allows you to insert charts, tables, sparklines, filters, and more, which can help you visualize and communicate your workbook data graphically. The Home tab is selected by default whenever you open Excel. The Home tab gives you access to some of the most commonly used commands for working with data in Excel 2013, including copying and pasting, formatting, and number styles. You will use these tabs to perform the most common tasks in Excel.Ĭlick the arrows in the slideshow below to learn more about the different commands available within each tab on the Ribbon. The Ribbon contains multiple tabs, each with several groups of commands. The RibbonĮxcel 2013 uses a tabbed Ribbon system instead of traditional menus. It continues to use features like the Ribbon and Quick Access toolbar, where you will find commands to perform common tasks in Excel, as well as Backstage view. If you've previously used Excel 2010 or 2007, Excel 2013 will feel familiar. To do this, click and drag the vertical or horizontal scroll bar. The scroll bars allow you to scroll up and down or side to side.
0 Comments
Leave a Reply. |