LIVE Course for free

Rated by 1 million+ students
Get app now
JEE MAIN 2023
JEE MAIN 2023 TEST SERIES
NEET 2023 TEST SERIES
NEET 2023
CLASS 12 FOUNDATION COURSE
CLASS 10 FOUNDATION COURSE
CLASS 9 FOUNDATION COURSE
CLASS 8 FOUNDATION COURSE
0 votes
163 views
in Computer by (30.0k points)
closed by
In Excel, what shortcut key is used to fill the selected cell with active cells to the right?
1. Ctrl + S
2. Ctrl + R
3. Ctrl + D
4. Ctrl + V

1 Answer

0 votes
by (30.0k points)
selected by
 
Best answer
Correct Answer - Option 2 : Ctrl + R

​The correct answer is Ctrl + R.

  • In Excel, shortcut key Ctrl + R is used to fill the selected cell with active cells to the right.
  • In Microsoft Excel and other spreadsheet programs, pressing Ctrl+R fills the row cell to the right with the contents of the selected cell.
  • To fill more than one cell, select the source cell and press the Ctrl+Shift+Right arrow to select multiple cells. Then press Ctrl+R to fill them with the contents of the original cell.
  • In Microsoft Word, Excel, and other word processor programs, pressing Ctrl+R aligns the line or selected text to the right of the screen.

 Shortcut key Description
Ctrl + S
  • In Microsoft Excel and other spreadsheet programs, pressing Ctrl+S saves the current worksheet.
  • If it has never been saved, the Save As the window opens, allowing you to choose a name and file extension for your worksheet.
Ctrl + D
  • In Microsoft Excel and Google Sheets, pressing Ctrl+D fills and overwrites a cell(s) with the contents of the cell above it in a column.
  • To fill the entire column with the contents of the upper cell, press Ctrl+Shift+Down to select all cells below, and then press Ctrl+D.
Ctrl + V
  • In Microsoft Excel and other spreadsheet programs, pressing Ctrl+V will paste anything stored in the clipboard into the currently-selected cell.
  • If you've copied more than one cell, Ctrl+V will paste them starting from your current position.

 

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.

Categories

...