To make a novel all capital letters in Excel, you can first highlight the text. Then, go to the 'Home' tab and look for the 'Change Case' option. Select 'UPPERCASE' from the dropdown menu.
One way to give a novel capital letters in Excel is by using the formula. Select the cell where you want the result to appear, type =UPPER(original_cell) and it'll convert the text in that original cell to all caps. Another method is to manually change the case by selecting the text and using the keyboard shortcut Shift + F3 to cycle through different case options until you get to all uppercase.