No products in the cart.

Which function is used for filling …

CBSE, JEE, NEET, CUET

CBSE, JEE, NEET, CUET

Question Bank, Mock Tests, Exam Papers

NCERT Solutions, Sample Papers, Notes, Videos

Which function is used for filling the complete cell with *sign
  • 1 answers

Meghna Thapar 4 years, 8 months ago

Press [Ctrl] + [Enter] and Excel will copy the respective formula to all blank cells in the selected range. This keyboard shortcut can be used as a quick way of filling a lot of cells or copying a formula into a range when it is entered, rather than copying it separately afterwards.

Here are the steps to fill the series of numbers:

  1. Enter a 1 in the first cell and press Ctrl+Enter to keep the cell selected.
  2. Press & hold the Ctrl key.
  3. Use the fill handle to drag the number down one cell. A 2 will be placed in the next cell.
  4. Double-click the fill handle to perform the fill series on the column.
http://mycbseguide.com/examin8/

Related Questions

Define networking with two examples
  • 1 answers
Ch 1check point
  • 0 answers
Draw the flow chart.
  • 0 answers
Symbols are basically of
  • 1 answers
Python programming
  • 2 answers
What is database system
  • 2 answers

myCBSEguide App

myCBSEguide

Trusted by 1 Crore+ Students

Test Generator

Test Generator

Create papers online. It's FREE.

CUET Mock Tests

CUET Mock Tests

75,000+ questions to practice only on myCBSEguide app

Download myCBSEguide App