Mention the steps to your friend how to select rows and columns
Answers
Answer:
Select one or more rows and columns:-
1) Select the letter at the top to select the entire column. Or click on any cell in the column and then press Ctrl + Space.
2) Select the row number to select the entire row. ...
3) To select non-adjacent rows or columns, hold Ctrl and select the row or column numbers.
PLZ MARK AS BRAINLIEST ANSWER, FOLLOW ME AND THX FOR THE SUPERB QUESTION
Answer:
SELECTING A ROW OR ROWS IN MICROSOFT EXCEL
IN THIS ARTICLE WE WILL LEARN HOW TO SELECT THE ENTIRE ROW USING MOUSE IN MICROSOFT EXCEL. IT IS REALLY TIME TAKING.THE VILLAIN GIVEN TIPS WILL HELP YOU TO SAVE YOUR TIME AND DO YOUR WORK FAST BY THE SELECTING ENTIRE ROW.
let's take an example to understand to insert or delete a row or column.
we have data in excel in which column a contains agent name, column B contains City, column C contain cells amount and we need to return the total value in cell C 16.
how to select row in Excel?
in excel we have shortcut key to enter entire row in data. we need to follow below given steps to select row in Excel:
- we want to select a row in between 3rd row
- select a cell in 3rd row.
- and press the key shift + space on your keyboard.
- entire row will get selected in your data.
how to select rows in Excel?
follow below given steps:
- we want to see let a row in between 3rd 4th and 5th row.
- select a cell in each row.
- entire rows will get selected in your data.
another way to select a row in with the mouse. just click with your mouse on the row number and to select the rows, click with the mouse on the row number then hold the mouse pointer and drag it till 5th row and then release it.
and if we want to select from first row to end row , we can use shortcut key to select the data from first row to end row.
follow below steps:
- select first row by pressing the key Swift + space.
- when press control + shift + down arrow key.
- colours will get selected till the last non blank row.
this isthe way we can select row and multiple row by using the shortcut key and can save our time.