Tips for improving Excel usage

nnThese are some tips that we will give to have a better handling of Excel, since to be able to manage this spreadsheet fully.n

nt
1. In order to quickly select a range of cells using the “F5” key, we press it in reference and type it in the direction of going or the range we want to select, then press the accept button.

nt

2. To select numerical cells within a sheet we can select them as follows: press the “F5” key, then click the special button, then select the constants, then activate only the number box and press the accept button.

nt

3. If we want to quickly select a range of cells around the active cell we will do so as follows: press the “F5” key first, then click the special button, then select the current region, press the accept button finally.

nt

4. If we want to change the name of a sheet within a workbook, we do it this way: we double click on the label of the sheet, then we type the new name to put on the sheet, finally press the key between.

nt

5. Many times it happens to us that we want to organize the sheets within the workbook and we want to move a sheet of one position and we do so: clicking on the label of the sheet, then we press the mouse dragging the label of the sheet to the new position where it will be, then we stop pressing the mouse.

nt

6. If we want to copy a sheet into the book we will do the same procedure as before, but this time instead we must keep the “CTRL” key pressed: we click the label on the sheet, then press it and keep it pressed the “CTRL” key, we drag it wherever we want to put the copy, then we release the mouse and the key that we had pressed.

nt

7. In order to group several sheets of a book we do it as follows: we click on the labels of the first sheet, then to select several sheets consecutively, we click on the first label of the first sheet, then press the key “MAYUSCULA” (shift), we click on the last label of the last sheet to select, then to select the sheets, not consecutively we hold the key “CTRL” while clicking on the labels of each sheet.

No, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no. no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no,