New FLASH SALE Dhamaka - Flat 60% Off on All Courses

    Question

    How can you freeze both rows and columns in an Excel

    spreadsheet?
    A Use the "Split" command from the "View" tab Correct Answer Incorrect Answer
    B Select the rows and columns to be frozen, then right-click and choose "Freeze Panes" Correct Answer Incorrect Answer
    C Use the "Lock" feature from the "Format" menu Correct Answer Incorrect Answer
    D Press Ctrl + F to freeze both rows and columns Correct Answer Incorrect Answer
    E none of these Correct Answer Incorrect Answer

    Solution

     Select the rows and columns to be frozen, then right-click and choose "Freeze Panes." This option allows you to freeze both rows and columns to keep them visible while scrolling through large datasets in Excel.

    Practice Next

    Relevant for Exams: