How To Do A Excel Spreadsheet

What is difference between worksheet and workbook?

Workbook is an excel file containing many worksheets. A worksheet has a single spreadsheet containing data.

What does Ctrl I do in Excel?

Press Ctrl + 1 to open the Format Cells dialog, Ctrl + B to apply or remove bold formatting, Ctrl + I to apply or remove italic formatting, and Ctrl + U to apply or remove underline.

What are the steps to open spreadsheet?

  • Click File > Open > Computer > Browse.
  • To only see files saved in the OpenDocument format, in the file type list (next to the File name box), click OpenDocument Spreadsheet (*. ods).
  • Find the file you want to open, and then click Open.
  • Related Question how to do a excel spreadsheet

    How many worksheets are in a workbook?

    By default, there are three sheets in a new workbook in all versions of Excel, though users can create as many as their computer memory allows. These three worksheets are named Sheet1, Sheet2, and Sheet3.

    Why do you freeze some rows columns in a worksheet?

    Answer: When you freeze panes, Microsoft Excel keeps specific rows or columns visible when you scroll in the worksheet. For example, if the first row in your spreadsheet contains headers, you might freeze that row to make sure that the column headers remain visible as you scroll down in your spreadsheet.

    How many rows and columns are there in a worksheet?

    1,048,576 rows
    Feature Maximum limit
    Total number of rows and columns on a worksheet 1,048,576 rows by 16,384 columns
    Column width 255 characters
    Row height 409 points
    Page breaks 1,026 horizontal and vertical
    Posted in FAQ

    Leave a Reply

    Your email address will not be published. Required fields are marked *