LIVE Course for free

Rated by 1 million+ students
Get app now
0 votes
in Computer by (30.0k points)
closed by
Which of the following keyboard shortcuts is used to strike through the contents of a cell in MS Excel 2010?
1. Ctrl + P 
2. Ctrl + S
3. Ctrl + 6 
4. Ctrl + 5 

1 Answer

0 votes
by (54.0k points)
selected by
Best answer
Correct Answer - Option 4 : Ctrl + 5 

The correct answer is Ctrl + 5.

  • Ctrl + 5 is the keyboard shortcut that will automatically apply the strikethrough formatting in Excel.
  • Just select the cell where you want to apply the strikethrough format and press Control + 5.
  • If you want to apply this to a range of cells, select the entire range of cells, and use this keyboard shortcut

Some important shortcuts used in MS Excel:

  • Ctrl + N Create a new workbook.
  • Ctrl + O Open an existing workbook.
  • Ctrl + S Save the active workbook.
  • F12 Save the active workbook under a new name, displays the Save as dialog box.
  • Ctrl + W Close the active workbook.
  • Ctrl + C Copy the contents of the selected cells to Clipboard.
  • Ctrl + X Cut the contents of the selected cells to Clipboard.
  • Ctrl + V Insert the contents of the Clipboard into the selected cell(s).

Welcome to Sarthaks eConnect: A unique platform where students can interact with teachers/experts/students to get solutions to their queries. Students (upto class 10+2) preparing for All Government Exams, CBSE Board Exam, ICSE Board Exam, State Board Exam, JEE (Mains+Advance) and NEET can ask questions from any subject and get quick answers by subject teachers/ experts/mentors/students.