Lesson 8

Preview

Excel Basic Information

By default, Microsoft Excel uses Calibri font size 11 as Body Font when you type data in a worksheet, header or footer, or text box. You can change the default font and font size for all new workbooks that you create by entering the Backstage View and selecting the Excel Options category, General section.

  • The default column width is 8.43 characters.
  • The default row height is 15 points.
  • Points and characters use 2 different measuring systems. A 20-character column width does not equate to 20-points in row height.

Worksheet Specifications and Limits

Specification Limit
Open Workbooks Limited by available memory and system resources
Worksheet Size 1,048,576 rows X 16,384 columns
Column Width 255 characters (default width 8.43 characters)
Row Height 409 points maximum (1 point = 1/72 inch) Row height default is 15 points
Page Breaks 1026 horizontal and vertical
Total Characters in a Cell 32,767 characters
Characters in a header/footer 255
Sheets in a Workbook Limited by available memory (default is 1 sheet). Excel does not crash on its own accord, although it will eventually quit responding if you overtax the RAM memory allocated to the PC.
Undo Levels 100
Zoom Range 10% to 400%
Users who can open and share a shared workbook at the same time 256


END OF LESSON

Back to: Intro to Excel 2016 > Module 3 Intro to Excel 2016

Leave a Reply